System Five Add-Ons & Integrations help simplify the way you do things.
Our catalog of services has topic-based, role-based, or technical plans that can help you maximize your software investment.
Copyright © 1984-present
Windward Software Systems Inc.
All Rights Reserved.
Privacy Policy
This is an old revision of the document!
You will need to create the Do It Best supplier account before doing anything else.
Make a note of the unique number of the supplier account as it will need to be entered into the “orderconfirmation.xsl” file.
When you edit the xsl file; the <DIBMember> is the account number from Do It Best. The <SupplierID> is the supplier unique number from System Five.
example
<config:settings> <DIBMember>12345D</DIBMember> <SupplierID>49</SupplierID> </config:settings>
The DIBMember is specified from Do-It-Best. You can find this inside the first row of the “ORDCNFM_010” file.
Next you will need to set up the following categories as per Do-It Best's category structure.
Categories as of December 2014 are:
Main Cat# Description
* You must create these categories, and if you have already assigned these inventory categories to something else, you will need to change those categories so that they use numbers that are not being used by the Do It Best Integration. *
Extract the DoItBest.zip file to a DoItBest folder in the System5\Bin folder.
The first thing you need to do to set up the Purchase Order Confirmation will be to open System Five and determine the unique number of the Do It Best supplier account.
Go To setup Tools - Utilities - XML Central
Follow the instructions in the self help for setting up import
http://mywindward.wws5.com/selfhelp/viewarticle.php?f=t&u=http://mywindward.wws5.com/selfhelp/helpfile/systemfive/index.html?intdoitbestpurchaseorderinfo.htm
Next you will need to download your import files from Do It Best.
If You have not already done so, you need to extract the DoItBest.zip file to a DoItBest folder in the System5\Bin folder.
open System Five and from the navigator:
Access Inventory and Purchases > Data Load > Part Load The current inventory update file is always in FILEMNT_010. POSLOAD_010 contains all inventory items and is intended only for system initialization and startup.
The instructions in the System Five help file are incomplete. So ignore them and follow the instructions below:
To load all inventory you need to use the POSLOAD_010 file from Do-It-Best
To load it you will use the dataload in System Five.
The options screen should load with the following options:
The time required to process will depend on the number of items being updated.
The data load will load all the parts into categories defined by the dataload, but it will not give the categories any names.
So the integration assumes that the end user has already setup the main and sub categories, and has created them in compliance with Do-It Best's category structure mentioned at the beginning of this document.
Access Inventory and Purchases > Data Load > Part Load
The current inventory update file is always in FILEMNT_010.
To update the existing inventory you need to use the FILEMNT_010 file from Do-It-Best
Again… The instructions in the help file are incomplete. So ignore them and follow the instructions below:
Select [Next] to view/set column options.
Created by Steve Wind Dec 22 2014
[[http://mywindward.wws5.com|{{ http://wws5.com/support/images/cust_support_banner_bottom.jpg |myWindward