Use and Execute the Balance Revaluation Retrospective Management Ledger Process

15.8.6 Use and Execute the Balance Revaluation Retrospective Management Ledger Process

AFCS will support retrospective revaluation. A retrospective revaluation is one in which the accounting/effective date for which revaluation is performed is prior to the as-of date on which such execution is requested.

To enable this, AFCS revaluation process will accept the following runtime parameters: effective date, as of date, ledger, rule and rate date.

Please note that when revaluation is performed retrospectively, all process pipelines as necessary should also be executed such that the refreshed set of balance figures are reflected and accessible from Results.

Alongside this ability to perform revaluation retrospectively, AFCS will also support multiple executions of revaluation with a given set of runtime parameters. This is intended to ensure that exceptions that necessitate such repeat executions can be supported without any error in Management Ledger outcomes - balance and related movement information.

Considering that change to balance information itself, scope or actions required by rule configuration and rates to be applied collectively determine the set of data that should be processed upon any given execution of revaluation, it is recommended that such re-execution be limited to exceptional circumstances.

AFCS will also support revaluation of a ledger with another as basis, if so configured in Financials Cloud GL and instructed by revaluation metadata obtained by AFCS from said service.

Note:

More than one Balance Revaluation Retrospective Management Ledger process should not be simultaneously executed with the same set of runtime parameters. Refer below table for the list of runtime parameters supported.

Note:

When Revaluation Type parameter in Balance Revaluation Retrospective Management Ledger Process is selected as "Revised Balances":

Ensure that revaluation rules in ERP are not modified after the end of prior period until that prior period's adjustment period has concluded.
Ensure that the exchange rates(as per Rate Date and Rate Version input parameters) used for prior period revaluation is not modified after the end of prior period until that prior period's adjustment period has concluded.
Ensure that for a given Extraction Date- Effective Date-Ledger-Revaluation Rule Name combination, the remaining input parameters are not changed between multiple intraday executions.

If any of the above conditions are not or cannot be met, for accurate results of revaluation, please select Revaluation Type parameter as "All Balances" in Balance Revaluation Retrospective Management Ledger Process.

Key Points to Consider:

When revaluation is performed on a ledger with another as the basis, AFCS will consistently follow the instructed basis in such metadata irrespective of relative values of Entered and Functional currency codes within basis and revalued ledgers or across the two.
AFCS will not skip any balance data based on Entered Currency value when revaluation rule metadata advises user configuration of ‘ALL’ currencies for a given rule.
Multiple revaluation rules for a given ledger should NOT be concurrently executed. Attempts to do so may result in incomplete or incorrect outcomes that may not be reversible.
Revaluation should only be performed for rules completely configured in the Financials Cloud service instance that AFCS is deployed with.
Revaluation should be invoked with the Rule Name exactly as configured in the Financials Cloud service instance that AFCS is deployed with.
Revaluation should be invoked with the following parameters: Ledger, Rule Name, Effective Date, As of Date, Rate Date, Rate Version and Revaluation Type.
Not more than one revaluation rule for a given ledger should be executed at the same time - as in, if there are three rules for Ledger A, rule 1, rule 2 and rule 3 should be executed strictly in sequence. Not more than one rule per ledger should be executed at any point in time.
Revaluation may optionally be invoked with a list of Rule Names relevant to a given ledger.
When invoked with a set of Rule Names the rules will be executed in the sequence they are listed.
Note that Financials Cloud does not stop revaluation rules for a ledger being configured with overlaps in ranges of code combinations to be revalued.
Revaluation may also be executed specifically for balance information that has been revised since immediately prior execution. When attempting this, the following should be observed:
- Given that this is that amount to re-execution, invocation to achieve this should be with identical run-time parameters.
- The run-time parameter 'Revaluation Type' should be set to 'Revised Balance'.
- All other guidelines for invocation of revaluation also apply when executed solely for balance information that has been revised since immediately prior execution".

To create and execute the Balance Revaluation Retrospective Management Ledger in the Process Orchestration, do the following:

