Customer Sub Ledger Balance

This page allows you to set the criterion to generate the sub ledger balance of a customer. Tell me more

Select the “Customer Sub Ledger Balance” link under the “Reports – Receivable Management” business component.

The “Customer Sub Ledger Balance” page appears.

Enter the following fields in the “Search Criteria” group box:

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.
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.
Currency Option	Use the drop-down list box to select the currency in which you want to view the ledger balance of the customer. The values" Transaction", "Base" and "Parallel Base" will be available for selection. The system displays Transaction by default on launch of the page.
Customer Group	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 Code From	The starting code in the range of codes identifying the customers for whom you want to view the ledger balance (Alphanumeric, 18).
Customer Code To	The ending code in the range of codes identifying the customers for whom you want to view the ledger balance (Alphanumeric, 18).
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).
Date 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.
Include Post Dated Receipts/Payments	Check the box to include the Post Dated Transactions
Include Adjustments	Use the drop-down list box to specify whether you want to include adjustments in the ledger balance report. You can select from “Yes” or “No”.The system displays “Yes” by default on the launch of the page
Display Narration	Use the drop down to select the whether the Narration to be displayed in the reports or not. The values are Header Remarks, Multiline Remarks, Both and No. Header Remarks - Header remarks alone displayed in the detail report. Multiline Remarks - Multiline remarks alone displayed in the detail report. Both - indicates both Header and Multiline Remarks to be displayed in the detail report. No - indicates no remarks to be displayed in the report.

Click the “View Customer Sub Ledger Balance” pushbutton to view the report.

The system generates and displays the customer ledger balances based on the search criteria entered. This report can be printed. The system displays the details of the customer, the finance book, the debit and credit balances in the base currency and account currency, the net balance in the base currency and the date on which the report has been generated.

Customer Sub Ledger Balance – An overview

A company requires the sub ledger balance of a customer at the end of every financial period. The debit and the credit balance can be viewed for the customer in both the transaction currency and the base currency of the company. It can also be viewed for a period of time, which could be a financial period / year or a date range.

You can search by specifying the range of customers for whom you want to view the balance. You can also select the date range for which you want to view the balances and the currency in which you want to view the report. The system generates the balance details based on the search criterion entered. You can view the details of the customer, the finance book, the debit and credit balances in the base currency and account currency, the net balance in the base currency and the date on which the report has been generated.