14.5.3 Use and Execute the Revaluation Process

Ensure that you Resave Hierarchies and then proceed with the use and execution of the Balance Computation Management Ledger Process.
To create and execute the Revaluation Process (Balance Revaluation Management Ledger Process) in the Process Orchestration, do the following:
  1. To access the Balance Revaluation (Balance Revaluation Management Ledger Process) Pipeline, on the Home Page, select the Process Orchestration.
    The Process Modeller Page is displayed.
  2. On the Process Modeller Page, search and select the Balance Revaluation 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.
  3. 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 GenerateOffsets Task need to be NULL or blank. On the drawing canvas, you can select and see the Definition, Data Fields, and Application Rule details.
  4. 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.
  5. Go to the Process Modeller Page to execute the Run. Click the Menu Button corresponding to the Balance Revaluation Management Ledger Run process that needs to be executed. Click Execute Run.
    The Execution Page is displayed.
  6. 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 14-5 Balance Revaluation Management Ledger Process - Execution Page Field Names and Description

    Field Name Description or Instruction
    Rate Data Origin This is the source of Exchange Rates Value.
    Extraction Date Use the Calendar Button to select the Extraction Date or Run Date for the Pipeline.
    Currency Use the Link Button to select the Currency Code used to calculate the amount during the data population in the target table.

    Note:

    The Revaluation Run can be executed for all the currencies. This will help users to perform balance revaluation for all the currencies at one time. To enable this, select Default Currency option in the Currency for Balance Computation tab of the Currency Hierarchy browser and click OK.

    Note:

    You need to execute the Revaluation Pipeline twice, (one with rate origin as source of exchange rate and another with Derived for triangulated rates) when derived currency rates need to be applied.
    Data Source Use the Link Button to select the required data source from the Available Values List, move it to the Selected Values List, and click OK.
    Rate Version Select the required Rate Version.
    Rate Type

    Select the Rate Type from the drop-down list. The options are as follows:

    · Average

    · Spot

    · Start of the Period

    · End of the Period

    Ledger Select the Ledger pertaining to the ERP_CC_ID (Code Combination ID) that has undergone revaluation in the ERP system.
  7. To save the details and execute the Run, click the Apply Button. The Run Execution begins.

    Note:

    The execution of the Run Pipeline is triggered using the selected Extraction Date.

    See the Managing Processes Section for more details about the Processes.

  8. To verify the Run Execution of the Balance Revaluation 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 Revaluation Management Ledger Process. On the Process Monitor Page, search by the Process ID, or by the Process Name Balance Revaluation Management Ledger, and select the Process Instance for the required Run Pipeline (Process) that was executed.
  9. The Process Flow Page is displayed with the Run Execution Status on each Node of the Balance Computation Management Ledger Process.
  10. 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.