I/C Item Pricing Screen

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.

Inventory Control does not use customer types—Sage 300 Order Entry uses them.

Enter discounts or markups for as many customer types as you use.

Select the method you want to use to calculate discounts on customer invoices:

• Percentage. The program discounts the base price using the percentages you specify in the fields below this field.
• Amount. The program discounts the base price using the amounts you specify in the fields below this field.

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 the method you want to use to mark up items to create different prices for different customers or for volume discounts.

• Percentage. The program marks up the cost (markup cost or standard cost) using the percentages you specify in the fields below this field.
• Amount. The program marks up the cost (markup cost or standard cost) using the amounts you specify in the fields below this field.

Enter up to five price markup percentages or markup amounts (as appropriate) in the fields.

Enter markup amounts in pricing units.

Select 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 fields for different quantity discount levels (in the stocking units for the item).

Each quantity you enter corresponds to the amount or percentage discount or markup (as appropriate) that you enter in the field to the left of it.

Enter the number to which you want the program to round customer discount prices. For example, enter .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 your selection in the Rounding Method field.

The Round To A Multiple Of field does not appear if you selected the No Rounding option in the Rounding Method field.

Select a rounding method, either Round Up or Round Down, for the program to use when it calculates customer discount prices. The program uses the selected rounding method when you discount or mark up prices by a percentage.

If you select No Rounding, prices appear exactly as calculated, to the number of decimal places your functional currency uses.

Use this option to specify how the discount prices of items assigned to this price list will be calculated by default.

• Discount. Inventory Control calculates the selling price by discounting your base price for the item.
• Markup on Markup Cost. Inventory Control calculates the selling price by marking up your "markup cost" for the item (entered on the previous tab).
• 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 the cost you keep for your items (including the value you enter as "Alternate Amount 1" or "Alternate Amount 2" on the I/C Options screen).

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

Specify whether the price 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.

Select the cost on which you are calculating the acceptable range of unit price or sales margin. (This field will not appear if you select a fixed unit price.)

Specify how you want Order Entry to respond to price overrides. Order Entry can:

• Do nothing (if you select None).
• Display a warning message and let you continue.
• Display an error message and reject the price override.
• Require a supervisor’s approval on price overrides.

Enter the range of prices available to each user ID for which you want to do a price check.

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

If you delete the price check for the Default user, the program will only perform price checks for the listed user IDs.

You use this field differently depending on your choice for the Base Price Type. If you selected:

• Base Price for Single Unit of Measure

  Enter the normal or suggested selling price for the item, and then, in the Pricing Unit field, enter the unit on which the base price is expressed.

  To calculate the base price using a cost as a starting point:

  1. Click the Zoom button beside the Base Price field to display the Base Price for Multiple Units of Measure screen
  2. Fill in the fields on the screen that appears.
  3. You must fill in a location for the cost.
  4. Click Proceed to return the calculated base price to the Base Price field, where you can edit it.
• Base Price for Multiple Units of Measure
  1. Click the Zoom button beside the Base Price field to display the Base Price for Multiple Units of Measure screen.
  2. In the table, enter a set of base prices:
     • 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.
     • 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.

  Note: In Order Entry, when you specify the unit of measure for an order detail, Order Entry checks to see if you defined a base price for the specified UOM. If you did not define a base price for the specified UOM, Order Entry uses the default pricing UOM.

  The default pricing UOM is in effect only if the order UOM does not match a defined pricing UOM.

  If you specify a price for the stocking unit, I/C Shipments automatically uses it as the default.

• Base Price Calculated Using a Cost
  1. Click the Zoom button beside the Base Price field to display the Default Base Price screen.
  2. In the Calculate Base Price Using field, specify whether to add a percentage or amount to the cost.
  3. In the Cost Base field, select the cost to use as the base.
  4. In the Percentage / Amount field, enter the percentage or amount that you are adding to a cost.
  5. If you have a multicurrency system, in the Exchange Rate field, specify the exchange rate or the rate type and rate date.

If you use Sage 300 Premium, you can:

• Enter a base price for a single unit of measure and specify the unit.

  (You can select this option, and have Inventory Control calculate the base price using the item cost. After choosing this option, select the Zoom button to perform the calculation.)

• Enter base prices for multiple units of measure, and set a default unit of measure for I/C Shipments.

  Note: The default price 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.

  You can still set additional prices for volume or customer type discounts on base prices for multiple units of measure.

• Calculate the base price as the cost plus a percentage or amount.

  If you are calculating volume discounts by weight, you cannot calculate the base price from the cost (because the cost is based on quantity).

Specify how you are calculating this price from a cost.

Specify how you are calculating this price from a cost.

Select the cost on which you are basing the price.

You can select from standard cost, most recent cost, average cost, last cost, or either of the user-specified costs.

