We are having trouble with our inventory COG. Unfortunately MYOB is calculating the wrong COGS when a sale has taken place on one particular item (that I know of). This has caused a value to be still in the inventory detail item report but no items in stock. Although the inventroy reconciliation report is showing the correct value and item amount as "0". I do not know how to correct this wrong COG entries and get the inventory detail item report to show '0" value and "0" SOH. The correct COGS is $5.96 which changes on the 14/11/2023 and MYOB is calculating the wrong COG values from this date. See the attached report.
Hi @MelinC,Thank you so much for your detailed post and my apologies for the late response. We do have a script available online that can address this issue. I've sent you a private message to gather additional information, which will assist us in resolving this matter.Looking forward to hearing from you soon!Regards,Earl
Self-help & Learning
Level up your skills and find answers across all MYOB products
Help Guides
MYOB Academy