EAR9.0+: AR30006 [Aging by Chartfield] Incorrect Total Amounts When Billing Inovice Number Of Distribution Lines Is Greater Than 40
Last updated on SEPTEMBER 22, 2016
Applies to:PeopleSoft Enterprise FIN Receivables - Version 9 to 9.1 [Release 9]
Information in this document applies to any platform.
STATEMENT OF ISSUE
Aging by Chartfield [AR30006] report generates incorrect total amounts for Bills with Multiple Items that came from inside Contracts and then posted to AR under circumstance where Setup Financials > Installation Options - Billing GL-AR Options > AR Level is set to "Header AR Open Item" and AR Option is set to "Use Line for Distribution".
V9.0 Production MP8 through bundle 25.
Aging by Chartfield [AR30006] report should show the correct total amount of the invoice that's posted.
The report shows an incorrect total amount for the bill.
No error message.
LOSS OF FUNCTIONALITY
Report is not reliable to work on.
WHAT IS WORKING
For some bills that have just a few items, the report generates the correct total amount.
STEPS TO REPLICATE
1. Setup Financials > Installation Options - Billing GL-AR Options
Set AR Level:Header is AR Open Item
Set AR Option:Use Line for Distribution
2. A bill passed to Billing from Contracts with more than 40 line items
3. Post the bill to AR
4. Run AR Update
5. Run Aging Process
6. Run Aging by Chartfield [AR30006] report From Account to Account
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms