Modules»Inventory Control»Cost Based on % of Price
  • RSS Feed

Last modified on 3/2/2016 11:44 AM by User.

Cost Based on % of Price

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) 

 

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.