Tuesday 8 July 2014

Auto application of Credit Note to Invoice Using AutoInvoice

When Creating a Credit note by Auto Invoice import Oracle provides the option of auto application of a Credit Note to an invoice i.e. When you are creating a credit note as soon as a credit note is created it will be immediately applied to an AR invoice.
This functionality can be used by by populating the reference_line_attribute columns of ra_interface_lines_all tables By populating the reference line_id or the combination of reference line_context and reference line attributes which correspond to a given AR invoice line you can apply the CM line being created to an existing Invoice.
Ensure that the CM line which you want to apply has an amount less than or equal to the invoice line open amount else you will get an error by Auto Invoice if over application is not enabled.
This is an efficient way of Creating credit notes and also applying them to Open invoices/Debit notes in the system if the information of application is available beforehand

1 comment: