I/C Price List Codes Screen
Enter a code of up to six characters to identify the price list. You can use letters and numbers in the code, but not spaces.
Enter a description for the price list code.
These letters 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 used by the Order Entry program when you enter orders. Inventory Control does not use customer types.
Enter discounts or markups for as many customer types as you use.
Select from this list the method to use to calculate discounts on customer invoices.
- Percentage. The program discounts the base price using the percentages you specify in the fields in the lower part of this tab.
- Amount. The program discounts the base price using the amounts you specify in the fields on the lower part of this tab.
Enter up to five price discount percentages or amounts (as appropriate) in the fields.
Enter discount amounts in pricing units (include any taxes that are assigned on the Taxes tab).
Select from this list the method you want to use to mark up items to create different prices for different customers.
- Percentage. The program marks up the cost (markup cost or standard cost) using the percentages you specify in the fields in the lower part of the tab.
- Amount. The program marks up the cost (markup cost or standard cost) using the amounts you specify in the fields on the lower part of the tab.
Enter up to five price markup percentages or markup amounts (as appropriate) in the fields.
Enter markup amounts in pricing units.
Select from this list the method you want to use to determine price discounts for items.
- 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.
Specify whether the price of the item is based on weight or on quantity.
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 300 Premium.
Select from this list the number of decimal places (up to six) you want the program to use for displaying and printing prices and costs.
Select from this list the method you want to use to determine price discounts for items.
- 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.
Enter up to five quantities (in the stocking units for the item) in the boxes.
Each quantity you enter corresponds to the amount or percentage discount or markup (as appropriate) that you enter in the box to the left of it.
Enter the number to which you want the program to round customer discount prices. For example, type .05 to round prices that are not already a multiple of .05 to the next such multiple.
The program rounds prices up or down according to what you selected in the Rounding Method field.
Note: The Round To A Multiple Of field does not appear if you selected the No Rounding option in the Rounding Method field.
Select the rounding method, Round Up or Round Down, you want the program to use when it calculates customer discount prices.
If you select No Rounding, prices appear exactly as calculated, to the number of decimal places specified by the Price Decimals field (or that your functional currency uses, if it uses fewer).
The program uses the selected rounding method when you discount or mark up prices by a percentage.
Use this option to specify how the discount prices of items assigned to this price list will by default be calculated.
- Discount. Inventory Control calculates the selling price by discounting your base price for the item.
- Markup on Markup Cost. The program calculates the selling price by marking up the "markup cost" entered for the item on the first tab of the Item Pricing screen.
- Markup on Standard Cost/Most Recent Cost/Average Cost/Last Cost/Alternate Amount 1 or 2. Inventory Control calculates the selling price by marking up one of the costs kept for your items (including the value you enter as Alternate Amount 1 or Alternate Amount 2 in the Options screen).
Choose whether the check should be done on the unit price or on the sales margin.
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.
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.)
Choose how you want Order Entry to respond to price overrides. Order Entry can:
- 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.
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.
Enter a tax authority code or use the Finder to select the tax authority (such as state or province) that taxes sales of the item. Inventory Control displays the tax authority description when you enter the tax authority code.
Enter a tax class code or use the Finder to select a customer tax class for the tax authority. Inventory Control displays the tax class description when you enter the tax class code.
Overview
Use the I/C Price List Codes screen to:
- Add price list codes to identify your price lists.
- Select default options for calculating customer discounts or markups for the items you later assign to the price lists.
- Check price overrides in Order Entry for customers and orders that use this price list.
- Specify default tax authorities and classes for the items you later assign to the price lists.
Discount Tab
Use the Discounts tab to:
- Specify the number of decimals to use in prices on the price list.
- Specify the method of calculating selling prices for items on the price list.
Price Check Tab
Use the Price Check tab to check price overrides in Order Entry for orders that use this price list.
If you choose None for the Price Check Type, this tab remains blank.
Note: Price checks are available only in Sage 300 Premium.
Taxes Tab
Use the Taxes tab to specify the tax authorities and classes that apply to items on the price list.