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 Feature allows you to load Sell Through allowance details into your existing Inventory Items using a specially designed Data Load.
Once in the Data load you select the file from your desk top.
If you are unfamiliar with Data loads and/or Part loads follow this link to the information on this and review it before proceeding.
http://mywindward.wws5.com/selfhelp/?s=part+load&video=on
There are several fields you can load into the Sell Through Allowance through this load, listed here:
In practice you will likely not require the use of all of these fields to successfully add a Sell Through Allowance. Simply Choose the fields that apply to your specific sell through allowance as indicated by your supplier. A sample screen shot of a STA data load follows:
It is essential that the Excel file you edit to create the CSV file be formatted as text before saving.
You will also notice that for effective use not all of the columns the supplier gives you are loaded. Map the appropriate columns to set up your Data Load as desired.
Try this in your training data first as it may take some trial and error to make this work the way you desire.Underlined Text
Some of the features marked above are better set as defaults after clicking the next button.
Once everything is mapped click the Next button.
This area allows you to select default load settings.
Default Department : set to all departments unless you change it. At the time of this writing I have not tested setting the STA to specific departments.
Once you have selected the defaults and mapped the appropriate columns complete a trial load into your Training Data.
This Load DOES NOT CREATE new parts. The parts must exist in your live inventory in order get the STA load to work. It also will not detect parts in your virtual warehouse.
At this stage click the NEXT button.
As per regular data loads double check the Column settings here and perform the load.
Now spot check your results by editing an Inventory item that was in the load and entering into the Sell Through Allowance tab.
an example of the results follows: