EAR9.2: Wrong Amount in AR30006 Aging By Chartfield Rpt When Running by Operating Unit. (Doc ID 1994452.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Aging

ACTUAL BEHAVIOR
---------------
Wrong amount in AR30006 Aging by Chartfield Rpt when running by chartfield Operating Unit.
When running AR30006 Aging by Chartfield Rpt by chartfield Department the amount is correct.

EXPECTED BEHAVIOR
-----------------------
AR30006 Aging by Chartfield Rpt should be showing correct amount for all chartfields.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. On the ledger group IntraUnit Balancing Entries is enabled and Operating Unit is a balanced chartfield.
  2. Chartfield Operating Unit is set to Always Inherit for Inheritance Group Receivables and Billing.
  3. For the external bank account enter Oper Unit QUEBEC and Dept 52000 for Cash – AR.
  4. Create new item for business unit GBR01 and customer USA10, amount 909 GBP.
  5. Create accounting entries online. Enter Department 27000 and Operating Unit GERMANY for AR and User line.
  6. Run ARUPDATE to post item.
  7. Create a regular deposit for 900 GBP.
  8. Build payment worksheet, apply payment (partial payment).
  9. Run ARUPDATE to post payment.
  10. Item open balance is 909 GBP - 900 GBP = 9 GBP.
  11. Navigate to Accounts Receivable > Receivables Analysis > Aging > Aging by Chartfield Rpt and run AR30006 report by Department range.
  12. AR30006 report is showing correct amount. (1 line for department 27000 with amount 9).
  13. Run AR30006 report by Operating Unit range.
  14. AR30006 report is showing wrong amount. (1 line for Operating Unit GERMANY and amount 9 GBP and one line for Operating Unit QUEBEC and amunt 9 GBP).
  15. Report should only show row for operating unit GERMANY.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users are having problems reconciling AR.

Cause

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