Automatic Cost Adjustment Field, Inventory Setup Table
Specifies whether to adjust for any cost changes automatically every time that you post inventory transactions. The adjustment process and its consequences are the same as for the Adjust Cost - Item Entries batch job.
Because potential cost adjustment during every inbound posting could slow down database performance, this setup field includes time options (see below) so that you can define how far back in time from the work date an inbound transaction can occur to potentially trigger adjustment of related outbound value entries.
When setting a time option for automatic cost adjustment, you should therefore select one that balances your requirements for cost accuracy with the performance level of your database. Generally speaking; the shorter the time setting, the less accurate the cost information, but the better the database performance during posting.
When an item's cost has been adjusted - automatically or manually, a check mark is placed in the Cost is Adjusted field on the item card and on any production order lines for the item.
With the following options you can specify if and when to adjust cost automatically when posting transactions:
| Option | Behavior |
|---|---|
Never |
Costs are not adjusted when posting |
Day |
Costs are adjusted if posting occurs within one day from the work date |
Week |
Costs are adjusted if posting occurs within one week from the work date |
Month |
Costs are adjusted if posting occurs within one month from the work date |
Quarter |
Costs are adjusted if posting occurs within one quarter from the work date |
Year |
Costs are adjusted if posting occurs within one year from the work date |
Always |
Costs are always adjusted when posting, irrespective of the posting date |
Beware that the use of low-level codes on production BOMs will impair database performance during automatic cost adjustment.
Tip
For more information on how to work with fields and columns, see Work with Data. For assistance in finding specific pages, see Search.
Parent Tables
| Table | Location |
|---|---|
| Inventory Setup Table | Inventory |