Transaction List Payable Management

Transaction List – Payable Management

The Transaction List Report pertains to situations when a company may want to list out the transactions of a supplier for a particular time frame, like a year or a period that can be listed.Tell me more.

Select the “Transaction List – Payable Management” link under the “Reports – Payables Management” business component.

The “Transaction List – Payable Management” 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 transaction listing 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 transaction listing 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 transaction listing 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 transaction listing 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 transaction listing report (Alphanumeric, 18).
Supplier Code To	The ending code in the range of codes identifying the suppliers for whom you want to view the transaction listing report (Alphanumeric, 18).
Currency Option	Use the drop-down list box to select the type of currency in which you want to view the transaction listing 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 transaction listing 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.
Sort By	Use the drop-down list box to select the type of sorting in which you want to view the transaction listing report. You can select from “Supplier Name”, “Finance Book” and “Transaction Type”. The system displays “Supplier Name” by default on the launch of the page.
Date Option	Use the drop-down list box to select the time duration for which you want to view the transaction listing 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 transaction listing 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 transaction listing 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 transaction listing 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 transaction listing 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.

Tran Type	Use the drop-down list box to select the transaction type for which you want to view the transaction listing report. You can select from “Item Invoice”, “Expense Invoice”, “Item Based Debit Note”, “Item Based Credit Note”, “Order Based Invoice”, “Account Based Debit Note”, “Account Based Credit Note” and “Delivery Charges Invoice”.
Date From	The starting date in the date range for which you want to view the transaction listing 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 transaction listing report (Date Format). The system date is displayed by default on launch of the page.
Entry Point Page	Select the check box to print the entry point page on the first page of the report.
Due Date From	The starting due date in the range of dates for which you want to view the transaction listing 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 transaction listing 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.

The system displays the following:

Tran Type

The type of transaction selected to view the transaction listing report.

Enter the following fields:

Doc. No. From	The starting number in the range of transaction documents that you want to retrieve (Alphanumeric, 18). The number entered in this field must be before the number entered in the “Document No. To” field.
Doc. No. To	The ending number in the range of transaction documents that you want to retrieve (Alphanumeric, 18). The number entered in this field must be after the number entered in the “Document No. From” field.
Doc. Status	Use the drop-down list box to select the status of the document for which you want to view the transaction listing report. You can select from “Fresh”, “Authorized”, “Paid”, “Held” and “All”. The system displays “All” by default on the launch of the page.

Click the “View Transaction List” pushbutton to view the transaction listing report.

The report displays all the details of the transaction list based on the values entered in the search criteria.

Transaction List – Payable Management – An overview

This report lists out the various transactions like invoicing, credit notes, debit notes, payments etc between the supplier and the company. The user can also retrieve a particular transaction, of a particular status, of a particular currency and in a particular timeframe.

You can search by selecting the company, the corresponding business unit and the corresponding finance book for which you want to view the transaction list report. You can search by specifying the group and a range of codes identifying the suppliers for whom you want to view the transaction list report. You can also select the currency option and the currency in which you want to view the listing report. You can also sort out the way you want to view the transaction list 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 listing report. The system retrieves the transaction listing report based on the search criteria entered.