3.9 Balance Enquiry for Leaf and Node General Ledger

This topic describes systematic instructions to view aggregate balance screen.

The system collects balances over specific periods from the General Ledger and Management Information System. It organizes records by Branch Code, General Ledger Code, Currency Code, Related Reference, Related Customer, MIS details, and Financial Year Period. The system consolidates balances for matching combinations to derive total General Ledger and MIS figures. If user do not provide the System Account Number, user must include Branch Code, General Ledger Code, and Currency Code, while other details remain optional.

  1. On the homepage, click Menu and select Operational Ledger and then click Enquiry.
  2. Under Enquiry, click View Aggregate Balance.
    The View Aggregate Balance screen displays.

    Figure 3-10 View Aggregate Balance


    Description of Figure 3-10 follows
    Description of "Figure 3-10 View Aggregate Balance"

  3. Specify the fields on View Aggregate Balance screen.

    Note:

    The fields marked as Required are mandatory.

    For more information on fields, refer to the field description table below.

    Table 3-11 View Aggregate Balance - Field Description

    Field Description
    System Account Balance Select the toggle option to decide how to create balances, either by using the system account number or by combining system account entities.
    Branch Code Select the branch code from the option list to view the system account details.
    General Ledger Code Select the general ledger code from the option list to view the system account details.
    MIS Criteria Select the MIS button to enter all the MIS codes to be included in the populated filter.
    Related Reference / Account Select the related reference or related account from the option list to view the system account details.
    Related Customer Select the related customer from the option list to view the system account details.
    Financial Year and Period Code type Select the financial year and period code type. The available options are:
    • Latest Period Code: The system calculates the balance for the latest period.
    • All Period Codes: The system calculates balances for multiple periods.
    • Specific Period Codes: The system requires Financial Year and Period Code Details to calculate balances for the specified period.
    Note:
    • By default the Latest Period Code value is set for financial year and period code type.
    MIS Filter Displays all MIS filters applied on the popup screen.
  4. Perform anyone of the following options:
    • Click the Populate button, to get the aggregate balances with the given filters.
    • Click the Reset button, to reset all filters.
  5. Click the MIS Criteria button.
    The MIS Details screen displays.

    Figure 3-11 MIS Details


    Description of Figure 3-11 follows
    Description of "Figure 3-11 MIS Details "

  6. Specify the fields on MIS Details screen.

    For more information on fields, refer to the field description table below.

    Table 3-12 MIS Details - Field Description

    Field Description
    Customer MIS This tab displays all the fields related to customer MIS.
    Transaction MIS This tab displays all the fields related to transaction MIS.
    Composite MIS This tab displays all the fields related to composite MIS.
    Customer MIS 1 - 10 Select the customer MIS 1 -10 type data from System Account Master.
    Transaction MIS 1 - 10 Select the transaction MIS 1 -10 type data from System Account Master.
    Composite MIS 1 - 10 Select the composite MIS 1 -10 type data from System Account Master.
  7. Click the Apply button to apply the filters.

Parent topic: Operational Ledger Processing