Usually when you set price formulas, you simply set a percent or amount to add or discount product prices. However, you can configure more complex pricing formulas based on usage or amount calculations.
- Usage calculations define when the formula will be used to calculate the price for the product
- Amount calculations define how the amount is calculated
Usage calculations:
These options define when the formula will be used to calculate the price.
- To calculate the formula based on box rather than individual quantities, select the Use Box Qtys
Recognizes the Quantity as a number of boxes rather than number of individual units. Use this option for items that are sold by the box, rather than individually. For example, if a product has a Box Quantity of 6, and the price matrix Quantity Break is set to 5, then the customer will receive the Quantity break price when they purchase 5 boxes of 6 units, or a total of 30 units. check box. - Type any notes into the RemarksAny notes about all pricing formulas entered on the combination. This information does not appear on the customer's sales order. box. These do not print on sales orders.
- You can set the dates when the formula will be EffectiveThe first date on which the price formula will be used. and when it will ExpiresThe last date on which the formula may be used for purchases. After this date, default pricing takes effect, unless any other pricing formulas are still valid.. You can also configure the formula based on a historical price by setting the Price History DateIf the product has a price history of previous prices offered, then this is the date of the price that you want to apply. This option is useful if you want to give the customer an incentive to purchase more product by offering a price break back to last year's pricing if they purchase a minimum amount.. All dates are specified in MM/DD/YYYY format.
- To enable multiple products within a price group or product line to fulfill the minimum break requirements, select thed Mixed BreaksFor combinations that include Product Line or Price Group, this option allows the price break to be calculated across multiple products that belong to the combination. For example, if there was a price break set to 10% discount on a quantity of 10 items within a specific Product Line, then a customer may purchase any combination of 10 ore more products and receive the 10% discount, as long as all 10 products belong to the same product line. check box. You can then set the measurement of those minimums by selecting Quantity, Dollar Breaks, WeightConfigures that value appearing in the first column of the Price Formula grid. By default, this value represents Quantity, so the price break is based on the number of items purchased. Set to Dollar Breaks to configure based on a minimum number of dollars spent, or Weight to configure based on a minimum weight of products purchased.
This option is used in conjunction with Mixed Breaks to enable more than one product to apply to the break, as long as all products belong to the same Product Line or Price Group..
Note: The Use Box Qtys, Mixed Breaks, and Remarks options apply to all formulas for the combination.
Amount calculations
Inform ERP can calculate the price break amount automatically based on Desired Gross Profit PrecentCalculate your desired gross profit percent for the sale, based on the markup percentage. For example, if you want to make a gross profit of 25"%, type 33.33 into this box. This number should be entered as a whole percent, not a decimal value (i.e. 25 for 25%, not .25). When you enter your desired gross profit, the system calculates the correct discount and enters in into the Amount box. Press the Tab key after entering this value. , Desired MultiplierCalculate the amount based on a multiplier. For example, if you want to make 3 times the cost, type 3, and the system will calculate a 200% markup. Press the Tab key after entering this value. , or CHAIN Discount Specify chain discount percent amounts, separated by slashes. For example, 15/10/2-5 means take 15% off total, n 10% off that, then 5% off that total twice. When you specify these amounts, the system calculates the corresponding amounts and enters them into the table for you. Press the Tab key after entering this value.. These calculations apply to the currently selected price formula row only.
Within the Price Formula table, click the arrow in the calculator column, specify the above value(s), and then press the Tab key to calculate the Amount column.
You can review an example in Scenario 2 of Scenario 2: Apply a 25% gross profit to all water heater parts purchase by schools
Note: This feature will not complete the price formula. You must also enter corresponding values into the %/$ and -/+ fields.