Schedule of Subsidiary Ledger Report

Overview

To analyse amount payable of a vendor against each disbursement voucher.

Navigation

General Ledger ► Reports ► Philippines Reports ► Schedule of Subsidiary Ledger Report

Schedule of Subsidiary Ledger Report Screen Fields

Fields

Description

Fiscal Year

Mandatory-Allow to select fiscal year.

Currency

Optional - if its selected will get all the EV with selected currency

From Date

Allows to select Form date from date picker

To Date

Allows to select To date from date picker

Is Group By GL Account

Default value is TRUE

Vendor

Mandatory - Look Up to select the vendors to be included in the report.

Treasury Bank Account

Mandatory- Drop down to select Treasury Bank Name for the Bank account name from the treasury bank account table. Print only the short code from the treasury bank account table.

Expense Voucher Classification

Mandatory - To allow the user to select the payment Type related to the Expense Voucher.

Include Vouchers On Hold

This value comes from the parameter of the Module Expenditures. Default value is TRUE.

Include Payment Suspended

This value comes from the parameter of the Module Expenditures. Default value is TRUE.

Organization

Mandatory-Allow to select Department which is roll up from the "Agency" and allow to select "Agency" which is roll up from operating unit and allow to select operating unit. When select the operating unit the corresponding agency and department will be print.

Fund Cluster

Mandatory- Allow to select Fund cluster from concept "Fund Cluster" it is roll up from "Authorization" in the Funding source segment of UACS.

Fund Authorization

Mandatory- Allow selection from concept "Authorization" which is roll up from "Fund Category” in the "Fund" Segment of UACS. Print as per selection.

UACS Code

Mandatory-Allow single selection the "Sub-object” code from the object segment of the UACS from the drop down show the code and description.

Comment

Optional.  This will be filled up after the report is printed.