Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
I am trying to create a report that gives me a detailed description of something that was sold.
We run a collective through my MYOB system and I buy items on consignment. Each consignment supplier has a generic item code. But the products are not inventoried as our business does not own them.
I can find a report that will provide a detailed description of our inventory but, not of any items that aren't inventoried.
The consignment supplier needs a record of what was actually sold. Is there any way to do this without going into each individual sale? (as that way will prove very time consuming)
I assume you are using MYOB Accountright.
If you are after a report that breaks up sales you could try running the Sales (Customer Detail) report?
That will show invoice line items for all customers you select within a date range.
Let me know if this helps or if you are wanting more information in your report,
After a bit of work and ticking a few boxes, that did give me a lot more information that I needed. However, is there anyway to isolate the report to just one item number? I don't want to send the entire report to each collective member. Each members' totals should really be confidential.
As the primary focus of the Sales [Customer Detail] report is the sales to each customer, it isn’t able to be filtered by a single inventory item. If you were wanting this report to show a single inventory item’s sales the report would need to be exported to Excel and then edited to just show sales for that single item.
You may also want to try the Sales [Item Detail] report. Unlike the aforementioned Customer Detail report this report is focused on the items sales and not the customer who purchased them.
Unfortunately the Sales [Item Detail] report only shows the Generic Item Description, not the added description that was added at time of sale.
It seems like exporting to Excel will be time consuming, when this really seems like something that could be done within MYOB with one little tick.