Hi- I need a report that has the following-item #, description, cost, retail price, qty sold (rolled up so all the items sold that day or week with that description total), qty on-hand(by store not total chain wide). Thank you in advance for any help!
best seller report
May 02, 2006
5 Replies
J,
This will do what you are asking and more.
J,
Put this one in the HQ\Reports folder
Betsy,
The zip code feature is very helpful if one wishes to see where their sales are coming from and you know how to manipulate the report.
Attached is an updated version of the report as the old version was giving wrong info about the store's on-hand quantities and some totals were averaged instead of actual.
What does "rolled up" mean to you, that doesn't seem to be in my dictionary. If you mean "Totaled", then drag the ILC column to the left, so that its the very first column, each ILC is now "Totaled". Now if you _only_ want to see totals, click on the 8th icon on the top to Collapse All Groups.
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required