Share via


About Adjust Item Costs/Prices

In a dynamic inventory environment, prices and costs of items can change frequently. In some cases, you want to modify these costs or prices on each item or stockkeeping unit card. In other cases, the change is widespread and can be more efficiently adjusted by using the Adjust Item Costs/Prices batch job. For example, you may want the price of all of your standard-cost items to be increased or the cost of all items purchased from a particular vendor to be decreased.

When you use the Adjust Item Costs/Prices batch job to update prices or costs, you can select which items or stockkeeping units to update by setting the following filters:

  • Item number or item number range

  • Vendor or vendor number range

  • Posting group

  • Costing method.

If you leave the filters on the Item FastTab blank, then costs and prices are adjusted for all items.

Note

The Adjust Item Costs/Prices batch job cannot be used to change alternative unit prices or direct unit costs. You can change unit prices with Suggest Item Price on Wksh. or the Suggest Sales Price on Wksh. batch job. For more information, see How to: Change Unit Prices

On the Options FastTab, you determine whether you will update the item card or the stockkeeping unit card. It is important to note that changes to the item card will affect inventory throughout the system, limited only by filters set on the Item FastTab. If you select the stockkeeping unit card, the costs you may select to change are limited to the Last Direct Cost and Standard Cost.

You can only adjust one cost or price at a time. You may need to run this batch job iteratively to adjust all relevant costs and prices.

After selecting which cost or price to adjust, you must specify in the Adjustment Factor field the factor by which the current values will be multiplied.

Note

The value you enter in the field is a factor. If you enter 1, then the cost or price remains the same. If you want to adjust the cost or price downward, enter a value less than 1. For example, if you want to reduce the unit price by 25%, enter 0.75. Similarly, if you want to increase the unit price by 25%, enter 1.25 in the Adjustment Factor field.

In some cases, you may want to alter the unit price of an item for one customer, a group of customers, or all customers, and sometimes only for a specified period, such as during a campaign. In this case, rather than using the Adjust Item Costs/Prices batch job, you use the Sales Price Worksheet. For more information, see How to: Create Sales Prices for a Customer.

Note

The Adjust Item Costs/Prices batch job is different from the Adjust Cost - Item Entries batch job, which is used to adjust value entries so that you use the correct adjusted cost before updating the general ledger with the Post Inventory Cost to G/L batch job.

See Also

Reference

Adjust Item Costs/Prices
Adjust Cost - Item Entries

Other Resources

Sales Price Worksheet
Suggest Item Price on Wksh.
Suggest Sales Price on Wksh.
Post Inventory Cost to G/L
Changing Unit Prices
Customer Price Group
Sales Price