Is it possible to modify a Reconciliation Dashboard to be able to check if accounts that are marked as Not Required in RCM still do not have a balance?

[OSAdmin]

Originally posted by Jill Balke

In using RCM, we have some accounts that we would like to mark as Not Required, due to mapping changes in the Transformation rules, but also, to be on the safe side, we would also like to be able to make sure that no new balances wind up in the old accounts.  Is it possible to setup a Dashboard that would look at the Not Required accounts in order to ensure they truly stay at a zero balance?

[OSAdmin]

Originally posted by Colin ONeill

DE-ACTIVATING THE ACCOUNT

In the account dimension, you can assign "Not Required" in one of the 'Vary By Scenario Type And Time' attributes (e.g., Text1). And you can make that assignment time and/or scenario dependent. So for example, account 1234 is "Not Required" 2019M1 and forward, while account 4567 is "Not Required" 2020M1 and forward.

REPORTING DE-ACTIVATED VALUES

Set the Dashboard with a dynamic time period, and filter for Account Text1 = Not Required.  When the dashboard is run in 2019, account 1234 values would be included. When the dashboard is run for 2020M3, account 1234 + 45467 values will be included.

RE-ACTIVATING

To re-activate account 1234 in 2020M6, set the Text1 field in that period to "Required".