This article describes how to resolve the MYOB connection error 47: Excessive inventory value. This is a critical error.
​
Allowing negative item amounts to be recorded in your inventory affects the reporting of inventory values and cost of goods sold.
​

To allow these transactions to move from WMS to MYOB:

Sales

1. Log in as superuser, go to Tools > Preferences > Replication Tab.
2. Change the Send option to “Post Sales to MYOB as ORDER”.
3. Invoice the sale from the despatch register. For more information please see Invoicing Sales.
4. Search for and open the Sale in MYOB and convert it to an invoice, when recording the item, numbers will be shown that have insufficient stock on-hand.
5. It is recommended that the item quantity on-hand is manually adjusted in MYOB.
6. The sale can now be recorded.
7. A full system stock reconciliation should be performed at a later date.
8. Remember to change the preference setting back once the issue is resolved.

Adjustments, Purchases, Work Orders

1. Log in as superuser, go to Tools > Preferences > Replication Tab.
2. Change the Send option to “Post purchases to MYOB as QUOTE”.
3. Resend the transaction by opening it via Show Item history (CTRL H) and clicking on the 'Create MYOB Adjustment' option.
4. Search the purchase history for orders at the location card the adjustment was made, convert to a bill and record to review the insufficient items.
5. It is recommended that the item is manually adjusted in MYOB.
6. The purchase can now be recorded.
7. A full system stock reconciliation should be performed at a later date.
8. Remember to change the preference setting back once the issue is resolved.

None