Pricebook Cost Adjustments

The Cost Adjustment Options form now allows specification of item type and category when setting up a Cost Adjustment Table. These settings still default to the item type and category you right-click on in the pricebook, but now you can also change them within the form.

When you create a new Cost Adjustment Table, you will notice a few new columns in the grid. For each grouping, the table will display the total number of items and the number of items that have quantity/value errors. These numbers will be updated each time you open the table. The number of items adjusted will be updated when adjustments are applied.

The Base Option

Before applying adjustments, you must select a base option. Choose from ‘Last Cost’, ‘Average Cost’, or “Standard Cost’. Previously, applying adjustment would add a percent of the current standard cost to create the new standard cost. Now you adjust the standard cost to be the ‘Average Cost’ or ‘Last Cost’ plus a percentage.

Applying Adjustments

All items may not be adjusted when the adjustments are applied. This may occur for one of two reasons.

• If ‘Last Cost’ is selected as the base option, items that do not have a ‘Last Cost’ will not be adjusted.
• If ‘Average Cost’ is selected as the base option, items that do not have an ‘Average Cost’ will not be adjusted.
• If ‘Average Cost’ is selected as the base option, items having a quantity/value error will not be adjusted. This is because items with a quantity/value error indicate the average cost may not be correct. To help identify items with this problem, the number of items with this error is listed in the Cost Adjustment Table. When you access ‘Standard Cost Review’, items with the error are indicated with a “+/-“ icon. You can right click on the item and access the value correction form to correct the item state. If quantities our out of sync, you will need to exit and correct quantities in the inventory manager first.

The Cost Adjustment Table is no longer deleted once the adjustments are applied. The number of items adjusted is displayed in the table, and indicates if some items were not adjusted. The table is kept in a read only mode so you can come back and review the adjustment any time until you create a new table. You can create a new table by clicking the ‘new’ button at the bottom of the form. The Cost Adjustment Table can be printed.

Standard Cost Review

You can now review the standard cost changes for all items in your groupings. This review displays the current standard cost, current last cost, current average cost, and the prior standard cost. The percentage of change in the standard cost from these figures is also displayed. The ranges of change are color coded to assist in identifying severe changes in item cost. Items that were adjusted with the most recent Cost Adjustment Table will display the green checkmark icon.

You can access the review for all items in the adjustment table by clicking the button at the bottom left of the Cost Adjustment Table or right-click and select “Row | Standard Cost Review…” to review the items for a particular grouping.

From the Standard Cost Review you can

• Revert the selected item to the prior standard cost.
• Revert all items in your current filter to the prior standard cost. This may not directly undo a previous adjustment. Reverting all will revert all items listed in the current view to the previous standard cost. This is based on your percentage change range filter and your Adjust Stamp filter. The Adjust Stamp column indicates when the item was last adjusted.
• Edit and manually change the standard cost for any of the items listed.
• Access item value correction for an item.
• Access purchase history for an item.
• This grid can be printed.

Event Logging

Changes to standard cost via this Cost Adjustment feature will post events in the event log. Events are posted when

• Adjustments are applied; an event is posted for each grouping indicating the percentage of the adjustment.
• Reverting a single item in ‘item review’.
• Reverting the entire group.