Hi All,
I have a customer that uses lot tracking, and I have come across a scenario, that the qty gets misaligned on the lot numbers and we have to use the allocation worksheet to fix it. I think I managed to replicate what it is doing, but no idea what the next steps would be.
1. They process a sales order for a qty of 6. (they have 2 batches in stock Batch A for qty 4 and Batch B for qty 2)
2. They create a shipment and a pick, and pick both batches for a qty of 6.
3. For some reason, it seems like the despatch staff, then only ship 4 of the one batch (I am assuming they checked the pallet and couldn't see the other 2..... you would assume they would have shipped 6 right.
4. Batch B stays behind in the Shipping bin
5. When you next time want to pick stock, it shows that Batch A has 2 in stock and Batch B 0, but it should be Batch B to have 2 and batch A 0, cause they shipped that batch on the shipment.
6. Item ledger entries is incorrecting reporting the qty on hand on the incorrect lines.
Below are some screenshots:
A. This is what should be in stock:
B. This is what has been picked:
C. This is what has been invoiced to the customer:
D. This s what is now showing on the Application worksheet showing the mismatch:
E. This is the applied entries on the Shipment of the 4 of the batch.
Has anyone else experienced issues like these?
