Hi Team,
I want to generate a report that gives me a weekly total for each of the lines/items (about 10) my business sells.
All I want is the total of each item, not who the customer was.
When I run an Item sales report, it gives me the totals which is great.
However it also includes the customer, making pages and pages of data.
Can I generate a weekly report that shows sales of each item only?
(filtering out names of the purchaser)
Any advice appreciated
Herby
Hi Herby-Erb - thanks for your question.
Try the Item Transactions report (Reports > Index to Reports > Inventory tab > Item Transactions). You can choose the date range which lets you run the report for a week, a month - or whatever period you like.
You can also choose which columns to include in the report by clicking the Insert/Modify tab then clicking Show Hide.
I hope this helps!
Adrian
Hi Herby-Erb,
Thanks for your question. You can export the Item Sales report to Excel. Once exported, you can use Excel’s features to summarize the data by item and week, and remove or hide the customer columns. This approach allows you to create a concise, item-only weekly summary, but it does require manual steps outside of MYOB. More information can be found here: Exporting reports
I hope this helps!
Regards,
Earl
Thanks Adrian, but i cant find the "item transactions" tab.
Im using Accountright basics.
Im going in the reports tab, but cant find your suggestion
