Generate Collection Report
This function allows the users to generate and list all the receipts issued and payment collected within a certain date period.
Role Involve: School Finance Officer or School Admin
-
Main Menu > Reporting Tools > Query > Query Viewer.
-
Enter MOE_BI_COLLECTION_REPORT query name in the begins with field.
-
Search: Click to search for a query using the basic search function.
-
Advanced Search: Click the Advanced Search link to search for a query using the advanced search function.
-
HTML: Click a HTML link for the selected query to view its results in a new browser window in HTML format.
-
Excel: Click a Excel link for the selected query to view its results in a new browser window in Excel format.
-
XML: Click a XML link for the selected query to view its results in a new browser window in XML format.
-
Schedule: From the Query Viewer search results page, click the Schedule link that is associated with the query.
-
Enter the required values in the Business Unit, Institution, Campus, From Date and To Date fields.
-
Business Unit: MOE01
-
Institution:
-
Campus:
-
From Date:
-
To Date:
-
Click on the Excel SpreadSheet link to download the report in Excel.
Description Field:
Note: Make sure the required Query Name field are not empty.
Required Fields:
Note: Make sure the required fields are not empty: Year, Fee Type, Citizenship, Frequency and Amount .