How to generate a report of invoices by month?

[Rochelle_505]

Hello everyone,

I need to find out if there is a way to generate a report that will be run overnight (due to the size) by customer# and month. The report will be generated from invoices, and will show what the customer ordered and in what month it was ordered. Can a print button be assigned a script to run this report once a month?

[Ender]

I don't see why this report would take that long to run. How many total line items and how many line items per month are there? (I say line items because if you want details of what was ordered, this report is best run from the Line Items file.)

[Rochelle_505]

The report takes so long because of pictures that need to be printed by corel draw and inserted into this report, pictures are of the finished product. The procedure right now is a back and forth type of method.First a report is generated of invoices sorted by supplier# and month, then using that as a key,we go back to corel to find the picture of their finished product to print, then on to the next invoice and picture, etc. There are about 10-15 line items per invoice.

Wishlist:

Have a report of invoices that shows customer name, linked by SAP# and Product#, sort by month, insert picture in sequence with invoice ID#, with a print button that is run by a script. This way we won't have to collate over 500 pictures with their correct invoice printout individually.

Problems:

1. Supplier and customer databases are not seeing each other, customer name is not coming up on report or invoice.

2. How to do a supplier to many line items relationship?

3. How to insert a corel draw picture?

4. How to script a print button to do this manually?

Thanks for any responses generated!!!

Attached a .gif.