Srilanka Reports

Accounts Payable with Aging Analysis Report

Overview

The accounts payable aging report categorizes payable to suppliers based on time frames. The intent of the report is to help TOD in determining which invoices are overdue for payment.

Navigation

Expenditures >> Reports >> Srilanka Reports >> Accounts Payable with Aging Analysis Report

Accounts Payable with Aging Analysis Report Screen Fields

Fields

Descriptions

Fiscal Year

Mandatory-Allow to select fiscal year. By default, show the current fiscal year.

Payment Date

Mandatory. Restricts Expense Voucher selection: Invoice Receipt Date

Payment Due Date

Payment Due Date. Default as per the Payment Terms defined in the Expense Voucher header

Include Vouchers On Hold

Determines if the Vouchers on hold should be included in the report.

Include Payment Suspended

To indicate if the payment has been suspended through the ‘Payment Suspension’ Process. Suspended Payments will not be processed within the Payment function and cannot be released. Extracted Payments cannot be suspended.  Default is False

Include Vouchers Suspended

Determines if the Vouchers on hold should be included in the report.

Period

Allows to select the period from dropdown list

Vendor

Allows to select the vendor code from search functionality

Accounting Office

This will always get the Accounting Office value of the relevant EV.

Treasury Bank Account

Allows to select the Treasury Bank Account Treasury Bank Account from search functionality

Payment Mode

Default value will be populated automatically from the selected vendor information if defined, if not defined in the Vendor, it will be populated from the selected Institution, if not defined in the Institution then default will populated be as defined in the Expenditures Parameter

Payment Method

System will allow user to select only the Payment Type that selected Institution has access to.

Payment Location

Default value will be populated automatically from the selected vendor information if defined, if not defined in the Vendor, it will be populated from the selected Institution, if not defined in the Institution then default will populated be as defined in the Expenditures Parameter

Comment

Comments made on the report

 

Vendor Analysis Progress Report

Overview

To identify the progress of a Purchase Order versus payments (disbursements).

Navigation

Expenditures ► Reports ► Srilanka Reports ► Vendor Analysis Progress Report
 
Vendor Analysis Progress Report Screen Fields

Fields

Descriptions

Fiscal Year

Mandatory-Allow to select fiscal year. By default, show the current fiscal year.

Fiscal Period

Optional - Allow to select fiscal period.

Purchase Order Date

Optional. Date Picker. Allow to select a range of dates

Purchase Order

Optional. Allow to select a range of PO #'s, should be a numeric range.

Purchasing Vehicle

Purchasing Vehicle Short Description

Vendor

Optional - Vendor name

Buyer

Optional - Buyer name

Purchasing Office

Optional - Institution name

Requester

Optional - Institution name

Item

Optional - Catalogue Item short Description

 

Vendor Analysis Report

Overview

Allows users to analyze the amount of business which the organization has done with particular vendors.

Navigation

Expenditures ► Reports ► Srilanka Reports ► Vendor Analysis Report
 
Vendor Analysis Report Screen Fields

Fields

Descriptions

Fiscal Year

Dropdown to select Fiscal Year Filter criteria for this report.

Fiscal Period From

Filter criteria for Fiscal Period From for this report.

Fiscal Period ToFilter criteria for Fiscal Period To for this report.
Report TypeDropdown to select Report Type  Filter criteria for this report.
Workflow StageWorkflow stage of EV that may be selected as filter criteria.
Include Pending ApprovalCheck box, that allow the selection of Pending Approval Expense Vouchers in the report.
CommentAny specific comment to add in the output report.

Cheque Series

Filter for the check series.
Accounting OfficeLookup for select Accounting Office as filter criteria.
Financial InstitutionLookup for select Financial Institution as filter criteria.
Financial Institution BranchDropdown to select Financial Institution Branch Filter criteria for this report.
Payment ModeLookup for select Payment Mode as filter criteria.
Payment LocationLookup for select Payment Location as filter criteria.
Treasury Bank AccountLookup for select Treasury Bank Account as filter criteria.
Cheque NumberFilter criteria for check numbers.
Cheque DateFilter criteria for check date.