Views:

Applies to Product - Dynamics 365 Supply Chain Management

What’s happening?
On-hand quantities show zero while financial quantities have remaining values, leading to incorrect financial cost accumulation for serial numbers.


Reason:
This arises from discrepancies in the timing and process of standard cost activation, where batch and serial items are not financially tracked, resulting in residual values for items with zero quantities.


Resolution:

  1. Run Consistency Check:
  2. Navigate to System administration → Periodic tasks → Database → Consistency check.
  3. Focus on 'Inventory management' and uncheck all nodes except for Inventory management, Item, and On-hand.
  4. Select the item or items for which the consistency should be run and click OK to execute the check.
  5. Run Inventory Recalculation:
  6. Open Inventory management → Periodic tasks → Closing and adjustment → Recalculation.
  7. Select the period and date, then open filters and add items to run the recalculation.
  8. Cleanup Routines:
  9. Execute the following cleanup jobs in the specified order:
    • On-hand entries aggregation by financial dimensions.
    • Warehouse management on-hand entries cleanup.
    • On-hand entries cleanup for non-warehouse items.
  10. Investigate Closed Records:
  11. Check the number of closed records and closed quantities using SQL queries to determine if further cleanup is necessary.
  12. Regular Maintenance:
  13. Implement frequent recalculations and closures, preferably after hours, to maintain inventory accuracy and prevent future issues.