Use the Price Schedule Bulk Adjustments page to update costs, prices, and GL codes across a price schedule. You can update inventory items or rental rates one at a time, or select multiple inventory items or rental rates and apply an adjustment in bulk by flat amount or percentage, as an increase, decrease, or set value. You can also choose whether each adjustment applies to the original or the adjusted amount, and control how the cents end.
On the Inventory & Prices page, click the Price Schedules tab. Click the price schedule to open its slider, then click Adjust Prices.
Update an Individual Inventory Item or Rental Rate
To update the cost or price on an individual inventory item or rental rate, use one of these methods:
- Enter the new cost or price in the Adjusted Cost or Adjusted Price column. The Cost Diff or Price Diff column updates automatically.
- Enter the difference in the Cost Diff or Price Diff column. The Adjusted Cost or Adjusted Price column updates automatically.
To update a GL code on an individual inventory item or rental rate, click in the Revenue GL Code or Expense GL Code column and select the new GL code.
Bulk Update Inventory Items or Rental Rates
To bulk update inventory items or rental rates:
- Select the check box for each record to update. The bulk action bar appears.
- In the bulk action bar, select the action to take: Adjust Cost, Adjust Price, Adjust Both, or Set GL Code.
Adjust Cost, Adjust Price, or Adjust Both
- In the Apply To field, select what the adjustment changes:
- Adjusted Cost, Adjusted Price, or Adjusted Cost / Price: Applies the adjustment to the current adjusted amount. Use this to add one adjustment on top of another.
- Original Cost, Original Price, or Original Cost / Price: Applies the adjustment to the original amount. Use this to start over without clicking Reset All first.
- Select Flat Amount or Percentage.
- Enter the amount of the adjustment.
- Select the operation:
- Add (+): Increases the cost or price by the amount or percentage you enter.
- Subtract (-): Decreases the cost or price by the amount or percentage you enter.
- Equals (=): Sets the cost or price to the amount you enter, or to that percentage of the original amount.
- In the Cents field, select how each new amount ends:
- Calculated: Keeps the calculated amount. This is the default.
- Round Nearest: Rounds up or down to the closest amount that ends in your cents amount. For example, $4.35 with .25 becomes $4.25.
- Round Up: Rounds up to the next amount that ends in your cents amount. For example, $4.85 with .75 becomes $5.75.
- Round Down: Rounds down to the next amount that ends in your cents amount. For example, $4.35 with .75 becomes $3.75.
- Fixed: Sets the cents to your cents amount and keeps the dollar amount. For example, $4.35 with .87 becomes $4.87.
- If you selected an option other than Calculated, enter the cents in the Cents Amount field. For Fixed, enter a value from .00 to .99. For the round options, enter a value from .00 to 1.00. Enter 1.00 to round to a whole dollar.
- Click Apply.
To set the adjusted amounts back to the original amounts, click Reset Cost, Reset Price, or Reset All in the window. You can also click Reset All in the bulk action bar.
Set GL Code
- Select the new GL code.
- Click Apply.
When you finish, click Save.