User Guide
1. General Information
2. Starting Up
3. Connecting data
4. Demand and Sales Forecasting
5. Inventory Planning
6. Reference
1. General Information
2. Starting Up
3. Connecting data
4. Demand and Sales Forecasting
5. Inventory Planning
6. Reference
There are situations when one product should be replaced by another one. For example, they are equivalent, or one of them is going out of the market and another one is a newer version of the former. Then the sales history and inventory information of the discontinued product and the new item are merged.
Streamline allows making substitutions easily. There are two ways to do substitutions in Streamline. The first concerns making a single substitution. The second designed to make a set of substitutions at once.
Now the histories are merged.
To update the forecast, click the Forecast button.
To make a number of substitutions at once, Streamline allows you to define them as a set of substitution rules, and apply them all by a click of a button. To do that, do the following:
The description of the dialog and the explanation of how to define the rules are given below.
The dialog has a table, displaying a list of rules, and buttons used to manipulate those rules. There are two types of rules: removal rules and substitution rules. Each rule is represented by a single line in the table.
The rules get into the list in two ways. The first way – by using the menu Item > Remove from import or Item > Substitute commands. In this case, the rules are added to the list and applied automatically. Another one is to edit the list manually using a dialog opened by the Edit button click. In this situation, the rules won’t be applied automatically. To apply them, click the Update data button after you close the dialog.
The rules and the result of their application are saved in the project except for the In use flag. Thus, when you open the project and call the dialog, all the rules will have the Unknown label in the In use column of the table.
Table description
The Source item code column shows the item code that was substituted or removed.
The In use column indicates whether the rule is in use now (Yes) or not (No). The Unknown indicates that the rules have been edited manually using the Edit button but not applied now.
The Substitute with column shows the item code used as the substitution for the source code if the rule is substitution type. Removal rules are labeled as ‘(removed)’.
Buttons
Clear button removes all the rules from the list.
Remove button removes the selected rule from the list.
Edit button is used to change the list of the rules. The button switches the dialog in the list editing state shown below.
Here you can manually enter the rules using the following syntax:
<Source item code>,<Target item code>
.<Item code to be removed>
.Apply button saves the changes you made to the list of the rules.
Revert button returns the list to the previous state.