Special Price, Installation

Note: For Installation Team use only:

The data in the table SPECIAL_FORMULA is used to define the Special Pricing formulas used by the customer. You can add as few, or as many formulas as you need to to describe the customer’s special pricing format.

The following table illustrates the possible formulas you can use. Simply add a new record to the table to include this pricing formula.

Formula ID	Description (Identifies the Special Pricing formulas used by the customer).
CAT	Item Category
DPT	Item Department
MAN	Item Manufacturer
GRP	Customer Group
NEG	Customer Negotiated Price
RET	Retail Pricing

Formula	Description (Identifies the base used to calculate the price).
1	Percentage of Item Cost
2	Percentage of Item Allowable
3	Percentage of Item Retail Pricing
9	Specific Pricing (Negotiated Price)

Level No

Identifies the group to which each Formula applies. Levels can be anywhere from 1 to 99. The program will check formulas within each Level until it finds one or more Special Prices which match the Customer’s order. The program will apply the lowest price within the level to the order. Once a Special Price is found, no addition Levels are checked for other pricing. If no Special Price is found, the program moves to the next Level.

Note: Since all customers qualify for Retail Pricing, it should be put in the highest Level defined, otherwise Levels beyond it will not be checked.

Example: To give the customer the lowest price for all formulas to which he qualifies, include all formulas in the same Level. This way, all formulas are checked and the customer will get the lowest price of all.

To give the customer the lowest price for all formulas to which he qualifies, unless there is a Negotiated Price, put Negotiated Price in Level 0, and all other pricing in Level 1. Then, if there is a Negotiated Price (Level 0), the program will stop and apply the Negotiated Price to the Customer’s order.

Special Price, Installation

Tell us what you think. Cancel reply