WMS-MYOB Inventory Reconciliation Error

Created by Datapel Integration, Modified on Fri, 6 Jun at 4:20 PM by Datapel Integration

Description

Workflow Restrictions

“The master stock count in MYOB Item List does not match the ALL LOCATIONS stock count in WMS.” Or “MYOB reports stock on hand but WMS does not?”

This situation may occur in the following instance:

ITEM SALES of inventoried items were created directly in MYOB and then manually fulfilled, bypassing the WMS.

To identify a list of MYOB Sales that are not present in the WMS, run the MYOB Item Sales Detail Report and WMS Sales Report.

MYOB Sales Detail Report: Select REPORTS INDEX, SALES, ITEM SALES DETAIL. Add the MEMO field as an optional print column.

All WMS Sales will contain the Invoice# in the MEMO field and the word WMS.

WMS Sales Report: Select Reports, Sales, Summary.

Workflow Restrictions

In all cases, the WMS should be the master record of stockholding and the MYOB item inventory register reconciled with the WMS regularly.

CASE: Manual Item Sales Were Created In MYOB.

Print the INVOICE(S) created in MYOB.
Enter these into WMS Sales Module.
If the order was fulfilled and the stock removed from inventory, then MANUALLY PICK the stock used to fulfill the Order.
If the order is waiting to be shipped, allow the WMS to pick, pack, and ship the order automatically.
Invoice Shipped Sales, update the details on the ORDER from the original MANUALLY ENTERED Item Sale.
DELETE the manually entered ITEM SALE in MYOB, then CONVERT the WMS Order to a BILL.
Confirm the Item counts now reconcile.

CASE: Inventory Adjustments were made in MYOB.

Print the adjustments created in MYOB > Inventory Journals, these can be found by using the Item Register and setting a broad date range.
Print the Count Sheets for those items in the WMS.
Identify the stock batch/bin and location adjusted.
Enter the Adjustment Order in the WMS.
Confirm the Item counts now reconcile.

None