About Column Pricing
Column Pricing contains information on quantity breaks and column pricing. This information is used to calculate the suggested selling price in Order Entry.
You can offer your customers special prices for an item based on the quantity they order; you can guarantee them a column price regardless of the amount ordered; or you can set up assortment pricing. Assortment pricing lets customers receive breaks when buying an assortment of similar items. You can have the column price automatically calculated, based on the gross profit margin or on a discount from list, or you can manually set the column price.
Within the information for each customer, you specify how column pricing information applies to that customer in the Column Breaks box in the Customer Order Entry tab. For example, you can specify whether the customer is allowed a standard discount on top of column breaks. You can guarantee a specific column price (the customer pays no more than that price, regardless of the order quantity), or you can specify that the customer be excluded from column pricing.
The information about column pricing is stored in the I-COLUMNS file. Column pricing information is location specific and can be set up differently for each General Ledger location.
See also: