Company Code

Use the drop-down list box to select the code identifying the company in which the customer has been defined. All the companies that are in the “Active” status and have been mapped to the login organization unit will be available for selection.

Business Unit ID

Use the drop-down list box to select the code identifying the business unit in which the customer has been defined. All the business units that are in the “Active” status and have been mapped to the selected company will be available for selection.

Finance Book

Use the drop-down list box to select the code identifying the finance book in which the financial transactions pertaining to the customer has been posted. All the finance books that have been mapped to the organization units that form part of the selected business unit will be available for selection. The system displays “All” by default on launch of the page.

Group Type Code

Use the drop-down list box to select the type of group to which the customer belongs. All the customer group types that have been defined for the login organization unit will be available for selection.

Customer Group Code From

Use the drop-down list box to select the customer group from which you want to retrieve. All the customer group codes that have been defined for the selected group type will be available for selection.

To

Use the drop-down list box to select the customer group till which you want to retrieve. All the customer group codes that have been defined for the selected group type will be available for selection.

Customer Code From

The starting code in the range of codes identifying the customers for whom you want to view the ledger balance (Alphanumeric, 18).

Help facility available.

To

The ending code in the range of codes identifying the customers for whom you want to view the ledger balance (Alphanumeric, 18).

Currency

Use the drop-down list box to select the code identifying the currency in which you want to view the ledger balance. All the currency codes that have been assigned to the login company will be available for selection. Te system displays “All” by default on launch of the page.

Date Option

Use the drop-down list box to select the date option in which you want the ledger balance. You can select from “Financial Year”, “Calendar Year” and “Days”. The system displays days by default on the launch of the page.

Financial Year

Use the drop-down list box to select the code identifying the financial year for which you want to view the customer ledger balance. All the financial years defined for the finance books mapped to the selected business unit will be available for selection in the chronological order. The financial years could be in the “Open” or the “Provisionally Closed” status.

Financial Period

Use the drop-down list box to select the financial period for which you want to view the customer ledger balance. All the financial periods that have been defined for the selected year will be available for selection in the chronological order. The system displays the start date and the end date of the financial period along with the code identifying the financial period.

Calendar Year

Use the drop-down list box to select the calendar year in which you want to view the ledger balance. All calendar years that have been defined in the “Financial Calendar Closure” component will be available for selection. If “Calendar Years” is selected in the “Date Option”, the calendar years, which are ten years earlier to the system date will get loaded. (For example: If the system date is 1/1/2002, then the calendar years from 1/1/1992 onwards will get loaded).

Month

Use the drop-down list box to select the month in which you want to view the ledger balance. If “Calendar Years” is selected in the “Date Option”, then all the months in the calendar year will be available for selection.

Report Type

Use the drop-down list box to select the type of report that you want to view. You can select “Summary” to view a summary report of the ledger balance and you can select “Details” to view a detailed ledger balance report.

Date From

The starting date in the date range for which you want to view the customer ledger balances (Date Format).

To

The ending date in the date range for which you want to view the customer ledger balances (Date Format). The system date is displayed by default on launch of the page.

Reporting Basis

Use the drop-down list box to select the reporting basis in which you want to view the ledger balance. You can select from “Account” and “Customer”.

Control Account Type

Use the drop-down list box to select the type of control account in which you want to view the ledger balance. You can select from “Receivables Account”, “Prepayment Account” and “Deposit Account”. The system displays receivables account by default on the launch of the page. 

Report ID

Select the check box to print the Report ID in all the pages of the report.

Entry Point Page

Select the check box to print the entry point page once.