Always make a backup of the file first before making changes. Do not allow users to continue to work with the file as this change is fundamental to the way MYOB records sales and purchases.
​

Run reports to provide total value of stock on hand and stock lists by location. It is assumed that you will have or be creating STF imports for each location to be loaded into the WMS during initial replication. Export on hand reports to Excel for safe keeping.
​

Via the Inventory Stock Count form, each location is counted to ZERO. It is critical this is done one location at a time. MYOB has an issue with ROUNDING and VALUATION which can cause the Inventory Adjustment for the entire inventory list to fail to record. In creating a Zeroing Inventory Adjustment per Location it solves two issues. First, avoids the rounding valuation error and secondly, it allows each location adjustment to be exported and manipulated to re-target the stock at the new MASTER location via re-import.
​

Create a NEW MASTER/DEFAULT location (For example: MWHS) in the MYOB Location List. Please assign this as a DEFAULT.
​

Once each Adjustment is completed, EXPORT and IMPORT the item list using FILE > EXPORT > ITEMS > replacing the DEFAULT LOCATIONS with the new MASTER LOCATION and re-import the item list file. If possible only import the INVENTORY ITEMS and use match on Item Number, to avoid corruption of data fields that can occur when using EXCEL.
​

Export each Inventory Adjustment Journal using FILE > EXPORT > Inventory Adjustments especially from within Excel - Change all negative values to positive values and FIND & REPLACE the original location field with the NEW MASTER LOCATION. Save this file as TSV (Tab Separated).
​

Re-Open this file from NOTEPAD. Go to the end of the file and end of last import line > press ENTER TWICE. This is to correct a bug in the MYOB IMPORT ROUTINE. Otherwise, it will NOT IMPORT THE FILE.
​

REPEAT, IMPORT FOR ALL LOCATIONS. Once complete, run the VALUATION report. It should reconcile with the original total value of stock on hand. In many cases some ROUNDING ERRORS will see a minor difference in the overall valuation per location.
​

In order to complete the GoLive process create STF imports from the Inventory Adjustments used to correct MYOB by taking the ITEM NUMBER and QUANTITY columns and mapping these to an STF TEMPLATE > completing the required columns for LOCATION > BATCH > BIN > LOT as necessary.
​

For sites using BATCH or BIN allocation, the STF import is usually created from a physical stock take/count. It is then a requirement to RECONCILE this stock count with the MYOB count.
​

In general, for this circumstance we recommend a stock count be performed PRIOR to the re-allocation of stock and that WRITE-OFFS/UPS are completed in MYOB prior to this process. In this way, any possible errors are not LUMPED onto the MIGRATION DATA MANIPULATION exercise. This can stymie the entire GoLive right from the outset and is easily avoidable.