About Price Lists

You use price lists to store pricing information for all of your inventory items. You create price lists by adding items and prices to price list codes.You can have as many price lists as you need to handle different locations, different countries, and different currencies. More...

Sage 300 Order Entry uses price lists to calculate prices on orders and invoices.

Inventory Control uses price lists for information purposes. You can see item prices when you ship goods from Inventory Control, and you can print item prices on Inventory Control reports and on item labels and bin/shelf labels.

Overview of Price List Setup

Setting up price lists for your items in Inventory Control involves the following general steps, which are described later in this topic:

1. Add a new price list code using the Price List Codes screen.
   • You select default options for customer discounts, price checks, and taxes for the items you add to price lists.
2. Do one of the following:
   • Add items to the new price list using the Item Pricing screen.
   • Copy items to the new price list from an existing price list using the Copy Item Pricing screen.
     • You can adjust prices while copying and select the information that you want to copy.
     • You can copy prices from one currency to another, adjusting prices for the different exchange rate.

Note: You must add inventory items and price list codes before you can add items to price lists. You do not need to create price lists before you add inventory items.

Adding Price List Codes

You use the Price List Codes screen (in the I/C Setup folder) to add the price lists you need.

You assign a unique code to identify the price list. (Price list codes can contain up to six upper-case letters and numbers.)

For each price list, you also specify default settings for items that you add to price lists, including:

• Options for calculating customer discounts for the items you add to price lists. More...

  Discount options include:

  • Whether to calculate customer discounts by discounting your selling price, by marking up your markup cost, or by marking up your standard cost.
  • Whether to calculate customer discounts by discounting or marking up by a percentage or a specific amount, and the percentage or specific amount to discount or mark up.
  • Whether to base customer discounts on customer type, or on the number of items purchased (volume discount).

  You can override these options when you add item prices to the price lists.

• The rounding method (up, down, or none) that you want the program to use when calculating discount or markup prices. If you discount or mark up prices by a percentage, you can also specify a number to which you want all prices rounded, such as the nearest five cents.
• Tax authorities (such as state or province) and customer tax classes that apply to the sale of items on the price list.

Note: When you define price lists, they contain no items or prices. You add items and prices later.

Adding Items to Price Lists

To have items appear on a price list, you must assign the items to the price list code using the Item Pricing screen (available in the I/C Items and Price Lists folder).

When you assign items to their first price list code, you specify pricing information for one item at a time.

Afterwards, if you want to assign items to other price list codes, you can use the I/C Copy Item Pricing screen to copy a single item or group of items to additional price lists, adjusting pricing information as needed in the process. For example, you can create a price list of your regular prices first, then create a sale price list based on the regular price list. Basing the sale price list on the regular price list allows you to create the sale price list more quickly than if you enter item prices one at a time.

When adding an item to a price list, you specify:

• The currency code, for multicurrency ledgers. (A price list can contain items that use different currencies.)
• The price list code.
• The item number.
• The description to appear for the item on price list reports. This description also appears in Order Entry detail lines and on orders and invoices.

  Tip: You can translate this description if the price list is for other countries.

• The number of decimal places to use for displaying and printing the prices and costs of the item.
• A base price ( the expected selling price). More...

  If you have Sage 300 Premium, you can also:

  • Price volume discounts by quantity or weight.
  • Enter one or more base prices for multiple units of measure.
  • Calculate the base price using the cost plus a percentage or amount.

• A sale price with start and end dates for the sale (optional). More...

  If you have Sage 300 Premium, you can also:

  • Enter one or more base prices for multiple units of measure.
  • Calculate the base price using the cost plus a percentage or amount.
• A markup cost, and a factor by which to mark up this cost to calculate a selling price for the item.
• A start and end date for the price list. This means that you can easily cut over from an old price list to a new one on a particular date.
• Whether to calculate selling prices by discounting your selling (base) price, or by marking up your cost. You can also choose to mark up your standard cost. In multicurrency ledgers, you can mark up on standard cost only on functional-currency price lists.
• Whether to calculate customer discounts on selling prices by a percentage or by a specific amount, and whether customer discounts are calculated based on volume purchased or on customer type.
• If you are using Sage 300 Premium, whether to check for price overrides in Order Entry for orders that use this price list, and display warnings, error messages, or require supervisors' approval for prices that exceed a particular range.
• Tax authorities (such as state or province) and customer tax classes if you want the program to include taxes in the prices of items for Order Entry.

Copying Items to a Price List

When copying items already on a price list to another price list, you specify:

• The price list code of the price list to which the items already belong.
• The pricing currency you are copying from.
• The price list code of the price list to which you are copying the items.
• The pricing currency you are copying to.
• Which items to add.
• Which pricing information to copy exactly and which to adjust.

Note: You can change most of the information in an item pricing record at any time, but the Quantity Purchased field cannot be zero if you entered a discount or markup percentage or amount. (The Quantity Purchased field appears on the Discounts tab when you select Volume Discounts in the Prices Determined By field.)

Maintaining Price Lists

Inventory Control includes the following screens for maintaining price lists for inventory items:

• Price List Codes. Use the Price List Codes screen to add new codes to identify price lists, as well as to change default discount (or markup) and tax information for each price list.
• Item Pricing. Use Item Pricing to assign items to price lists, to edit pricing information for items, and to remove items from price lists.
• Copy Item Pricing. Use Copy Item Pricing to copy pricing information from a range of items on one price list to another price list.
• Update Item Pricing. Use Update Item Pricing to change prices or costs for a range of items on one or more price lists.
• Contract Pricing. Use Contract Pricing to set up pricing arrangements for specific customers.