Hi Gail,

Which database are you wishing to generate the report from. Order Entry? Sales Analysis?

If there isn't a standard built-in report that gives you this information, it seems pretty reasonable to use either GridView or Crystal Reports for Adagio to generate this, depending on whether the information is to be a presentation-quality report (use Crystal) or for speedy access to information (GridView).

Whichever reporting tool you use, base the report on the sales header and detail files, which will give you all the information you requested. Include a filter for the date range, listing only sales for that time period. Summarize the report by customer and item.

If you are using Crystal Reports, a trick is to sort the details by date (oldest to newest) and insert the Unit Price into the sub-total by item section. This will print the Unit Price for the last detail, which will guaranteed to be the newest invoice for each item, because the details are sorted by date.