Add Price List Codes

Sage ERP Accpac Inventory Control 6.0

Add Price List Codes

Overview

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.

Other item pricing forms

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

  • 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 add a range of items to one price list from 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.

Before you start

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

Click here for help on Price List Codes fields.

  1. Fill in the Discounts tab, as described below:

Price List Code. Up to six characters to identify the price list.

Description. For example, "US mail order prices."

Price By. Whether the price of the item is based on weight or on quantity. More information...If you specify weight, I/C lets you 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 in Sage ERP Accpac 500.

Price Decimals. The number of decimal places (up to 6) for displaying and printing prices and costs.

Selling Price Based on. The default method for calculating discount prices on this price list. More information...

  • Discount. Inventory Control calculates selling prices by discounting your base price for the item. (You assign a base price to items in “Step 9: Assigning Items to Price Lists,” later in this chapter.)

  • Markup on Markup Cost. The program calculates the selling price by marking up your “markup cost” for the item. (You can assign a markup cost to items in “Step 9: Assigning Items to Price Lists,” later in this chapter.)

  • Markup on Standard Cost. Inventory Control calculates the selling price by marking up your standard cost for the item. (You can assign a standard cost to items in “Step 11: Add Location Details for Items,” later in this chapter.)

  • Markup on Most Recent Cost. Inventory Control calculates the selling price by marking up your most recent cost for the item.

  • Markup on Average Cost. Inventory Control calculates the selling price by marking up your average cost for the item.

  • Markup on Last Cost. Inventory Control calculates the selling price by marking up your 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 in I/C Options).

If you are pricing by weight, you can choose Discount and Markup On Markup Cost only.

Discount on Price by/Markup on Cost by. Select from this list the method to be used to discount or mark up customer discounts. More information...

  • Percentage. The program either discounts the base price, or marks up the cost you select using the percentages you specify in the fields in the lower part of the form.

  • Amount. The program either discounts the base price, or marks up the cost you select using the amounts you specify in the fields on the lower part of the form.

Pricing Determined by. Select from this list the method you want to use to determine price discounts for items. More information...

  • Customer Type. Inventory Control determines prices according to the customer’s type (A, B, C, D, or E).

  • Volume Discounts. Inventory Control determines prices according to the quantity of an item the customer purchases.

The selections you made for the previous three fields (Selling Price Based On, Discount On Price By/Markup On Cost By, and Pricing Determined By) determine which fields now appear in the lower part of the Discounts tab.

Note: "A, B, C, D, E" denote the five possible types of customers to which the discounts or markups you enter apply.

Customer types are assigned to customers in Accounts Receivable and looked up when you add orders in Sage Order Entry.

See the Price List Codes field list for more information on each field.

  1. Click the Price Check tab (in Sage ERP Accpac 500 only). This tab lets you check price overrides when entering orders in Order Entry that use this price list. Fill out this tab as follows:

Price Check Type. Choose how you want Order Entry to respond to price overrides. More information...

  • Do nothing (if you choose 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.

Check. Choose whether the check should be done on the unit price or on the sales margin.

Check Base. If you are checking the unit price, you can check that the price falls within a percentage range of the cost, an amount range on the cost, or within a fixed range.

Cost/Margin Base. Choose the cost on which you are calculating the acceptable range of unit price or sales margin. (This field will not appear if you choose a fixed unit price.)

User ID / Greater Than… / Less Than…. Enter the range of prices available to each user ID. If you want, you can create several price approval levels for sales clerks and supervisors.

The "Default" price check range applies to all users who are not specifically listed in the grid. If you delete the price check for the Default user, the program will only do price checks for the listed user IDs.

  1. Click the Taxes tab, and 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 ERP Accpac System Manager help).

  1. Click the Add button, and then repeat these steps for each price list code that you want to add.

After adding price list codes

  • 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 form to assign items from another price list to this one.

Related topics