The Business Edge has two different types of price tables. The original version allows Discounting from List Price or a Markup from Cost. Products in the same Inventory Classification can only use one method or the other. All prices in the original price tables are based on the Quantity Ordered.

The newer version of price tables is much more flexible. Within one Price Level you can Discount from List or Markup from Cost. Quantity Breaks can be based on Quantity Ordered, Package Quantity, Master Quantity, Bulk Quantity, Weight and any combination of those.

Systems can be setup to use the original Price Tables or the Newer Price Tables based on a flag. If a company is using the original method, we have a procedure to setup the new method and then convert to that method once setup.

This write-up will cover the newer method of Price Tables, many of the principals are the same as the original tables.

Price Tables are assigned to products, there is no limit to the number of Tables that can be created. One Company may have 5-6 tables that apply to their entire inventory while another company might have a different table for each Classification of Inventory.

Price Tables have Price Levels. Price Levels are assigned to Customers. There is no limit to the number of Levels a company can have. Price Levels are assigned to Customers. An example might be Level 1 for high volume Customers, Level 2 for medium volume Customers and Level 3 for low volume Customers. Another example might be Level 1 for OEM Customers, Level 2 for Distributors and Level 3 for End Users.

In addition to assigning a Price Level to a Customer there is a way to over-ride their level based on Customer Classification and Inventory Classification. If you have a Customer that gets mid-level pricing but you know they are shopping you on a particular class of product you can give them a better level on that classification of Inventory.

Step 1 – Decide how many Price Levels you will need to cover your Customer base.

Pricing Levels are entered in the menu below

All that is needed is a Code and Description and we can proceed to setting up the Tables here:

Costs Base on: This tells the system what cost to use from the product master file. It can be either Default P.O Cost or Standard Cost.

Step 2 – Decide how many Price Tables you will need. Price Tables are entered in the menu below:

The first screen is used as defaults for the Table, the values here will be on the screen when you Setup the pricing as an example since you do not have a specific Product selected.

Each Table has a unique Code and Description, users will see this when they select a Table to apply to a Product. In this example we have a Table that will be applied to all Bolts.

If the price levels will be based on Cost, you can select Default P.O. Cost or Standard Cost. Default P.O. Cost is typically updated to be the last cost paid. Standard Cost is not a real Cost. Standard Cost can be updated with an import, in Enter & Edit Products as well as there are some menu items to help establish and update the Standard Cost. There is also a flag that will update the Standard Cost from the Average Cost each time the Average changes and increases. In this example we are using Default P.O. Cost.

Use Last Price – When this flag is set to Yes, the system will give the Customer the last Price they paid, ignoring the Price Table price. This should typically be set to No.

Use Last Level – when this flag is set to Yes, the system will apply the last Pricing Level the product was sold to that customer at, overriding the current price level.

The Example fields can be changed as they are used to illustrate what the Customers pricing would be in a given level. You could put the actual Cost or List for a particular Product so you can see what the prices would work out to in the table.

The next screen is where you will Enter & Edit the Levels in the Table. If you have previously entered Level pricing, they Levels will be displayed on this screen. In this example we are setting up a new table, press Enter or click on New Line to add a price level.

You will be prompted to select the Pricing Level to add to the Table. You can enter the Level, click the blue box or press spacebar and enter to see the Levels that were previously defined.

After selecting the Pricing Level, you will see the screen below where we will begin to enter the quantity/price breaks for this level. Simply press enter or click new line.

The first prompt is Pricing Type, Pricing Type has 3 options:

Price Discount – This is used if you want to discount off list price. The Price Discount will be based off the $10.00 base price. When using this Pricing Type, the Change from Price field will display the percentage being discounted from the List Price.

Cost Markup – This is used to maintain Markup from Cost. The Cost Markup will be based off the $1.00 base cost. When using this Pricing Type, the Change from Price field will display the Gross Profit Margin.

Cost Adder – This is used to have a set dollar amount added to a cost. No matter what the cost is the system will add this amount to the cost for calculating a sales price. When using this Pricing Type, the Change from Price field will display the dollar amount being added to the cost.

Quantity type tells the system what the minimum quantity is based on. You can choose any of the quantity types from the Examples earlier

This is a sample of 5% off of List price for a minimum of 10pcs:

After adding the rest of the discounts, here is a sample Price Level for a Price Discount based on the Pricing UOM quantity type:

Below is an example of a price level with Package Quantity as the Quantity type with a Cost Markup as the Pricing Type. The minimum quantity of .01 represents situations in which a package is broken.

The table below shows the minimum quantities with the gross margins for the package quantities. The first level listed below is the level for customers who break a package. There are also levels for customers who purchase a master package and a bulk package quantity.

This Price Level is now complete. You can add another Price Level to this table by repeating the steps shown above. The additional Price Levels can have unique prices for the same quantities on a different Level.