Available in Sage 50 Premium Accounting and higher.

Set Up a Calculated Price Level for an Individual Item

How Do I...

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:

1. Click the Inventory Items navigation aid on the Inventory & Services Navigation Center and select View and Edit Inventory Items.
2. Select the item you want to add a price calculation for and click Open.
3. Select the arrow button next to the sales price. The Multiple Price Levels window is displayed.
4. 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?

5. Select the Edit button. The Calculate Price Level window appears.
6. 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, current price, last cost, or no calculation.

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.
7. Select OK to accept the new calculation, or Cancel to reset the calculation to the beginning value.
8. If you are finished with your changes, select OK on the Multiple Price Levels window. Select Edit to edit other price levels.

What do you want to do next?

• 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

Published: March 21, 2017
© 2017 The Sage Group plc or its licensors. All rights reserved. Privacy Policy | Copyright/Trademarks