Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Inventory Setup Automatic Cost Adjustment

Posted on by 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.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Inventory Setup Automatic Cost Adjustment

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

    bc365.co/.../

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,296 Super User 2024 Season 2 on at
  • 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?

  • swenger Profile Picture
    swenger 150 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

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans