Hi cre8ivedan
Unfortunately this is common in AR2024 files - there are still far too many bugs in the inventory module. Basically ignore the inventory register reports, in most cases they are wrong! The actual value for an item's on hand count and value is in the Item Profile screen and in the Inventory Value Reconciliation report. Use these as the basis for any adjustment etc, as these are the figures MYOB will use for transactions. Do an Inventory Adjustment Journal to fix item on hand count or value. This will ensure COS calculated on subsequent sales is accurate.
While tempting to edit existing transactions to try to fix an error - many find this only makes the situation worse. If you have ongoing issues in inventory that you cannot resolve, get in touch with MYOX Services, they specialise in fixing these types of things.
Regards
Gavin
gavinw222@gmail.com
Wow I really hope that's not right, inventory is the only reason we use MYOB lol! I agree trying to fix it kind of broke everything, what a mess. Any idea how to fix the issue of that starting value in the item register being so far wrong? I assume that's the value that the Balance sheet uses?
Also funnily enough The value on the Balance sheet is the exact same as the number from the Items Register Detail Report and not the value from the Item Profile so it looks like the Balance sheet is using the numbers in the Items Register Detail Report which are the right numbers. So it's just the value in the item itself that is wrong and it's all caused by that initial value being wrong.
Hi cre8ivedan
You haven't shared the Item Profile screen (please do) to show the value of the item. And how can you tell that the value on the Balance Sheet is the exact same as the number from the Items Register Detail Report ($5037.88) unless this is the only item you have.
With Inventory there are 2 key values - the account balance of the inventory asset account (1.xxxx) which appears on your financial statements, and the values of all items stored in the Item Register. The 2 should match, however in your case it is unlikely that they do. Generate an Inventory Value Reconciliation (IVR) Report - this shows you the on hand count and value of all items as per the Items Register, and it also shows you the balance of the Inventory asset account, as well as any discrepancy. Any discrepancy should be resolved - just as you would for the Sales Register and Trade Debtors account balance. etc.
Attach a screenshot of the section of the IVR that shows this item's on hand count and value as per the register, as well the the Item Profile screen showing on hand count and value, also discrepancy at end of IVR report for the account used by this item.
Regards
Gavin