To access the Balance Revaluation Retrospective Management Ledger Pipeline, on the Home Page, select the Process Orchestration.
The Process Modeller Page is displayed.
On the Process Modeller Page, search and select the Balance Revaluation Retrospective Management Ledger process.
The Process Flow Page is displayed. This Process Flow is designed on the Drawing Canvas using the Transition, Activity, and Widgets Components available in the floating tool bar. The Balance Computation Widget is used for each GL Type Activity such as Assets, Liabilities, Expenses, Revenue, Gains, Losses, Contra Asset, Contra Liability, and Owner’s Equity set in the Balance Revaluation Settings Section. The Activities are repeated in the Run for each General Ledger Type and are executed in parallel.
To view the details of any Activity, double-click on the Activity and the details related to its Activity, Transition, and Notification are displayed. GL Type for the Generate Offsets Task need to be NULL or blank. On the drawing canvas, you can select and see the Definition, Data Fields, and Application Rule details.
To execute the Run, you can select the Run Parameter Values using the Execution Button on the Process Page or on the Process Modeller Page.
Go to the Process Modeller Page to execute the Run. Click the Menu button corresponding to the Balance Retrospective Revaluation Management Ledger Run process that needs to be executed. Click Execution icon.
The Execution Page is displayed.

On the Execution Page, to execute the Run with parameters, select With Parameters in the Execution Type List. Select or enter the required values for each field as follows:

Table 15-12 Balance Revaluation Retrospective Management Ledger process - Execution Page Field Names and Description

Field Name	Description or Instruction
Rate Date	Use the Calendar button to select the currency date.
Extraction Date	Use the Calendar Button to select the Extraction Date or As of Date for the pipeline.
Effective Date	Use the Calendar Button to select the Effective Date for which the revaluation is performed for the pipeline.
Run Purpose	Select the run purpose details from the drop down.
Revaluation Type	Select the appropriate option from the available list. All Balances: This type processes all the available Balance computation runs for a specific date. Revised Balances: This type processes only the latest available Balance computation run for a specific date.
Ledger Name	Select the Ledger pertaining to the ERP_CC_ID (Code Combination ID) that has undergone revaluation in the ERP system. Note: Do not select "All" option. Note: Do not select multiple ledgers.
Legal Entity	Use the Link button to select atleast one Legal Entity from the Available Values List, move it to the Selected Values List, and click OK. Note: Do not select "All" option. Note: Do not select multiple legal entities.
Revaluation Rule Name	Enter the revaluation rule name as same present in the ERP system. Note: You can enter multiple rules for execution using commas as separators. Do not use spaces or other delimiters to ensure rules are processed sequentially.
Rate Version	Enter the required exchange rate version.

To save the details and execute the Run, click Execute. The Run Execution begins.

Note:
The execution of the Run Pipeline is triggered using the selected As of Date.
See the Managing Processes Section for more details about the Processes.
To verify the Run Execution of the Balance Revaluation Retrospective Management Ledger Process, do the following:
1. To open the Process Monitor Page, on the Process Modeller Page, click the Process Monitor Button or select Process Flow Monitor on the Process Menu on the Process Modeller Page.
2. The Process Monitor Page is displayed listing all the Run Instances corresponding to the Balance Retrospective Revaluation Management Ledger Process. On the Process Monitor Page, search by the Process ID, or by the Process Name Balance Revaluation Retrospective Management Ledger, and select the Process Instance for the required Run Pipeline (Process) that was executed.
The Process Flow Page is displayed with the Run Execution Status on each Node of the Balance Revaluation Retrospective Management Ledger Process.
To verify the Run Execution Logs, do the following:
1. On the Process Monitor Page, click the required Process Instance for which you need to verify the Execution Logs.
2. To see the Execution Status details of a Node, double-click on that Node. The Execution Status details Page is displayed. Click Execution Logs.
The Log Viewer Page is displayed, which lists all the Logs related to the Process Instance. To see an elaborated information of a log entry, click the Show More Button. Click outside the Log Viewer Page to close it.