More Solutions

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Issue with Account Code Combination for Risk Amount in AR Aging Dashboard

Question
1
Views
0
Comments
Support
Support Rank 1 - Community Starter

Hi Team,

Good afternoon!

I would like to highlight a concern regarding the Risk Amount in the AR Aging dashboard.

Currently, the dashboard is picking the correct risk amount, but it is not picking the correct account code combination for different receipt stages.

Scenario explanation:

  • For Cheque and PDC receipts, the accounting flow is as follows:
    1. Initially posted to Confirmed Cash
    2. After remittance, moved to Remitted Cash
    3. After cash reconciliation, moved to Clearing
    4. After this stage, the risk amount is no longer shown
  • When the receipt is not applied to a customer, the risk amount is shown under the Unapplied Receipt account, which is correct.

Issue observed:

  • Even when the receipt is applied and moves through Confirmed Cash / Remitted Cash / Clearing stages, the Risk Amount is always mapped only to the Unapplied Receipt account.
  • The dashboard is not reflecting the actual account code combination corresponding to the current receipt stage.

In summary, while the risk amount value is correct, the account mapping is incorrect, as it always points to the Unapplied Receipt account instead of the appropriate cash/clearing accounts.

Please let us know if this behavior is expected or if any configuration or enhancement is required to capture the correct account combinations.

Best regards,
Praveen

Tagged: