Giving Total in Report

Posted by Patrick on July 3, 2005, 10:00 am

Please log in for more thread options

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?

Posted by Glenn Adams [MVP - Retail Mgmt on July 6, 2005, 8:05 pm

Please log in for more thread options

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.

--
Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information

> 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?