web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Inventory Setup Automa...
Small and medium business | Business Central, N...
Suggested answer

Inventory Setup Automatic Cost Adjustment

(0) ShareShare
ReportReport
Posted on by BobbyHelp 105

Hi MS Community,

Under Inventory Setup page, there are several options to choose from in the "Automatic Cost Adjustment" drop down menu: Never, Day, Week, Month, Quarter, Year, and Always.

For Day, Week, Month, Quarter, and Year, does anyone here know the difference between these and which date and timestamps each one will run?

Side note: we have it set to never and place a job queue to run "Adjust Cost Item Entries" but it has been crashing these last few days due to various issues. Thus, I'm trying to explore other options.

I have the same question (0)
  • swenger Profile Picture
    swenger 152 on at
    RE: Inventory Setup Automatic Cost Adjustment

    The frequency is how often it will calculate your average cost. So for example if you have it set to month, it will calculate your opening inventory beginning of month, what is ending inventory. Add purchases and sales during the month and calculate your new average cost. If you use daily you will have less swings usually on your average. Here is an article which explains in details

    learn.microsoft.com/.../design-details-average-cost

    We were having issues when set to automatic that it would crash so we changed to have it run every night with a queue

  • BobbyHelp Profile Picture
    BobbyHelp 105 on at
    RE: Inventory Setup Automatic Cost Adjustment

    For day, is the time stamp at 12:01AM? For Month, does it run of the 1st of the month and which time stamp will it run?

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 92,762 Super User 2025 Season 2 on at
    RE: Inventory Setup Automatic Cost Adjustment

    Hi, just adding some info.

    https://learn.microsoft.com/en-us/dynamics-nav-app/design-details-cost-adjustment#example-1

    https://www.apcommerce.com/articles/why-you-should-set-automatic-cost-adjustment-to-never-in-dynamics-365-business-central/

    Hope this helps as well.

    Thanks.

    ZHU

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,043 Moderator on at
    RE: Inventory Setup Automatic Cost Adjustment

    You can read about the different options and strategies for Cost adjustment here:

    bc365.co/.../

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,327

#2
Sumit Singh Profile Picture

Sumit Singh 2,734

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,599

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans