Skip to main content

Notifications

Announcements

Announcing Category Subscriptions!
News and Announcements icon
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Inventory On Hand Phys...
Supply chain | Supply Chain Management, Commerce
Unanswered

Inventory On Hand Physical Reserved incorrect

(0) ShareShare
ReportReport
Posted on by lispyj 2,751
I have an item that, in the on hand view, shows Qty 15 in the Physical Reserved for a specific location.  There is no open warehouse work for that item, there are no other open inventory transactions for that item and specific location.  We utilize the separate Inventory Transactions and Warehouse transactions feature of Advanced Warehouse.  Running a consistency check does not fix this issue.
 
While researching, I found two lines in the Warehouse transaction view that I believe caused the issue.  A Work type entry for Qty 15 has the status "Physical Reservation".  A later line, having the same reference, has the type "Physical Reservation Removed" but the Qty is blank (zero).  The warehouse work that is referenced by the transaction is closed.  Using table browser, I see that there is a line for the item and Physical Reserved qty in the table WHSInventReserve. 
 
How can I adjust this quantity, now that the Work and Sales Line are long closed? 
 
In my UAT environment, I removed that quantity (using a runnable class), but when I ran a consistency check, the quantity was restored.
 
What are my options for fixing this?
 
D365 Finance V 10.40
Categories:
Supply Chain Management
warehouseTrans.png
OH.png
  • lispyj Profile Picture
    lispyj 2,751 on at
    Inventory On Hand Physical Reserved incorrect
    Thanks for the reply Andre.
     
    Yes, my first try was to just set the entry to 15.  My second try was to delete the entry all together.  
     
    I have tried to follow the code to find out what is repopulating the value, but it is a long and tedious process.  I am not completely clear about the data that underlies the new Warehouse Transactions view.  My research just took me in circles :(
     
    I don't believe we have any customization relating to warehouse transactions.  I will see what support has to say.
     
    LJ
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,331 Super User 2024 Season 2 on at
    Inventory On Hand Physical Reserved incorrect
    Hi lispyj,
     
    You have done great research already. In case you don't have customizations in this area, I would suggest logging an incident for Microsoft Support. 
     
    What exactly did you remove using your runnable class? Have you tried setting a quantity on the removed physical reserved line?

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

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,333 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans