I still have the same issue for the old lot number (1 lot has the same positive & negative quantities).

For recent transactions, I used manual way to fix each transaction, and it helps.

I also run Verify data, and Rebuild Data very often.

Hopefully, QuickBooks Enterprise 2020 can fix this issue.