Skip to main content

Notifications

Supply chain | Supply Chain Management, Commerce
Suggested answer

Tool or periodic task to manually recalculate on-hand list specifically on order quantity

Posted on by 29
Anyone has an idea on an existing standard tool (e.g. Periodic Task) to manually recalculate on-hand list specifically on order quantity or all quantity columns? 
 
From time to time, the On Order quantity has values on certain items that don not have inventory transaction with status On Order.  Any feedback on how you go about this is appreciated.  Thanks.
  • Suggested answer
    Dogan Adiyaman Profile Picture
    Dogan Adiyaman 676 User Group Leader on at
    Tool or periodic task to manually recalculate on-hand list specifically on order quantity
    Usually, insufficient development causes this issue. Back in the day, we used to run a job to recalculate inventory on-hand.
     
    D365FO has changed that.

    To manually recalculate on-hand inventory in Dynamics 365, navigate to "Inventory management > Periodic tasks > Closing and adjustment" and use the "Inventory adjustment wizard" to adjust the on-hand quantity by selecting the "On-hand" option for the method of cost value adjustment; this allows you to directly modify the current inventory levels based on a physical count.
  • DA-29101955-0 Profile Picture
    DA-29101955-0 29 on at
    Tool or periodic task to manually recalculate on-hand list specifically on order quantity
    Thanks @Guy Terry!
     
    We have an ISV solution related to length management of a released product.  However, I am seeking a tool that Microsoft has built to address multiple ISV solutions globally that is stuffing up entries on at least inventsum table for on-hand list.
     
  • Guy Terry Profile Picture
    Guy Terry 28,621 Super User 2024 Season 2 on at
    Tool or periodic task to manually recalculate on-hand list specifically on order quantity
    On-hand is updated in real-time by F&O. It should not need recalculating or manually updating. If you are finding incorrect values, it'd be best to investigate why and determine if its a bug in standard (for MSFT to fix) or if you have a development or ISV product that is causing the issue.
     
    If you run the Consistency checker for On-hand (and run it in Fix mode), do you find that it corrects the On hand data? (Ideally test this in a UAT environment first). Hint - you can run the On hand consistency checker for a single item.

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!

Community AMA December 12th

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans