This document explains how MYOB AutoBuilds can be automatically converted to Item Purchase QUOTES using the Datapel WMS - Special function - CONVERT BOM.
In addition, the Datapel WMS has a superuser function designed for ONE-TIME use that allows the creation of BOMs or IMP files for import into MYOB.
1: Complete the initial replication and setup of the WMS - ensure the *ALL LOCATIONS card is present - this will be used to post the KIT/BOM instruction against.
2: BACKUP the MYOB Company file FIRST.
3: Select File - Purge… then click Convert AutoBuilds…
4: If you create BOM Item Purchase, they will appear in MYOB once the process completes.
5: Open the MYOB Company file and run a report using the Purchase Order # of the BOM filter to verify the line items are correct.
IF YOU ARE CHANGING FROM AUTO BUILDS TO USING WMS KITS:
1. RESTORE THE BACKUP - this will remove the newly created BOM Item Purchase quotes
2. Locate the IMPS folder used by WMS - in this, you will find the itm_purchs-XXXXXx.imp containing the last file used to initialise MYOB. Copy this file to the working implementation folder, then open this in NOTEPAD.
3. Search and Replace BOM with KIT.
4. DELETE THE LAST LINE of each ITEM PURCHASE - this will be the Item Code of the KIT - Kits do not require this line item.
5. Import this IMP file using FILE - Import - Purchases - ITEM.
6. Verify the new item purchase quotes are correct as above by running a report filtering by PO# KIT.
3. In the MANUAL PICK - select/pick the item batch, or if required, click ADD SERIAL#
4. Type in the SERIAL#, check it conforms and click YES to add the serial number.
5. REPEAT FOR EACH BAD SCAN CODE.
6. If any other items are RTP (for example, Freight) - Click Pick Stock to pick the order thoroughly.
7. Now CLICK FAST PACK or CLOSE the form and scan the Order Barcode to return to the QUICK DESPATCH workflow.
When moving from AUTOBUILD TO KITS - the AUTOBUILT item will have been INVENTORIED - you will need to change the existing INVENTORY ITEM NUMBER to a NEW CODE - we suggest using an x to prefix the item code - then make it inactive.
Before doing this, EXPORT the item list and update the ITEMS to create a NEW SET OF CODES with the same ITEM NUMBER that is NON-INVENTORY - that is - the ISTOCK is blank, and the Inventory account details blank.
IMPORT the updated ITEM LIST and the OLD INVENTORIED items will effectively be replaced by NON-INVENTORIED copies of the same codes.
Then perform a DETAILED REPLICATE.