Example:
Prices for some items are negotiated for individual customers, and the cost of those items need to be a constant percentage based on the price negotiated.
Solution:
The item number will first need to be changed (or added) to reflect the percentage desired.
Example: The constant cost of existing Item # 627-2737 needs to be 20% of the price entered in Order Entry and Editing (Task 1 in OE)
That item # should be changed to: 627-02037. This can be accomplished by using the "Change Item Number" routine. The program can be found in:
-
Inventory (Module 5)
-
System Management Functions (Task 32)
- Change Item Number (Sub-task 10)
-
System Management Functions (Task 32)
The first 3 digits after the item prefix are what determine the percentage that will be used. In this example, (627-02037) the percentage is 20 percent. Therefore, the cost of this particular item would be twenty percent of the price entered on a sales order. If the price entered on the order is $1.00, the cost will be 20 cents. If the item number was not changed, the cost would be 273% of the price entered on the order because the first three digits after the prefix are 273.
NOTE: A number of fields on the Item Master must be set specifically for the scenario to work properly.
1. The Price fields (#11 - 19) for the item must be zeroed out.
2. The Quan Table field (#30) needs to be N/A to disable any table reference.
3. The Net Priced? Field (#28) MUST to be a C to trigger the calculation.