Tuesday 18 September 2012

Apply credit memo to an invoice oracle apps

Using the API ARP_PROCESS_APPLICATION.CM_APPLICATION we can apply credit memo to an invoice.
OR
REFERENCE_LINE_ID of RA_INTERFACE_LINES_ALL to apply the credit memo to that invoice as the invoice to be applied to is already there in AR

select A.TRX_NUMBER CMNO,
A.TRX_DATE CMDATE,
B.TRX_NUMBER INVNO,
B.TRX_DATE INVDATE
FROM
RA_CUSTOMER_TRX_ALL A,
RA_CUSTOMER_TRX_ALL B
where
B.CUSTOMER_TRX_ID = A.PREVIOUS_CUSTOMER_TRX_ID
above gives the corressponding the invoice number for a credit memoe with the creation date.

1 comment:

  1. what about AP Credit Memo application to Invoices in AP

    ReplyDelete