Select either Cost Plus a Percentage or Cost Plus an Amount as the method for calculating a default price based on the item cost.

If you have a multicurrency database, you can also select Cost Converted Using Exchange Rate Plus a Percentage or Amount.

Select either Cost Plus a Percentage or Cost Plus an Amount as the method for calculating a default price based on the item cost.

If you have a multicurrency database, you can also select Cost Converted Using Exchange Rate Plus a Percentage or Amount.

Enter a description you want to appear with the item on price list reports.

This is also the description that appears in Order Entry detail lines and on orders and invoices. This means that you can translate this description for price lists, orders, and invoices in other languages.

The Finder in Inventory Control and Order Entry always uses the description from the I/C Items screen.

Specify a location for the cost to be used in cost calculation.

If you are setting up the price list to calculate selling prices by marking up your cost, enter a markup cost.

This is a reference field and is not used in the calculation. (Markup cost is the only value used in a calculation.)

Specify the item units in which the markup cost is expressed.

Specify whether the price of this item is based on weight or on quantity.

Note: Pricing by weight is available in Sage 300 Premium only.

If you specify weight, Inventory Control 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.

Select the number of decimal places you want the program to use for displaying and printing prices and costs.

You can set the period during which this price list is in effect. This means that you can easily cut over from an old price list to a new one on a particular date.

• Enter a start date if you have a new price list that comes into effect on a particular date.
• Enter an end date if the price list expires on a particular date.

The price list is always valid if the starting and ending dates are blank.

If you choose a price list in Order Entry before the start date or after the end date, the program will display an error message and enter a 0.00 price.

Specify a location for the cost to be used in cost calculation.

Enter the percentage or amount that you are adding to a cost if you are calculating the base/sale price from a cost base plus a percentage or amount.

Enter the item unit of measure or use the Finder to select the unit of measure in which the base price is expressed.

If this is a multicurrency company, specify the rate type, rate date and exchange rate to be applied to the cost to calculate the base or sale price in the price list currency.

If you entered a sale price, select the last date for which the sale price applies.

You use this field differently depending on your choice for Sale Price Type. If you selected:

• Sale price for a single unit of measure

  Enter a sale price for the item if you are including sale prices on price lists.

  Note: You can also calculate the sale price using a cost as a starting point, and edit the calculated amount in this field. To do so, click the Zoom button and fill in the fields on the screen that appears. Note that you must fill in a location for the cost, and you must click the Proceed button when finished to return the calculated sale price to the Sale Price field, where you can edit it.

• Sale prices for multiple units of measure

  If you are entering sale prices for multiple units of measure, click the Zoom button to display the screen for entering multiple units.

  You must also specify the default UOM and price if specifying several sale prices.

  Note: In Order Entry, when you specify the unit of measure for an order detail, Order Entry checks to see if you defined a price for the specified UOM. If you did not define a price for the specified UOM, Order Entry will use the default pricing UOM.

  The default pricing UOM is in effect only if the order UOM does not match a defined pricing UOM.

  If you specify a price for the stocking unit, I/C Shipments will automatically use it as the default.

• Sale price calculated using a cost

  If you are calculating the sale price from a cost, click the Zoom button, and then:

  1. Specify whether to base the price on a single unit of measure.
  2. Click the Zoom button beside the Sale Price field to display the Default Sale Price screen.
  3. Specify:
     • Whether to add a percentage or an amount to the cost.
     • The type of cost.
     • The percentage or amount to add.
     • The exchange rate if a multicurrency database.

If you use Sage 300 Premium, you can:

• Enter a sale price for a single unit of measure and specify the unit.

  (You can select this option and have Inventory Control provide a starting point for the sale price based on the item cost. After selecting this option, click the Zoom button to perform the calculation.)

• Enter sale prices for multiple units of measure and set a default unit of measure for Order Entry.

  Note: The default price 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.

  You can still set additional prices for volume or customer type discounts on sale prices for multiple units of measure.

• Calculate the sale price as the cost plus a percentage or amount.

  If you are calculating volume discounts by weight, you cannot calculate the sale price from the cost (because the cost is based on quantity).

If you entered a sale price, select the first date for which the sale price applies.

If you entered a sale price, enter the item units or use the Finder to select the item units in which that price is expressed.

Enter the tax authority or use the Finder to select the taxes that are included by default in the item price.

For example, in Canada the GST can be included or excluded from the item price. You would add the GST to this tab if it is included in the price of this item.

Note: The Finder lists only tax authorities for which the Allow Tax In Price option is selected in Tax Services. If a tax that should be included in the price is not available here, you need to change the option for the tax authority in Tax Services.

Also note that you can change the Tax Included setting when you create invoices in Order Entry.

Enter a customer tax class or use the Finder to select one for the tax authority. Inventory Control displays the tax class description when you enter the tax class code.