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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Tool or periodic task ...
Supply chain | Supply Chain Management, Commerce
Suggested Answer

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

(2) ShareShare
ReportReport
Posted on by DA-29101955-0 61
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.
Categories:
Dynamics 365 Supply Chain Management
  • Guy Terry Profile Picture
    Guy Terry 29,028 Moderator on at
    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.
  • DA-29101955-0 Profile Picture
    DA-29101955-0 61 on at
    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.
     
  • Suggested answer
    Dogan Adiyaman Profile Picture
    Dogan Adiyaman 698 User Group Leader on at
    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.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the September Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 146 Super User 2026 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 98 Super User 2026 Season 2

#3
Aayush Tiwari Profile Picture

Aayush Tiwari 39

Last 30 days Overall leaderboard

Featured topics

Quality order uses default receipt location instead of actual physical receipt location

Product updates

Dynamics 365 release plans