Views:

Applies to Product - Dynamics 365 Supply Chain Management


What’s happening?
Customers are experiencing issues with packing work where work lines have been cancelled, resulting in the work being broken and unable to be closed. Additionally, there are cases where items are stuck in a picked status from empty deleted journals, and transfer order lines that have been picked but then cancelled, preventing the use of the associated license plates for other orders.


Cause:
The underlying cause for this includes data corruption and the improper cancellation of work lines or transfer orders.


Resolution:

  1. For packing work issues:
  2. Execute the following SQL query on the sandbox environment to update the work line status to "Cancelled": UPDATE WHSWORKLINE SET WORKSTATUS = 'Cancelled' WHERE RECID = <specific_rec_id>;
  3. Ensure that the SQL query is run correctly to resolve the broken packing work.
  4. For items stuck in picked status from an empty deleted journal:
  5. Apply the following X++ custom script to clean up the data: InventTrans inventtrans; ttsbegin; delete_from inventtrans where inventtrans.recid = <specific_rec_id>; ttscommit; Info('Script clean up data');
  6. Additionally, use standard consistency checks to correct inventory transactions by navigating to:
    • System Administration > Periodic > Consistency check
    • Select the Inventory management module, check the Item and Inventory transactions checkboxes, and execute the consistency check in fix error mode.
  7. For unpicking work lines from a cancelled transfer order:
  8. Perform a consistency check and check if the issue can be reproduced in the UAT environment.
  9. If the transfer order is in 'Created/Shipped' status and has a partial/full shipment, cancel the transfer transactions by going to the "Transfer order" tab in the action pane, clicking "Transfer order history," selecting the shipment line, and clicking the "Cancel" button in the action pane.
If further assistance is needed, please reach out to support.