Views:

Applies to Product -Dynamics 365 Supply Chain Management


What’s happening?
Customers are experiencing issues with on-hand inventory that lacks a designated location, preventing the creation of work orders.


Reason:
The underlying cause of this is the absence of inventory transactions for items, which leads to unbalanced warehouse inventory transactions.


Resolution:

  1. Run the cleanup routine in the following order:
  2. Inventory dimensions cleanup
  3. Dimension inconsistency cleanup
  4. On-hand entries cleanup
  5. Warehouse management on-hand entries cleanup
  6. After the cleanup, perform a database consistency check for inventory transactions and on-hand entries for items and warehouse management.
  7. If the issue persists, attempt to cancel the work from the warehouse management module by navigating to:
  8. Clean up → Cancel Work
  9. Select the work ID and cancel the work.
  10. If the above steps do not resolve the issue, review the following tables for discrepancies:
  11. inventSum
  12. whsInventReserve
  13. WHSINVENTORYTRANSACTION
  14. If necessary, a correction script can be provided based on the specific error messages encountered during the process.