Description

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.

Detail Steps

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”(Log in as superuser, go to Tools,
Preferences, Replication Tab)
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”(Log in as superuser, go to
Tools, Preferences, Replication Tab)
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.

Related Information

None