Supplier Balance Inquiry

This report provides the user information related to supplier balances for both open and matched (cleared) items at various levels of detail.Tell me more.

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

The “Supplier Balance Inquiry” 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 balance inquiry 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 balance inquiry 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 balance inquiry 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.
Supplier Group	Use the drop-down list box to select the supplier group for which you want to view the balance inquiry 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 balance inquiry report (Alphanumeric, 18).
Supplier Code To	The ending code in the range of codes identifying the suppliers for whom you want to view the balance inquiry report (Alphanumeric, 18).
Currency Option	Use the drop-down list box to select the type of currency in which you want to view the balance inquiry 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 balance inquiry 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.
Transaction Desc.	Use the drop-down list box to select the transaction description for which you want to view the balance inquiry report. You can select from “Open”, “Cleared” and “All”. The system displays “All” by default on the launch of the page.
Include Prepayments	Use the drop-down list box to select whether you want to include the prepayments details in the balance inquiry report. You can select from “Yes” or “No”. The system displays “Yes” by default on the launch of the page.
Language	Use the drop-down list box top select the language in which you want to view the balance inquiry report. You can select “English”.
Date Option	Use the drop-down list box to select the time duration for which you want to view the balance inquiry 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 balance inquiry 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 balance inquiry 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 balance inquiry 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 balance inquiry 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.

Date From

The starting date in the date range for which you want to view the balance inquiry 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.

To	The ending date in the date range for which you want to view the balance inquiry report (Date Format). The date entered in this field must be after the date entered in the “Date From” field.
Due Date From	The starting due date in the range of dates for which you want to view the balance inquiry report (Date Format). The due date entered in this field must be before the due date entered in the “To” field.
To	The ending due date in the range of dates for which you want to view the balance inquiry report (Date Format). The due date entered in this field must be before the date entered in the due date from field.
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.

Click the “View Vendor Balance Statement” pushbutton to view the supplier balance inquiry report.

Supplier Balance Inquiry – An overview

Information can be viewed at the summary level, or classified according to the nature of transaction. Details like the transaction amount, the due amount, the adjusted amount, the details of payment; payment application, discount received, penalty incurred and so on can be viewed. This report is in the form of a Drill down

You can search by selecting the company, the corresponding business unit and the corresponding finance book for which you want to view the balance inquiry. You can search by specifying the group and a range of codes identifying the supplier for whom you want to view the balance inquiry. You can also select the currency option and the currency in which you want to view the balance inquiry. You can also select to include the prepayment in the report. The system retrieves the balance inquiry based on the search criteria entered. You can view the details of the company, the supplier and the type of the transaction that has taken place between the supplier and the organization.