How to Add a New Price List Code in Sage 300 Inventory Control

Steps:

  1. Open Inventory Control > I/C Setup > Price List Codes.
  2. In the Price List Code field, type a code to identify the price list using up to six characters.
  3. In the Description field, enter a description for the price list (for example, “US mail order prices”).
  4. On the Discounts tab, enter the following information:
    1. In the Price By field, specify whether the price of the item is based on weight or on quantity.If you specify weight, you can set volume discount amounts or percentages that are determined by item weight. The weights are calculated in Order Entry by multiplying the unit weight of an item times the quantity ordered, and converting the weight to default units.
      • Note: Pricing by weight is available only for Sage 300 Premium.
    2. From the Price Decimals list, select the number of decimal places to use to display prices for this price list.
    3. From the Selling Price Based on list, select the default method for calculating discount prices for items on this price list.
      • Inventory Control calculates selling prices for each method, as follows:
        • Discount. The base price for the item is discounted. (You assign base prices when you assign items to the price list.)
        • Markup on Markup Cost. The program marks up the item’s markup cost. (You assign markup costs when you assign items to the price list.)
        • Markup on Standard Cost. The program marks up the item’s standard cost. (You assign standard costs when you add location details for items.)
        • Markup on Most Recent Cost. The program marks up the item’s most recent cost.
        • Markup on Average Cost. The program marks up the average cost for the item.
        • Markup on Last Cost. The program marks up the last cost for the item.
        • Markup on Alternate Amount 1 or Alternate Amount 2. Inventory Control calculates the selling price by marking up the cost that you enter in the Alternate Amount 1 or 2 fields (defined on the Processing tab on the I/C Options screen).
          • Note: If you are pricing by weight, you can choose Discount and Markup On Markup Cost only.
    4. From the Discount on Price by/Markup on Cost by list, select whether to discount the base price or mark up the cost. 
      • If you select Percentage, you specify the percentages in the Discount Percent fields that appear.
      • If you select Amount, you specify the amounts in the Discount Amount fields that appear.
    5. From the Pricing Determined by list, specify whether to determine price discounts by customer type or by volume. 
      • If you select Customer Type, Inventory Control determines prices according to the customer’s type (“A, B, C, D, E”).
      • Customer types are assigned to customers in Accounts Receivable.
      • If you select Volume Discounts, Inventory Control determines prices according to the quantity of an item the customer purchases.
  5. On the Price Check tab, specify how Inventory Control will check price overrides for Order Entry orders that use this price list.
    1. From the Price Check Type list, specify how Order Entry will respond to price overrides.
      • Do nothing (if you select None).
      • Display a warning message, and let you continue.
      • Display an error message, and reject the price override.
      • Force you to get a supervisor’s approval on price overrides.
    2. From the Check list, select whether to check the unit price or the sales margin.
      1. If you are checking the unit price, in the Check Base field, specify whether price checks are based on cost plus a range of percentages, cost plus a range of amounts, or a fixed range of prices.
      2. In the Cost/Margin Base field, specify the cost on which you are calculating the acceptable range of prices.
        • Note: This field does not appear if you selected Fixed Amount in the Check Base field.
    3. In the table, enter the range of prices available to each user ID
      • You can create several price approval levels for sales clerks and supervisors.
        • Important! The Default price check range applies to all users who are not listed in the table. If you delete the price check for the Default user, the program checks prices only for the listed user IDs.
  6. On the Taxes tab, fill in the tax information as follows:
    • Authority. Enter a tax authority (such as state or province) or use the Finder to select the tax authority that taxes sales of the item.
    • Cust. (Customer) Tax Class. Enter the customer tax class or use the Finder to select a customer tax class for the tax authority.
    • For more information about tax authorities and tax classes, see the help for Tax and Bank Services (in the Sage 300 System Manager help).
  7. Click Add, and then repeat these steps for each price list code that you want to add.

Support

If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.