Heya
Brisbane based MYOB Certified Consultant over 20 years experience especially with MYOB AR Inventory. Happy to help. Please feel free to call me on 0413 584 818. Happy to chat and come on site (depending on where you are!)
Thanks
Sas
Hi DePez , the adjustment you have made reduces stock by $66,413.46, and increases cost of sale by the same amount, therefore reducing profit. But the initial sales of the product were made for zero cost, and therefore the profit on those sales was 100%, a lot higher than it should have been.
So the adjustment you made is bringing the cost of sales back to a more accurate figure and must not be deleted.
It is not possible to change prior build entries, and unfortunately it is no longer possible to force a change to the cost of sale on an item invoice by editing and re-recording it.
Run an Analyse Sales (Item) summary report for the period of those sales and multiply out the unit sales times $517.39 and see how close to the $66k it comes. This helps to validate the adjustment. If you want to see the invoice detail for those sales, run an Item Sales Detail report and edit the report to show extra fields (gross margin dollars and percent).
