Available in Sage 50 Premium Accounting and higher.
Set Up a Calculated Price Level for an Individual Item
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
- 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.
- 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, current price, last cost, or no 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.
- Select OK to accept the new calculation, or Cancel to reset the calculation to the beginning value.
- If you are finished with your changes, select OK on the Multiple Price Levels window. Select Edit to edit other price levels.
The Multiple Price Levels window
displays the system name for each price level, (customized in Inventory
Item Defaults).
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.
What do you want to do next?
- 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