APP-11492: A MORE RECENT CREDIT MEMO HAS BEEN APPLIED TO THIS TRANSACTION

This error message appears whenever the user tries to complete a Credit Memo which has been applied to an Invoice and another more recent credit memo is applied to the same invoice.

Right now oracle are still working on this issue, and the only possibility to overcome is to completely remove the associated Invoice from the Initial Credit memo at both the header and line level using the below sql statements,

UPDATE ra_customer_trx_all
   SET previous_customer_trx_id = NULL
 WHERE customer_trx_id = XXXXXX;

UPDATE ra_customer_trx_lines_all
   SET previous_customer_trx_id = NULL,
       previous_customer_trx_line_id = NULL
 WHERE customer_trx_id = XXXXXX;

Make sure you create a Table/line level backup before doing this.

Print This Post