Views:

Applies to Product - Dynamics 365 Supply Chain Management



What’s happening?


The script provided to fix data corruption for a project item requirement was not successful in the production environment. Customers reported the following issues: - Inability to reserve certain batches prior to posting the delivery note, with the reservation field blanking out when moving to another line. - The affected sales order displayed an ordered quantity of 12,097 against a certain batch number, while it should have been one. The item requirement and sales order only showed a deliver remainder of a total of 6.


 Reason:


The underlying cause of this appears to be related to synchronization problems between the INVENTTRANS and INVENTSUM tables, which may affect financial postings.


Resolution:

  1. Confirm that the UAT environment was refreshed with the most current production data before testing the script.
  2. Run the Consistency check in Fix Error mode for the affected item, ensuring to select the Inventory transactions node.
  3. If the issues persist, check the following:
  4. Ensure the parameter for on-hand consistency check cleanup is set correctly.
  5. If the flag for skipping on-hand aggregation and clean-up in the consistency check is enabled, a new Consistency check run must be initiated for the parameter to take effect.
  6. If the problem continues, consider creating a shadow copy of the production environment for further investigation.
  7. After executing the above steps, verify if the expected results are obtained and confirm if the issues are resolved. If not, further investigation may be required.
If the above steps do not resolve the issue, please provide additional details for further assistance.