Auto invoice import program: Unable to derive gl date for your transaction

Description:

Lets take an example to understand this issue.

The orders booked and shipped in OCT and return were made in NOV and OCT period was closed.

This is happening because of the GL date which is derived by Autoinvoice. As per the Autoinvoice interface data and the Autoinvoice setup, the GL date of the AR transaction to be created for the sales return order derived as "31-Aug-2012". However, the "Aug-2012" period is closed. As a result, the Autoinvoice is not able to create the AR transaction. The same thing is happening for the sales return order.

Temporary Solution:

Update the transaction gl date in the ar interface lines form manually in current open period and run Autoinvoice.

Permanent Solution:

This requires a little change in your current setup to avoid this problem in future.

1) Switch to the "Receivables Manager" responsibility.
2) Navigate to "Setup : Transactions : Sources".
3) Query with the required source :

Name : ABC_AUTO_INVOICE

4) Go to the "Autoinvoice Options" tab.
5) Set the "GL Date in a Closed Period" option to "Adjust".
6) Save the change.
7) Now check the issue.

Adjust will automatically adjust the General Ledger date to the first GL date of the next Open or Future enterable period.

For more information kindly review

Oracle® Receivables User Guide
Adjusting General Ledger Dates

Moreover, Doc ID 1080995.1 : Troubleshooting AutoAccounting in AutoInvoice is also very useful.