Add Items to Price Lists
Overview
You can add items to as many price lists as you want. Each price list can include prices — including discount and sale amounts — in each of the currencies that you use in your business.
Inventory Control includes the following forms for maintaining price lists for inventory items:
-
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.
Typical
steps for adding item prices to several price lists
-
Assign items to their first price list.
-
Print the Price Lists report to check that the items appear on the price lists to which you assigned them.
-
Use the Copy Item Pricing form to copy items to other price lists, converting prices according to currency exchange rates or adjusting them for different purposes.
Before
you start
-
Add the price list codes you want to use.
-
Gather the existing pricing information for each item in your inventory.
To add items to price lists:
-
Open Inventory Control > I/C Items and Price Lists > Item Pricing.
Click here for help on Item Pricing fields.
-
Enter or use the Finder to select the number of the item for which you want to add prices.
-
Click the New button to enter new prices.
If you are updating existing prices, double-click the line for the currency and price list code that you want to change.
-
If you have a multicurrency system, choose the currency in which you want to add pricing information.
-
Choose the price list code.
Description. For example, "US mail order prices."
Price By. Whether
the price of the item is based on weight or on quantity. More information...
Price Decimals. The number of decimal places (up to 6) for displaying and printing prices and costs.
Base Price Type.
You can enter a base price for a single unit of
measure or for multiple units of measure, or you can calculate the base
price from a cost. More
information...
-
Base Price for Single Unit of Measure.
Base Price. Enter the normal or suggested selling price for the item, including in the price any taxes that you assign to the item on the Taxes tab.
Pricing Unit. Enter the item units or use the Finder to select the item units in which the base price is expressed.
-
Base Price for Multiple Units of Measure. Click the zoom button, and then fill in the grid to enter a set of base prices.
Press
the Insert key to add a new base price line.
Unit of Measure. Enter the item units or use the Finder to select the item units in which the base price is expressed.
Base Price. Enter the normal or suggested selling price for this item unit of measure, including in the price any taxes that you assign to the item on the Taxes tab.
Default. The program forces you to select a default unit of measure and price for entering I/C shipments.
The first line you enter is automatically set as the default price, and you can only set it to No by choosing a different line as the default.
Double-click the Default column for the line which you want to be the default.
Note: The default price and UOM is in effect only if you do not specify a price for the stocking unit. If you specify a price for the stocking unit, I/C Shipments will automatically use it as the default.
-
Base Price Calculated Using a Cost.
Click
the zoom button, and then fill in the fields on the popup form that appears:
Calculate Base Price Using. Specify how you are calculating the base price from a cost.
Cost Base. Select the cost that you are using as the base cost if you are calculating the base price from a cost base plus a percentage or amount.
Percentage / Amount. Enter the percentage or amount that you are adding to a cost if you are calculating the base price from a cost base plus a percentage or amount.
Sale Price Type.
You can set the sale price in exactly the same
ways that you set the base price: You can enter a sale price for a single
unit of measure or for multiple units of measure, or you can calculate
the sale price from a cost. More information...
-
Sale Price for Single Unit of Measure. Fill in the Sale Price and Sale Unit to enter a single base price. See the discussion above on Base Price Type for more information.
-
Sale Price for Multiple Units of Measure. Click the zoom button, and then fill in the grid to enter a set of sale prices for different units of measure.
If you are entering prices for multiple units of measure, you can also set different start and end dates for each unit, and the Sale Starts and Sale Ends fields will disappear from the Prices tab.
See the discussion on Base Price Type for more information.
-
Sale Price Calculated Using a Cost. Click the zoom button, and then fill in the fields on the popup form that appears.
See the discussion above on Base Price Type for more information.
Sale Starts. If you entered a sale price, enter the first date (in the date format you use) for which the sale price applies.
Sale Ends. If you entered a sale price, enter the last date (in the date format you use) for which the sale price applies.
Markup Cost. Enter a markup cost if you are setting up the price list to calculate selling prices by marking up your cost.
Markup Unit. Enter item units or use the Finder to select the item units in which the markup cost is expressed.
Markup Factor. Type the factor (number) by which you want to multiply the markup cost to calculate the desired selling price for the item. Note that this is a reference field (used on reports) and is not used to calculate the selling price. The actual markup is entered on the Discounts tab.
You can also see the Item Pricing field list for more information on each field.
-
Fill in the Discounts tab.
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.
-
Click the Price Check tab (in Sage ERP Accpac 500 only).
This
tab lets you check price overrides for this item in Order Entry.
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.
-
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).
-
Click the Add button, and then repeat these steps for each price list code that you want to add.
After
adding pricing information
-
Use the Price Lists form in the Price/Sales Analysis Reports folder to print a report of the items you have assigned to price lists.