Giving Total in Report

Due to the amount of product we sell, we use and item movements report rather than a detailed sales report. It would be nice to have the total displayed on the report, without using the expanded 'Overall,' as this makes the report twice as long. Does anyone know how to do this?

Reply to
Patrick
Loading thread data ...

What total are you after? total item count? total sales? total cost? Sales and Cost are not really accurate in an Item Movement, because each movement may be sold at a different price ( Price levels, discounts, sales, etc...).

In any case, I'm not sure why your movement report is easier to deal with than a detailed sales report - Item Movement has both Sales/Returns and inventory transfer/receiving information - it seems like this would actually be longer. I think that what you really want is a detailed sales report grouped by itemlookupcode, but I could be wrong.

Reply to
Glenn Adams [MVP - Retail Mgmt]

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.