Advanced reporting on items sold
For the purpose of the exercise, lets say my business buys and sells apples, oranges and grapes. Each item is set up individually in MYOB as an item we buy, sell and inventory
When we invoice these items out individually there is no problems with running reports on the items to work out how many of each we sold over a day month or year.
However we also sell fruit boxes which have a set number of each item and fruit boxes have its their code. (lets say 2 apples 2 oranges and 1 grape per fruit box) Customers often order multiple fruit boxes at a time.
This fruit box code uses the auto build feature to take the 2 apples 2 oranges and 1 grape from the inventory of the individual apple, orange and grape codes.
I cant find any report that picks up the sales of the individual apples oranges and grapes sales plus the apple orange and grapes sold as part of the fruit boxes .
In summary I can’t report on the total number of apples, oranges and grapes we sell in a month because the reports seem to only count sales where we use the individual item codes .
Can you advise if you have any solutions
