My Oracle Support Banner

Receivables Aging By General Ledger Account Report Duplicates Transactions When Override Account Used (Doc ID 2092942.1)

Last updated on SEPTEMBER 26, 2017

Applies to:

Oracle Fusion Receivables Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Manage Accounts Receivable Balances-Process Statements

When Override Account has been used on an invoice to change the receivables
account, the invoice is duplicated on the Receivables Aging by General Ledger
Account Report and open receivables is overstated.

It shows up once under the new receivables account (which is correct) but
then it shows up twice under the original receivables account instead of
netting to 0. The Invoice distributions still show the original receivables
account, but View Accounting for the invoice is correct.

Also the total outstanding for the customer is incorrect.

The Receivables Aging by General Ledger Account shows balance against correct account and correct customer's balance.

The issue can be reproduced at will with the following steps:
1.Create and account a Receivables Invoice.
2.Use Actions > Review Distributions.
3.Click on Override account and give a new account for the receivables account.
4.Submit the Receivables Aging by General Ledger Account report.

The issue has the following business impact: The aging report is wrong and cannot be used to reconcile AR with GL


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.