Work is in In-Progress Status and blocked even after Replenishment work cancelled in D365 FO

Hi,

Work is in In-Progress Status and blocked even after Replenishment work cancelled  in D365 FO

User Created Sales order and released it to warehouse so that Work has been created and Replenishment work also been created because of not enough stock in items fixed location.

User doesn’t want to proceed with this Replenishment work so user cancelled it and after that user tried to cancel sales order work but it had struck up in IN-PROGRESS status.

Sales order Work WRK-013248 is in In-Progress Status and Item 08312 cannot be cancelled in work line after related Replenishment work WRK-013238 is cancelled.

Findings:

User Released the Sales Order 3002588 and New Work has been created WRK-013248 and blocked because of Replenishment work WRK-013238 has created for an item 08312.

Replenishment work having without Pick Location for an item 08312 and User cancelled this Replenishment Work. (Below Screen Shot)

But In WRK-013248 work is not unblocked even after Replenishment work WRK-013238 is cancelled.

And Work line for 08312 still in Open Status and Work Order status struck in In-Progress status.

Problem here is how to move stock from Physical Reserved and it cant used to other sales orders and Stock Status of item are Physical Reserved.

Tried Solutions:

 1. When try to cancel the line getting below error

2. Cannot pick the quantity from mobile device. WRK-013248

Reason for this is Work Status PUT Stage is CLOSED

3. Can’t Delete Corresponding Load ID and Shipment while Work in In-Progress Status

Load line cannot be deleted because there is work associated to it.

4. Cannot Reduce picked quantity (Because work WRK-013248 is not yet closed)

This line cannot be unpicked because no closed work is associated to it.

5. Can’t Delete Corresponding Shipment while Work in In-Progress Status

You cannot delete shipment line that has work associated to it.

6. Cannot change the reservation of item because work is related to it with Work Quantity

Reservations cannot be removed because there is work created which relies on the reservations.

7. Cannot cancel Sales Order Getting below error

Reservations cannot be removed because there is work created which relies on the reservations. 

8. Can’t do deliver remainder sales order Getting below error

Quantity cannot be negative

Update to WAXInventTrans cancelled

9. Ending Worker User Sessions:

Menu path: warehouse management>Inquires and reports>Mobile device logs>work user sessions.

I have found strange thing in sales order line quantity of item work quantity is -9.85 instead of 50.15.

Finally worked solution is

1) I had to run the following sql script in DB

update WHSWORKINVENTTRANS set qty = 50.15, INVENTQTYREMAIN = 50.15 where WORKID = 'WRK-013248' and ITEMID = '08312'

 update inventtrans set qty = 50.15 where recid = 56374515796

 update inventtrans set qty = -50.15 where recid = 56374578945

2) Cancel work line

3) Cancel work header

4) Complete shipment

5) Complete load

6) Complete sales order (packing slip and invoice)

7) Run consistency check job

Menu path System administration > Periodic tasks > database > Consistency check

8. Must take KB 4091936 update to avoid future issues with negative work quantities.

Other Scenario for Work In-Progress Status

WMS MOBILE DEVICE – CANCEL BUTTON AND IN PROCESS WORK