Associating Items with Price Lists

You can associate items with as many price lists as you want. Each price list can include prices (with discount and sale amounts) in each of the currencies that you use in your business.

Note: Each price list code can support one set of prices (including discount, tax, and price check information) in each of the currencies that you use in your business. You do not need to add price list codes for each currency.

To assign a price list to an item:

1. Open Inventory Control > I/C Items and Price Lists > Item Pricing.
2. In the I/C Item Pricing screen for Item Number, either enter the item number or click and select the item.
3. If the price list that you want to use for this item is not already in the table, click New (below the table).
4. In the I/C Item Pricing screen for Price List Code, enter the code for the price list or click and select the price list to use for this item.
5. Enter information on the Prices tab. More...
   1. Enter the description for the item to appear on orders and invoices.
   2. For Price By, specify whether the price is based on weight or on quantity.
   3. For Price Decimals, specify the decimal places to use when displaying and printing this item price.
   4. For Base Price Type, select how to calculate the base price.
      • If you selected Base Price for Single Unit of Measure, enter the Base Price and Pricing Unit.
      • If you selected Base Price Calculated Using a Cost, enter the Markup Cost, the Markup Factor (which is used as a refernce field on reports), and the Markup Unit.
   5. For Sale Price Type, select how to calculate the sale price. If you selected Sale Price for Single Unit of Measure, specify the Sale Price and Sale Unit.
   6. If you entered a sale price, enter the start and end dates when the sale price applies.
6. Enter information on the Discounts tab. More...
   1. For Selling Price Based on, select the default method for calculating discount prices on this price list. More...

      Select from:

      • Discount. Discounts the base price for the item.
      • Markup on Markup Cost. Marks up the "markup cost" entered for the item.
      • Markup on Standard Cost. Marks up the standard cost of the item. (You assign standard costs when you add location details for items.)
      • Markup on Most Recent Cost. Marks up the most recent cost of the item.
      • Markup on Average Cost. Marks up the average cost of the item.
      • Markup on Last Cost. Marks up the last cost of the item.
      • Markup on Alternate Amount. Marks up the alternative amount specified for the item. (The name of the alternative amount is specified on the Processing tab of the I/C Options screen.)

      Note: If pricing by weight, you can only choose between Discount and Markup on Markup Cost.

   2. For either Discount on Price by or Markup on Cost by, select to discount the base price or mark up the cost using a percentage or an amount.
   3. For Pricing Determined by, select either:
      • Customer Type. Pricing depends on the customer's type (A, B, C, D, or E). Customer types are assigned to customers in Accounts Receivable).
      • Volume Discounts. Pricing depends on the quantity of an item the customer purchases.
   4. In the table, enter the discounts or markups for this item. (The columns in this table depend on the selections on the upper part of the tab.)
7. Enter information on the Price Check tab, which specifies how to handle price check overrides in Order Entry. More...
   1. For Price Check Type, choose how you want Order Entry to respond to price overrides.
      • None. Order Entry does nothing about overrides.
      • Warning. Displays a warning message and lets the user continue.
      • Error. Displays an error message and rejects the price override.
      • Approval. Requires a supervisor’s approval for price overrides.
   2. For Check, select whether to check the unit price or the sales margin. If you selected Unit Price, also select Check Base, the base used to determine whether the price falls within an acceptable range: the cost plus a percentage, the cost plus a fixed amount, or a fixed range.
   3. For Cost Base, choose the type of cost to use for calculating the acceptable range.
   4. In the table, specify the range of prices that can be approved by each user. There can be different price approval levels for sales clerks and supervisors.
8. Enter information on the Taxes tab about the tax authorities that tax sales of this item. More...
   1. Click Add Line to add a line to the table.
   2. In the Tax Authority column, enter (or click and select) the tax authority (such as a state or province) that taxes sales of the item.
   3. In the Customer Tax Class column, enter (or click and select) the customer tax class for the tax authority.
   4. Repeat these steps for each tax authority.
9. Click Save to save the details about the item prices using that price list, and then close the screen.
10. If you want to associate this item with another price list, repeat steps 3 through 9.

Published: September 11, 2020
© 2020 The Sage Group plc or its licensors. All rights reserved. Privacy Policy | Copyright/Trademarks