Delivery Order details not correct due to reverse picking

Creation date: 26/08/2022 17:00    Updated: 26/08/2022 17:00   #deliveryorder #loadinglist #reverse picking
Question:

Date : 26/08/22


Warehouse ID : TDNE-02

Loading list : LDL22082400017

Wave Plan : W22082300037

SO : SO22082300426

DO : DO22-TH000815-0119


We found that the Delivery Order report has incorrect information.


Point number 2 = Total number of Special Tote (TX).

In the report showing = 2 Tote.

But when I checked in sub report details = 1 Tote.


TX0208246086


Point number 3 = Total number of Green Tote (TG).

In the report showing = 16 Tote.

But when I checked in sub report details = 8 Tote.


TG2101005298

TG2101002392

TG2110005136

TG2107200756

TG2009002595

TG2009004830

TG2110008070

TG2009006029


Then I have checked again in Loading List details, there are 8 Green Tote (TG) and 1 Special Tote (TX) for this order SO22082300426.



So, I have queried the Loading List details from DB directly, there are 16 Green Tote (TG) and 2 Special Tote (TX).


Tote

TG2110006316

TG2108026225

TG2101007737

TG2108030059

TG2110004527

TG2107206337

TG2101019309

TG2108024816

TG2101005298

TG2101002392

TG2110005136

TG2107200756

TG2009002595

TG2009004830

TG2110008070

TG2009006029


TX0208246026

TX0208246086


I have checked further found that the user did reverse picking after loading. But those items are still in the DB.


Step

1. 11.27 : First load (Load by Tote/SKU)

2. 11.34 : Reverse Picking all items in DO

3. 11.59 : Pick again.

4. 11:56:38 : Update loading Status from Loaded to Created

5. 12.32 : 2nd Loading (Standard Loading)

6. 13:35:45 : 2nd Update loading Status from Loaded to Created

7. 13:35:36 : Confirm Move

8. 13:45:12 : Pick PL0208236173

9. 13:55:27 : 3rd Loading PL0208236173 (Standard Loading )


I have retest following the user steps in testing environment and found the same issue.


Testing environment

Warehouse ID :  TDCE-01

Loading list : LDL22082500003

Wave Plan : W22082500011

SO : SO22082500012




Could you please check ?


Answer:

Investigate:
Missing steps in blue:

Steps

1. 11.27 : First load (Load by Tote/SKU)

Change the Status on the load from Loaded to Created

Delete the allocation detail that needs to do reverse picking using the way below:


After deleted the order detail then continue step 2.

2. 11.34 : Reverse Picking all items in DO

3. 11.59 : Pick again.

4. 11:56:38 : Update loading Status from Loaded to Created

5. 12.32 : 2nd Loading (Standard Loading)

6. 13:35:45 : 2nd Update loading Status from Loaded to Created

7. 13:35:36 : Confirm Move

8. 13:45:12 : Pick PL0208236173

9. 13:55:27 : 3rd Loading PL0208236173 (Standard Loading )


Take note: If you reverse picking without removing the order allocation detail then you will not be able to remove this from UI. You will need to delete it from the backend.


Therefore if the user does not have access to backend, please remember the steps.

Files