Inventory discrepancies

Hi HethBennett 

Using MYOB to manage inventory is anything but simple. There are so many settings that affect the accuracy. Internal procedures need to be robust and strictly followed by all staff. Regular checking and reconciliation of the Inventory Value Reconciliation report is a must. If discrepancies keep occurring, it is important to isolate, identify and resolve.

On top of all this, the inventory module within AR2024 has more bugs in it than any other module. Many have been fixed. Many remain unfixed. Users continually ask MYOB to 'run a script' to fix known bugs.

There is nothing in your attachments that can explain any discrepancy on the on hand count for this Item. The explanation given by the moderator is 'odd' given the first sentence is exactly what you are supposed to do and this should not give rise to any hiccups.

If the inventory accuracy is important, I suggest you get someone who specialised in MYOB inventory to check your settings and procedures to help identify the cause. Best to sort this before it becomes too messy.

Using Receive Items itself is not the problem. How you use it might be. For example creating a new purchase instead of converting the existing Order will affect on hand count.

The accuracy of On Hand count can be affected by many other factors, eg settings, staff using wrong Item Number on Invoice, staff picking the wrong item, delivery count incorrect, theft etc etc. Do you use Autobuild? 

The accuracy of the value is usually affected by settings, incorrect adjustments or bugs. For example do you know why the original Order showed $1685.80 as the cost for this item, yet the Item Transaction shows $1,837.85?

If you don't have a MYOB consultant who specialises in Inventory, try MYOX Services - they should be able to review the file and advise how to fix the issue.

Regards

Gavin