7.5.2. Customer Price List - List Minus

This example explains how to set up the discount schema for a sales price list where standard prices are a percentage discount from a list price.

Assumptions:

• products have a list price on the Purchasing tab.

• Standard (selling price) is 25% off of the List Price for Product Category of Bushes and 20% for Product Category of Trees. All other products are 10%.

• Limit (lowest selling price) is 35% off of the List Price for Product Category of Bushes, 25% for Product Category or Trees. All other products are 20%.

• All Trees have a surcharge of $10.00.

The following table shows the pertinent fields in the discount schema.

When generating the price list version no base price list is used (as the list price used as the base for all calculations is the list price from the product).

Assume the following Products, Product Categories and List Prices:

The prices calculated using the discount schema above would be:

• Lawn Tillers are in the Tool Category and have a discount of 10% for the Standard Price (75 - (75.00 * .10)) and 20 % for the Limit Price (75 - (75 * .20));

• Rose Bushes are in the Bush Category and have a discount of 25% for the Standard Price (100 - (100*.25)) and 35% for the Limit Price (100 - (100 *.35));

• Oak Trees are in the Tree Category and have a discount of 20% for the Standard Price plus a 10.00 surcharge (150 - (150 * .20)) + 10 and a discount of 25% for the Limit Price (150 - (150* .25)).