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!
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.
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.