Supplier Ledger

The Supplier Ledger is an operational report usually required at the end of every financial period. Tell me more

Select the “Supplier Ledger” link under the “Reports – Payables Management” business component.

The “Supplier Ledger” 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 for which you want to view the supplier ledger report. 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	Use the drop-down list box to select the code identifying the business unit for which you want to view the supplier ledger report. 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 for which you want to view the supplier ledger report. All the finance books that have been deployed in the company 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 type of currency in which you want to view the supplier ledger report. You can select from “Base”, “Transaction” or “Parallel Base”. The system displays blank by default on launch of the page.
Currency	Use the drop-down list box to select the code identifying the currency in which you want to view the supplier ledger report. All the currency codes that have been assigned to the login company will be available for selection. The system displays “All” by default on launch of the page.
Created At	Use the drop-down list box to select the organization unit in which the supplier documents have been created. All the organization units in which the “Payables Management” business components have been deployed will be available for selection.
Supplier Group	Use the drop-down list box to select the supplier group for which you want to view the supplier ledger report. All the supplier group codes that have been defined for the selected group type will be available for selection.
Supplier Code From	The starting code in the range of codes identifying the suppliers for whom you want to view the ledger report (Alphanumeric, 18).
Supplier Code To	The ending code in 2the range of codes identifying the suppliers for whom you want to view the ledger report (Alphanumeric, 18).
Date Option	Use the drop-down list box to select the time duration for which you want to view the supplier ledger report. You can select from “Financial Year”, “Calendar Year” or “Date Range”. The system displays “Date Range” by default on 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 supplier ledger report. 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.

Note: A financial year must be selected only if “Financial Year” is selected in the “Date Option” field.

Financial Period

Use the drop-down list box to select the financial period for which you want to view the supplier ledger report. 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.

Note: A financial period must be selected only if “Financial Year” is selected in the “Date Option” field.

Calendar Year

Use the drop-down list box to select the calendar year for which you want to view the supplier ledger report. All the calendar years based on the defined financial years will be available for selection in the chronological order. For example if the financial year is from April 2001 to March 2002, the calendar year 2001 and 2002 will be available for selection.

Note: A calendar year must be selected only if “Calendar Year” is selected in the “Date Option” field.

Month

Use the drop-down list box to select the month for which you want to view the supplier ledger report. All the twelve months of a calendar year will be available for selection. The system displays “Jan” by default on launch of the page.

Note: A month must be selected only if “Calendar Year” is selected in the “Date Option” field.

Report Type	Use the drop-down list box to select the type of report that you want to print. You can select from “Summary” for a summary of the report or you can select “Detail” for a detailed report. The system displays “Detail” by default on the launch of the page.
Date From	The starting date in the date range for which you want to view the supplier ledger report (Date Format). The date entered in this field must be before the date entered in the “To” field.

Note: This field must be left blank if “Financial Year” is selected in the “Date Option” field.

Date To	The ending date in the date range for which you want to view the supplier ledger report (Date Format). The system date is displayed by default on launch of the page.
Report ID	Select the check box to print the report ID on all the pages of the report.
Reporting Basis	Use the drop-down list box to select the type of reporting basis of the supplier ledger report. You can select from “Supplier” or “Account”.
Control Account Type	Use the drop-down list box to select the control account of the supplier ledger report. You can select from "Deposit", "Payables" and "Prepayment".
Entry Point Page	Select the check box to print the entry point page on the first page of the report.

Click the “Get Supplier Details” pushbutton to get the supplier details.

The system displays the following fields:

Supplier Code	The code identifying the supplier.
Supplier Name	The name identifying the supplier
Supplier Group	The code identifying the supplier group.

Click the “View Supplier Sub Ledger” pushbutton to view the supplier ledger report.

The system generates and displays the ageing report of the supplier based on the search criteria entered.

Supplier Ledger – An overview

This report lists all the individual debits and credits in any supplier account. This report can be generated in a detailed and summary format also for a supplier or a supplier account which is the Control Account / Prepayment Account / Deposit Account for a time period. In the detail report, it is possible to view the individual debits and credits date wise. The details such as transaction type, date, debit/credit, currency, amount, etc are also displayed. However, the summary report classifies the transactions under opening balance, debits, credits and closing balance.

You can search by selecting the company, the corresponding business unit and the corresponding finance book for which you want to view the ledger report. You can search by specifying the group and a range of codes identifying the suppliers for whom you want to view the ledger report. You can also select the currency option and the currency in which you want to view the ledger report. You can also select a particular date option where you can select a specific financial year, financial period, calendar and month to view the ledger report. You can also select the reporting basis to view the report. The system retrieves the ledger report based on the search criteria entered.