Review the Package Contents

This section describes the Account Reconciliations and Transaction Matching packages.

Account Reconciliations

The Account Reconciliations Dashboard is the user interface for settings and performing reconciliations. The following Business Rules are included:

  • RCM_FormulaHelper is a Finance Business Rule. Dynamic Member Formulas that use SQL Queries to generate reconciliation status percentages and reconciliation item type values for use in Cube View data cells.

  • RCM_HelperQueries is a Dashboard Data Set Business Rule. This rule can look up lists of email addresses, lists of Accounts, return reconciliation information for reporting, drill from a report to a reconciliation, and calculate statistical reconciliation data like counts, balances and statuses.

  • RCM_ReportHelperQueries is a Dashboard Data Set Business Rule. This rule gathers and calculates the information needed for all reports and charts displayed in Account Reconciliations.

  • RCM_ImportExportHelper is a Dashboard Extender Business Rule. Account Group and Access Group Import/Export Helper Functions.

  • RCM_SetupHelper is a Dashboard Extender Business Rule. This rule handles initial installation or upgrades from prior versions of Account Reconciliations.

  • RCM_SolutionHelper is a Dashboard Extender Business Rule. The calculations here go hand in hand with the RCM_DynamicCalcs UD8 Dimension. Other Business Rules help with importing templates, changing status, user notification, etc.

  • RCM_ParamHelper is a Dashboard XFBR String Business Rule. This rule contains dynamic logic that will change a string in a rule or on a label in the Account Reconciliations Dashboard.

  • RCM_DataMgmtAllAuditPackages is an Extensibility Business Rule used with a Data Management Sequence to create Audit Packages of compressed files for sharing with additional parties.

  • RCM_DataMgmtDiscover is an Extensibility Business Rule used with a Data Management Sequence to run the Discover process often if not on a schedule (typically during the extended close process) via the Data Management process. Review the section on Data Management Sequences in the Design and Reference Guide for running a Data Management Sequence on a schedule via Microsoft PowerShell. You can also schedule the Discover process to run. For more information see Task Scheduler in the Design and Reference Guide. Any notification related to the manually run Discover process, such as if a new Reconciliation Inventory is found, will be executed via this Data Management Sequence.

  • RCM_DataMgmtMassActions is an Extensibility Business Rules used with a Data Management Sequence to update the state of multiple reconciliations in one process.

  • RCM_DataMgmtProcess is an Extensibility Business Rule used with a Data Management Sequence to run the Process Reconciliations process when needed to ensure that Reconciliation balances are up to date and notify Account Reconciliation administrators if balances change.

UD8 Reporting Dimension (RCM_DynamicCalcs) and its Members is created in the application and does not need to be added to a Cube to use its members on reports. These are all DynamicCalc members that are typically shown as columns on a report where the rows are Accounts. They are used to look up values and perform calculations to show the Reconciliation status of a particular Account/Entity/Scenario/Time Period.

  • RCM: Reconciliation Manager Statistics – This is a member used to group the other RCM members.

  • RCM_PctComplete_Ent: Entity % of Recons Completed - Gets the percent complete for all reconciliations associated with this Entity, Scenario, and Time.

  • RCM_PctComplete_EntAcct: Entity-Acct % of Recons Completed - Gets the percent complete for all reconciliations associated with this Entity, Scenario, Time, and Account.

  • RCM_ISC_EntAcct: IS Correction (Entity Account) - Gets the IS Correction Value for all reconciliations associated with this Entity, Scenario, Time, and Account.

  • RCM_BSC_EntAcct: BS Correction (Entity Account) - Gets the IS Correction Value for all reconciliations associated with this Entity, Scenario, Time, and Account.

  • RCM_ISC_Ent: IS Correction (Entity) - Gets the IS Correction Value for all reconciliations associated with this Entity, Scenario, and Time.

  • RCM_BSC_Ent: BS Correction (Entity) - Get the BS Correction Value for all reconciliations associated with this Entity, Scenario, and Time.

The following Data Management Sequences and Steps are created and can be used with their related Business Rules. Running these processes through a Data Management Sequence allows them to run in the background while the user continues their work.

Transaction Matching

The Dashboard Maintenance Unit provides the user interface for Transaction Matching and includes the required Dashboard Groups, Components, Data Adapters, Parameters and files.

The following Business Rules are included:

  • TXM_HelperQueries

  • TXM_EventHandler

  • TXM_SolutionHelper

  • TXM_ParamHelper

  • TXM_DataMgmtProcess

  • TXM_DataMgmtCreateReconItems

  • TXM_SetupHelper