My Oracle Support Banner

AR Autoinvoice Errors for RMA-GL Date Of Credit Memo date cannot precede date transaction credited (Doc ID 1160053.1)

Last updated on AUGUST 14, 2023

Applies to:

Oracle Order Management - Version 11.5.9-11.5.10 to 12.2.7 [Release 11.5 to 12.2]
Information in this document applies to any platform.
Form:OEXOEORD.FMB - Sales Orders
Executable:RAXTRX - Autoinvoice Import Program


On : version, Finance & Accounting

When attempting to run 'AR Autoinvoice' to import invoice, it shows the following error.

- In the current case, Sales Orders were entered on 13th March using Quick Sales Order Entry Form.
RMAs were entered on the later date but with the RMA date as 10th March , referencing the sales order. This was by user mistake. System did not show any error.
After processing both order and RMA, it did not show any error, while running AR interface it errored: "CM date cannot precede date transaction credited".
- Although there is solution to change the Credit Memo date in AR autoinvoice to match invoice date, user thinks that there will be mismatch of dates in OM and AR.

OM should stop users entering referenced Sales Orders for RMA prior to SO dates.

CM date cannot precede the date of the transaction being credited

The issue can be reproduced at will with the following steps:
1. Login as OM Superuser
2. Navigate > Quick Sales Order Entry > Enter Sales Order
Enter RMA referencing sales order
3. Process both order and RMA
4. Login as AR Superuser
5. Run Autoinvoice


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.