XLAAARPT: Account Analysis Report (Subledger) Period Totals Show DR/CR Net Amount Not Column Sum Totals (Doc ID 2312352.1)

Last updated on AUGUST 17, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR
-----------------------
Executing the Account Analysis Report (Subledger Accounting) it is noted that the Period Total for Debit (DR) and Credit (CR) do not sum.
Instead the Period Total is the net result of the DR/CR columns.

For example:

Source          Category                Debit          Credit
-----------     -----------             ----------     ----------

Payables       Invoice                 100.00
Payables       Payment                                  15.00
                                              ----------     ----------
                       Period Totals       85.00           0.00

EXPECTED BEHAVIOR
-----------------------
Expect the Period Total of each column to equal the sum of DR/CR in that column, not the net amount.

For example:

Source          Category                Debit          Credit
-----------     -----------             ----------     ----------

Payables       Invoice                 100.00
Payables       Payment                                  15.00
                                              ----------     ----------
                       Period Totals      100.00         15.00

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. (N) Submit New Request > Account Analysis Report > Enter Parameters > Submit
2. Review output. Period Total equals the net result of DR/CR columns.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users unable to report accurate totals per period.

Changes

N/A

Cause