Adding Price List Codes

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

For example, you can use different price lists to store:

  • Regular prices.
  • Sale prices.
  • Wholesale prices.
  • Regional prices.
  • Prices for volume discounts to customers who make large purchases.
  • Prices in each currency with which your company deals (if you use multicurrency accounting).

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.

  • Choose a code of up to six characters to identify each price list you plan to add.
  • Decide on default options for calculating customer discounts or markups for each price list code.
  • Decide on default price check options.
  • Add any new tax authorities you might need to Tax Services.

To add a new price list code:

  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. More...

      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. More...

      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. More...

      • 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. More...

      • 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. More...

      • 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.
  • Print a list of the price list codes that you added to verify that they are correct and complete.
  • Add items directly to the new price list, or use the Copy Item Pricing screen to assign items from another price list to this one.