15.4.1 Use and Execute the Balance Computation Management Ledger Process

Use this Run Pipeline (Process) to compute the daily movements, Period-to-Date, backdated, and Translation Process Execution of average balances in Balance Computation. The Run Pipeline (Process) can be executed incrementally in a day based on user-chosen set of balance computation run time parameters, including a specific As-of-date. This will allow accounting balance information at management ledger grain to be refreshed multiple times within a given As-of-date.

Note:

• When Balance Computation Management Ledger is executed, balances are computed for all unique Management Ledger segments from accounting entries present across all sources.
• More than one ‘Balance Computation Management Ledger’ process should not be simultaneously executed with the same set of runtime parameters. Please note that considering the treatment of Data Source runtime parameter noted above, runtime parameters other than Data Source should be different before two ‘Balance Computation Management Ledger’ processes are considered for simultaneous / parallel execution.
• ‘Balance Computation Management Ledger’ process is offered in the user interface with Data Source as a runtime parameter. This is a legacy parameter retained solely for continuity purposes, will be removed from subsequent releases and will NOT be honoured by the process. As in, even if users choose a specific Data Source as a runtime parameter for said process via the user interface, the process will be executed for all data sources.
• All Accounting balance figures processed by this pipeline are as of a given MIS Date and Effective Date. This pipeline should be executed chronologically for contiguous dates through the fiscal year.
• Even when attempted over a closed fiscal period, this pipeline batch does not fail - it does not process anything.
• By default, the Translation Required is enabled. You can enable or disable based on your requirements. This will exclude/include a translation task from the Balance Computation process.

Ensure that you complete the following procedures and then proceed with the use and execution of the Balance Computation Management Ledger Process:

• Resave Hierarchies

To use and execute the Balance Computation Management Ledger Process in the Process Orchestration, do the following:

1. To access the Balance Computation 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 Computation 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 toolbar. A Data Service Widget is added at the beginning meant for sourcing the Data for Accounting Entries. Then 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. The Activities are sequenced in the order of the Backdated Process, Daily Balances Process, and Average Balances Process. The Activities are repeated in the Run for each General Ledger Type and are executed in parallel. The Balance Translation Node is added in the end.
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. 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 Flow 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 Computation 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.

   Note:

   Only one Legal Entity and Source Code must be selected for execution of the Balance Computation process pipeline.

   Table 15-1 Balance Computation Management Ledger process - Execution page Field Names and Description

   Field Name	Description or Instruction
   Extraction Date	Use the Calendar button to select the Extraction Date or Run Date for the Pipeline. Designation of this parameter as ‘extraction date’ is for legacy reasons and will be revised in subsequent releases. This parameter is to be treated as As-of Date.
   Rate Date	Use the Calendar button to select the currency date.
   Ledger Name	Select the required Ledgers from the Available List for processing or select All to process all the ledgers.
   Revaluation Rule Name	Enter the revaluation rule name as same present in the ERP system. Note: You must enter one rule at a time for each execution.
   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. Note: You must pass Data source parameter as 0 to compute balances for overlapping Management Ledger segment values across multiple data sources including adjustments.
   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. Note: Balance Computation Management Ledger process does not support Legal Entity or Data Source as filters. Select a valid Legal Entity for executing and processing data for all Legal Entities.
   Run Execution Description	Enter a description for the Run Pipeline.

   Note:

   When the Ledger Name is selected as ALL and if you execute the process using CURL command, the Ledger field must be entered as -99.
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 Computation 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 Modeller menu.
   2. The Process Monitor page is displayed listing all the Run Instances corresponding to the Balance Computation Management Ledger Process. On the Process Monitor page, search by the Process ID, or by the Process Name Balance Computation 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 Computation Management Ledger Process.

9. 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. The Process Flow page is displayed with the Run Execution Status on each Node.
   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 the details of a log entry, click the Show More button. Click outside the Log Viewer page to close it.