Available in Sage 50 Premium Accounting and higher.

Set Up a Calculated Price Level for an Individual Item

Related topics

Set up sales price level names

Set Up a default sales price level calculation

Set up an inventory item

Set up master stock and substock items

Set up an assembly item

Learn about creative uses for inventory items

Determine the current quantity of inventory items on hand

Delete an inventory item

Enter inventory beginning balances

Set up and use custom fields

Change an item ID

Change item sales prices

Perform other inventory tasks

Read the inventory item defaults overview

You can have up to ten price levels for each item. You can set up calculations for these price levels on the Calculate Price Levels window. To set up a calculated price level for an individual item:

Click the Inventory Items navigation aid on the Inventory & Services Navigation Center and select View and Edit Inventory Items.
Select the item you want to add a price calculation for and click Open.
Select the arrow button next to the sales price. The Multiple Price Levels window is displayed.
Select the price level you want to enter a calculation for, and click the Edit button.

The Multiple Price Levels window displays the system name for each price level, (customized in Inventory Item Defaults). How do I set these up?

Select the Edit button. The Calculate Price Level window appears.
Calculate the new price using the options in the drop-down menus:

Use: Select a price level value on which to base the calculation. Select from Price Level One, last cost, current price, or no calculation. For no calculation, select this option in the Maintain Item Prices window to manually enter a price for that level. You can also leave the level blank and it will default to zero.

Tip: On new inventory items, it may be helpful to set up your first price level as your base price. That way when you set up a calculation for another price level, you can use the base price as a part of your calculation.

And: Select the type of mathematical formula you want the calculation to perform. Select from increase or decrease by amount (enter the specific amount in the next field), or increase or decrease by percent (enter the specific percent in the next field).
Round New Price to: Select a custom rounding operation for this calculation. Select from no rounding, round to specific cent (enter the cent value in the next field), or round to next whole dollar.

Click OK to accept the new calculation, or Cancel to reset the calculation to the beginning value.
If you are finished with your changes, click OK. Click Edit to edit other price levels.