Financial Report Form Enhancement
Enhancement Points:
Report line and column formula calculation based on account type
Replace actual column value with zero or null value
1.1 Report line and column formula calculation based on account type:
Previously, the system didn't keep track of the Account type for the Calculation row. As a result, the column calculation didn't function correctly for row calculation based on account type. Now, the system ensures the account type is maintained for the calculation row, and it applies the column formula to the calculation row as well.
For example: User can bind calculation in ‘line type’ on Report Line Set and calculation in ‘column type’ on Report Column Set. When user will apply Calculation in both line and column, then system will give preference to formula linked on report column set.
As explained in below screenshot, when user will link addition of multiple rows of asset account type in the Report Line Set calculation in formula grid, and in report column set calculation, the user can set Actual + Budget for Liability account type, and Budget- Actual for asset account type. Then, the system will bring value as Budget – Actual as the ledgers linked in calculation row are for asset account type.
1.2 Replace actual column value with zero or null value
VIENNA has added new LOV values as "Replace Actual Value with Null" and "Replace Actual Value with Zero" on "Print Value” field on column posting type panel in Report Line Set tab. For a specific column, the report would display a blank or zero value overriding actual values for a column. When user will select “replace actual with null” or “replace actual with zero” in the report line for a column, then the reset value (zero or null) will be considered in the Row Line Calculation and Column Calculation.
i) Replace Actual value with Null - This option allows the user to replace the actual value with Null. When user selects the print value as "Replace Actual Value with Null", then system replaces the original value with null in generated report output.
ii) Replace Actual value with Zero - This option allows the user to replace the actual value with Zero. When user selects the print value as "Replace Actual Value with Zero", then system replaces the original value with zero in generated report output.
