User cancelled a PO line , but something went wrong and it created Issue=On Order , with negative Quantity in inventrans table. User claims, he first 0 the quantity on PO line , then click on update line- delivery reminder- and clicked on Cancelled quantity. But that does not explain how it can create a -ve qty record in inventTrans table, and we were not able to recreate the issue.Later user deleted the PO line itself. After deleting the line, the inventtrans still shows -ve QTY , with issue 'On Order' , reference to same PO number. That suggest that somehow this record is now Orphan
I understand, we should not delete records from inventrans and inventsum tables , But in this case what other options do we have? Regards Dilip
Screen shot of inventtrans trans.
Try by running the consistency check on inventory transactions. (may be TEST first).
In reply to Kranthi:
In reply to dilip_mehta: