AutoInvoice Import and Credit Memos
You can use AutoInvoice to import and validate transaction data from a legacy system to create credit memos in Receivables.
You can import:
-
On-Account Credit Memos
-
Credit Memos against Transactions
-
Credit Memos Against Invoices With Rules
-
Credit Memos Against Invoices Without Rules
-
Credit Memos Against Tax and Freight Lines
You can import credit memos against transactions that were already paid. When importing credit memos against paid transactions, AutoInvoice can evaluate these credits for automatic receipt handling. If an invoice transaction type doesn't allow overapplication, and the Receipt Handling for Credits option isn't enabled on the transaction source, then AutoInvoice leaves the related credit memo in the interface tables until you unapply the receipt from the invoice.
On-Account Credit Memos
An on-account credit memo is a credit memo that isn't linked to an invoice.
To create an on-account credit memo, don't populate these columns in the RA_INTERFACE_LINES_ALL table:
-
REFERENCE_LINE_ATTRIBUTE1-15
-
REFERENCE_LINE_CONTEXT
-
REFERENCE_LINE_ID
Credit Memos against Transactions
You can link a credit memo to an invoice in one of two ways:
-
Populate the REFERENCE_LINE_ID column on the RA_INTERFACE_LINES_ALL table with the CUSTOMER_TRX_LINE_ID of the invoice.
-
On the RA_INTERFACE_LINES_ALL table, populate the REFERENCE_LINE_ATTRIBUTE1-15 columns with the INTERFACE_LINE_ATTRIBUTE1-15 columns of the invoice. The INTERFACE_LINE_ATTRIBUTE1-15 columns are stored in the RA_CUSTOMER_TRX_LINES_ALL table.
You must also populate the REFERENCE_LINE_CONTEXT column with the INTERFACE_LINE_CONTEXT column of the invoice. The INTERFACE_LINE_CONTEXT column is stored in the RA_CUSTOMER_TRX_LINES_ALL table.
When you import credit memos against transactions, AutoInvoice validates that the setting of the Open Receivable option on the transaction type assigned to the credit memo being imported matches the setting of the Open Receivable option on the transaction type assigned to the transaction being credited. If they don't match, then AutoInvoice rejects the credit memo.
Credit Memos Against Invoices With Rules
When you import credit memos against invoices with rules, AutoInvoice uses the method you entered in RA_INTERFACE_LINES_ALL.CREDIT_METHOD_FOR_ACCT_RULE to determine how to reverse the accounting entries created for the original invoice.
You can enter LIFO, PRORATE, or UNIT:
-
If you enter LIFO, AutoInvoice reverses the accounting entries beginning with the last period.
-
If you enter PRORATE, AutoInvoice prorates the credit amount across all accounting periods.
-
If you enter UNIT, AutoInvoice lets you credit specific quantities, starting with the period specified in the column RA_INTERFACE_LINES_ALL.LAST_PERIOD_TO_CREDIT and working backward.
If you enter UNIT, then AutoInvoice rejects the credit memo if the credit quantity exceeds the quantity on the target invoice line.
Credit Memos Against Invoices Without Rules
When you import credit memos against invoices without rules, AutoInvoice first looks for an accounting date in the interface table to use as the accounting date of the credit memo. If no accounting date is in the interface table, AutoInvoice uses the value of the Default Date parameter of the Import AutoInvoice program. The credit memo lines must always have the same accounting date as the credit memo.
The credit memo accounting date must be in an Open or Future period, and must be equal to or greater than the accounting date of the invoice being credited.
Credit memos against invoices without rules that are imported through AutoInvoice act in the same way as those entered manually. If you pass the amount you want to credit, Receivables automatically creates all of the accounting reversal entries. Receivables also automatically reverses the sales and non-revenue credits assigned to the salespersons.
Credit Memos Against Tax and Freight Lines
When you import credit memos, AutoInvoice ensures that you don't overapply tax and freight lines.