Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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.

  • 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,696 Super User 2024 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

  • 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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans