In a dynamic inventory environment, prices and costs of items can change frequently. In some cases, it is desirable to modify these costs or prices on each item or stockkeeping unit card. In other cases, though, the changes are wide-spread, and can be more efficiently updated in the system using a 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.
By using the Adjust Item Costs/Prices batch job, you can make adjustments to the item card or the stockkeeping unit card. In making these adjustments, you can set filters to select which item or items will be adjusted, including:
specific item numbers or item number ranges
specific vendors, or vendor number ranges
specific posting groups
costing method.
If you leave the filters on the Item tab blank, all items will have their costs or prices adjusted.
This batch job cannot be used to change alternative unit prices or direct unit costs. You can change unit prices by using the Suggest Item Price on Wksh. or the Suggest Sales Price on Wksh. batch job.
On the Options tab, 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 tab. 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 update all relevant costs and prices.
After selecting which cost or price will be adjusted, you must specify the Adjustment Factor. Note that the adjustment factor is a ratio: that is, if you enter 1 (one) the cost or price will remain the same. If you would like to adjust the cost or price downward, enter a value less than 1; for example, if you would like to reduce the Unit Price by 25%, you would enter 0.75. Similarly, if you would like to increase the Unit Price by 25%, you would enter 1.25 in the Adjustment Factor field.
In some cases, you may wish to alter the unit price of an item for one customer, a group of customers or all customers, sometimes for a specified period of time -- for a promotional discount, for example. In this case, rather than using the Adjust Item Costs/Prices batch job, you would use the Sales Price Worksheet.
The Adjust Item Costs/Prices functionality is critically different from Adjust Cost - Item Entries functionality, which is used to adjust value entries so that you use the correct adjusted cost for updating the general ledger with the Post Inventory Cost to G/L batch job.