[SUM(Remaining Qty) <> SUM(Qty)] in ItemLedgEntry

Good day

I have this problem that sometimes, somewhere during production, when posting consumption, the entries apply wrong.

The ILE's Lot No. is for example = 12345, but in its item application entries, you can see that an entry with a different lot no (=55555) applies against it.

Even worse, the ILE (lot no = 55555) that applies to the Open entry (lot no = 12345) has, say, a QTY = -50. Thus the remaining qty on lot 12345 is adjusted but the sum of the qty of lot 55555 is reduced by 50.

Net effect:
For the same item, same variant, same location: SUM(QTY) = SUM(Remaining QTY).
But for the same item, same variant, same location, same lot: SUM(QTY) <> SUM(Remaining QTY). :shock:

Before I can prevent this from happening again, I have to fix the data. How would one go about doing this?

Certainly you can't just adjust the "Inbound Item Entry No." of the Item Application Entry that applied wrong to point to the correct ILE NO., and adjust the remaining qty's and lot no's of the appropriate ILE's?

Thanks