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

See Also

Reference

Unit Cost
Inventory Setup