editing the journal entry table using SQL unable to generate A/R credit memo

[LIM]

Hi  after editing the odjt, jdt1, oivl, and ivl1 tables using an SQL query, the system was unable to generate an accounts receivable (A/R) credit memo, show this error "Internal error (-5002) [Message 131-183]" 

[LIM · Accepted solution]

Finally, I have identified the root cause: the related TransSeq in the OIVL field named 'open qty' is 0.

I suspect that when a sales credit memo is generated, the SAP system reduces the 'open qty' value in the OIVL table. However, I may have accidentally edited the 'open qty' value earlier, which likely caused the SAP system to fail in reducing the value and to return the error: 'Internal error (-5002) [Message 131-183].