Return Order Interfaced Errors-If The Original Invoice Referenced Has No Balance (Doc ID 1398934.1)

Last updated on JULY 13, 2016

Applies to:

Oracle Order Management - Version 12 to 12.1.3 [Release 11 to 12.1]
Information in this document applies to any platform.
Form:OEXOEORD.FMB - Sales Orders
Executable:RAXTRX - Autoinvoice Import Program


Goal

There is Invoice (Invoice Number 63402) which has Balance Due Zero.
According to the setup, this Invoice cannot be applied anymore with any Credit Memo (or Receipt) since all the Amount of the invoice it is already applied in Receipts.

Had OWC with customer where performed steps in Order Management module so that a New Return Order was created (Return Order 395) referencing the above original Invoice Number 63402.
The Order Management module allowed user to complete the workflow and the data was interfaced again in Autoinvoice Interface table.
When Autoinvoice was run then the below errors messages appeared:

- You can not apply more than the original line amount
- The total amount of your credit memo cannot exceed the balance of the debit item it is crediting
- You cannot apply a transaction with a negative amount to another transaction with a negative balance and vice versa

Discussed with Customer this scenario.
The AR setup is:
Allow Overapplication = Unchecked
Natural Application Only = Checked

hence the Receivables above errors are correct since the Invoice Number 63402 cannot be credited anymore with amount as the current balance due is Zero.

Customer wants Order Management module to prevent this from the moment of Return Order creation and to avoid the data to be sent in Interface if the referenced original invoice of the Return order has no balance due on it.
In short, the requirement is: Order Management not send the data in Interface if the reference original invoice of the Return order has no balance due on it.


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms