The purpose of the level pricing grid is to preview to the user exactly what the level pricing for the update will look like in the inventory file after the update is performed. The level pricing grid operates similar to the one used on the cost/price tab of inventory file maintenance.

 

Users can modify the percentage over cost value or the dollar over cost amount directly in the grid. Users can change a price level from percentage over cost to a dollar amount over cost and vice versa.

 

The Level Price Grid is where the item's level pricing is updated. The Level Price editing grid has four new columns: "Markup", "$ Over Cost", "Cost Basis" and "Cost Basis $".

 

▪The "Markup" column shows a "$" or "%" value to indicate whether a given price is a "float" (dollars over cost) price or a "percent" (percent over cost) price.

▪The "Cost Basis" column indicates the cost value (Real, Landed, Base or Market) from which the price is derived.

▪The "Cost Basis $" column indicates the working cost value being used for that price.

 

This is useful in Inventory File Maintenance on systems having automatic recalculation of Level Prices disabled in System Preferences. On such a system the cost values used to calculate the prices could be different from the current working costs of the item due to a deferred price update. In this case "Cost Basis $" will allow you to see how the cost has changed since the prices were last updated.

 

▪The "$ Over Cost" column interacts with the original "% Over Cost" column in that BOTH values are now calculated for ALL active price levels. Previously the "% Over Cost" value only applied to prices which used a percent markup value (hence the need for the "Markup" column under the new design).

 

 

Very Important: The "% Over Cost" value shown for "floating" prices is calculated as a simple, add-on percentage value. Because of this, for price levels which are defined to use the "% of Sell Price" calculation formula the markup percentage shown for a "floating" price WILL NOT produce the same price if you try to convert the price from "float" to "percent" using the displayed percentage value.

 

Floating Price Levels - Allows for deferred updating of "Floating" (dollars over cost) price levels. The pricing system "remembers" the cost values which were used to calculate a given set of prices. When new costs are applied to the prices it will correctly recalculate "floating" prices. The process of saving the new prices updates the "last cost used" values to be ready for the next cost update.

 

•The dollar float, of level prices that are defined as a dollar amount over real or base cost, can be adjusted in the Price Level Adjustment area.

 

• The percent over cost value, of level prices that are defined as a percentage amount over cost, can be adjusted in the Level Pricing Grid.

 

•Any customer that receives special pricing for the item can have their special price updated base on the settings of the Special Price Adjustment area.

 

 

Clicking the Reset Price Levels button will reset the values in the level pricing grid, based on the adjusted cost values and the current setting of the inventory file. In addition, each of the fields in the price level adjustment area will be recalculated as well.