Overview
This section shows the different Reports available in the Contract Management module. For each Report, the Output is first presented, and then the procedure for generating the Report is made available
Overview
This report shows a List of Contracts each one with contract information such as ID, Short Description, Type, Vendor, Start Date, End Date, Status, Total Amount, Physical Current Progress, and Payment Current Progress.
Some additional filters are available such as Contract Status, Institution, Vendor, Contract Type, Funding Source, Project, Fiscal Year, and Start Date Period.
Sort criteria by any column are possible.
Navigation
Contract Management ► Contract Management Reports ►Contract Listing Report
Definition Of Report Fields
| Field | Description |
Institution | If selected, the report will include the selected Institution unit and all Institutions below the selected unit |
Vendor | Name of Vendor. |
Contract Type | Contract Type. Ex: Big Works, Goods, Services, etc. |
Initial Execution Fiscal Year | Filter criteria to filter the report by Fiscal Year. |
Start Date From | Start date of the Contract. |
Start Date To | Filter criteria to filter the report by Start Date. |
Contract Status | Filter criteria to filter the report by Contract Status. |
Comments | Users can give additional comments on the report. |
Sort | Criteria determining how the report information will be sorted are selected from the field |
Overview
This report shows a list of Institutions each one with summary information of its Contracts such as Contracts Quantity, Total Amounts, and Already Paid Amount, etc
Navigation
Contract Management ► Contract Management Reports ► Contracts Summary by Institution Report
Contract Line Item Drop screen fields and Tab
Field | Description |
Vendor | Filter criteria to filter the report by Vendor |
Contract Type | Filter criteria to filter the report by Contract Type |
Initial Execution Fiscal Year | Filter criteria to filter the report by Fiscal Year |
Start Date From | Filter criteria to filter the report by Start Date From |
Start Date To | Filter criteria to filter the report by Start Date To |
Contract Status | Filter criteria to filter the report by Contract Status |
Comment | Additional comments to be added to output report |
Amounts Rounding | Filter criteria to filter the report by Amounts Rounding |
Sort By | Filter criteria to sort the report by the selected criteria |
Id | Filter criteria to sort the report by Id |
Funding Source Tab | Filter criteria to filter the report by Funding Source |
Project Tab | Filter criteria to filter the report by Project |
Overview
This Report shows a List of Institutions Units which belong to the same Institution. The Report shows each Institution Unit with summary information of its Contracts such as Contract Quantity, Total Amount, and Already Paid Amount.
Navigation
Contract Management ► Contract Management Reports ► Contracts Summary by Institution Unit Report
Contracts Summary by Institution Unit Report screen fields and Tab
| Field | Description |
Institution | Filter criteria to filter the report by Institution |
Vendor | Filter criteria to filter the report by Vendor |
Contract Type | Filter criteria to filter the report by Contract Type |
Initial Execution Fiscal Year | Filter criteria to filter the report by Fiscal Year |
Start Date | Filter criteria to filter the report by Start |
Contract Status | Filter criteria to filter the report by Contract Status |
Comments | Additional comments to be added to output reports |
Sort By | Filter criteria to sort the report by the selected criteria |
Institution Id | Filter criteria to sort the report by Institution Id |
Funding Source Tab | Filter criteria to filter the report by Funding Source |
Project Tab | Filter criteria to filter the report by Project |
Overview
This report shows a list of Vendors each one with summary information of its Contracts such as Contracts Quantity, Total Amounts, and Already Paid Amount
Navigation
Contract Management ► Contract Management Reports ► Contracts Summary by Vendor Report
Contracts Summary by Vendor Report screen fields and Tab
| Field | Description |
Institution | Filter criteria to filter the report by Institution |
Vendor | Filter criteria to filter the report by Vendor |
Contract Type | Filter criteria to filter the report by Contract Type |
Initial Execution Fiscal Year | Filter criteria to filter the report by Fiscal Year |
Start Date | Filter criteria to filter the report by Start |
Contract Status | Filter criteria to filter the report by Contract Status |
Comments | Additional comments to be added to output reports |
Sort By | Filter criteria to sort the report by the selected criteria |
Institution Id | Filter criteria to sort the report by Institution Id |
Funding Source Tab | Filter criteria to filter the report by Funding Source |
Project Tab | Filter criteria to filter the report by Project |
Overview
This Report shows a List of Funding Sources, each one with Contract summary information such as Total Planned Amount, Contracts Quantity, Contracts Total Amount, etc.
Navigation
Contract Management ► Contract Management Reports ► Contracts Summary by Funding Source Report
Contracts Summary by Institution Unit Report screen fields and Tab
| Field | Description |
Institution | Filter criteria to filter the report by Institution |
Vendor | Filter criteria to filter the report by Vendor |
Contract Type | Filter criteria to filter the report by Contract Type |
Initial Execution Fiscal Year | Filter criteria to filter the report by Fiscal Year |
Start Date | Filter criteria to filter the report by Start |
Contract Status | Filter criteria to filter the report by Contract Status |
Comments | Additional comments to be added to output reports |
Sort By | Filter criteria to sort the report by the selected criteria |
Funding Source | Filter criteria to filter the report by Funding Source |
Project | Filter criteria to filter the report by Project |
| Rounding Option | Filter criteria to filter the report by Rounding Option. |
Overview
This report provides month-wise breakdown of planned, actual and balance of the payments during a fiscal year for each managed contract under the Institution. The report displays grouping level by Institution in which it summarizes planned, actual and balance of the payments information of the managed contracts against vendors for each specific Institution.
Navigation
Contract Management ► Contract Management Reports ► Cash Outflow Projection Report
Cash Outflow Projection Report screen Fields
Field | Description |
Fiscal Year | Fiscal year used as filter criteria. |
Comment | Users can add comments for future reference. |
| Institution | Institute to be selected along with fiscal year for filtering records. |
Overview
This report shows a list of Projects each one with summary information of their Contracts such as Contracts Quantity, Contracts Total Amount, and Already Paid Contracts Amount
Navigation
Contract Management ►Contract Management Reports ►Contracts Summary by Project Report
Contracts Summary by Project Report screen fields and Tab
| Field | Description |
Institution | Filter criteria to filter the report by Institution |
Vendor | Filter criteria to filter the report by Vendor |
Contract Type | Filter criteria to filter the report by Contract Type |
Initial Execution Fiscal Year | Filter criteria to filter the report by Fiscal Year |
Start Date | Filter criteria to filter the report by Start |
Contract Status | Filter criteria to filter the report by Contract Status |
Comments | Additional comments to be added to output reports |
Sort By | Filter criteria to sort the report by the selected criteria |
Funding Source Tab | Filter criteria to filter the report by Funding Source |
Overview
This report generates information about the planned contract payments during a year (fiscal periods) for each managed contract and institution. It also displays the total of amount corresponding to the planned contract payments for each fiscal period during a fiscal year.
Navigation
Contract Management ► Contract Management Reports ► Planned Payments By Fiscal Period Report.
Planned Payments By Fiscal Period Report Fields
Field | Description |
Fiscal Year | Fiscal Year to which Planned Contract Payment relates, to be selected from dropdown box. |
Institution | Related Institution to be selected from lookup button. |
Comments | Comment on the report to be entered by users in this field. |
Sort By: Institution | Sorting of report by Institution either in Ascending Order or Descending Order is done from Upward or downward button. |
Sort By: Managed Contract | Sorting of report by Managed Contract either in Ascending Order or Descending Order is done from Upward or downward button. |
Overview
This Report shows general information for a Contract, such as ID, Reference Number, Short Description, etc.
Navigation
Contract Management ► Contract Management Reports ► Contract General Information Report
Contract General Information Report screen field and Tab
Field | Description |
Contract | Filter criteria to filter the report by Contract. |
Overview
This Report shows the List of Line Items or Activities within a Contract
Navigation
Contract Management ► Contract Management Reports ► Contract Line Items Report
Contract Line Items Report screen fields and Tab
Field | Description |
Contract | Filter criteria to filter the report by Contract |
Line Item Status | Filter criteria to filter the report by Line Item Status |
Line Item Type | Filter criteria to filter the report by Line Item Type |
Comments | Additional comments to be added to output reports |
Sort By | Filter criteria to sort the report by the selected criteria |
Overview
This Report shows the List of Drops or Work Items within a Contract.
Navigation
Contract Management ► Contract Management Reports ► Contracts Drops Report
Contracts Drops Report screen fields and Tab
Field | Description |
Contract | Filter criteria to filter the report by Contract |
Line Item | Filter criteria to filter the report by Line Item |
Status | Filter criteria to filter the report by Status. |
Comments | Additional comments to be added to output reports |
Sort By | Filter criteria to sort the report by the selected criteria |
Delivery Date From | Filter criteria to filter the report by Delivery Date From |
Delivery Date To | Filter criteria to filter the report by Delivery Date To |
Overview
This Report shows the List of Physical Inspections within a Contract. Each Physical Inspection with the following information: Inspection ID, Inspection Status, Planned Date, Inspection Date, Drop Physical Progress, Line Item ID to which belongs, Drop ID to which belongs, Inspector Responsible, and Comments.
Some additional filters are available such as Inspection Status, Planned Date Period, Inspection Date Period, Drop, and Line Item.
Navigation
Contract Management ► Contract Management Reports ► Contract Inspection Report
Contract Inspection Report screen fields and Tab
Fields | Description |
Contract | Filter criteria to filter the report by Contract. |
Line Item | Filter criteria to filter the report by Line Item. |
Line Item Drop | Filter criteria to filter the report by Line Item |
Inspection Status | Filter criteria to filter the report by Inspection Status |
Comments | Additional comments to be added to output reports. |
Planned From Date | Filter criteria to filter the report by Planned From Date. |
Planned To Date: | Filter criteria to filter the report by Planned To Date. |
Inspection From Date | Filter criteria to filter the report by Inspection From Date. |
Inspection To Date | Filter criteria to filter the report by Inspection To Date |
Sort By | Filter criteria to sort the report by the selected criteria |
Inspection Id | Filter criteria to sort the report by Inspection Id. |
Overview
This report shows a list of Payments including Normal Planned Payments and Payment Advances within a Contract.
Navigation
Contract Management ► Contract Management Reports ► Contract Payments Report
Contract Payments Report screen fields
Field | Description |
Contract | Filter criteria to filter the report by Contract |
Payment Status | Filter criteria to filter the report by Payment Status |
Planned Date From | Filter criteria to filter the report by Planned Date From |
Planned Date To | Filter criteria to filter the report by Planned Date To |
Payment Date From | Filter criteria to filter the report by Payment Date From |
Payment Date To | Filter criteria to filter the report by Payment Date To |
Payment Type: | Filter criteria to filter the report by Payment Type |
Funding Source | Filter criteria to filter the report by Funding Source |
Payment Method | Filter criteria to filter the report by Payment Method |
Comments | Additional comments to be added to output reports |
Payment Details | Filter criteria to filter the report by Payment Details. |
Sort By | Filter criteria to sort the report by the selected criteria |
Payment Id | Filter criteria to sort the report by Payment Id. |
Overview
This Report shows the detailed information of a Payment, such as; ID, Type, Status, Planned Date, Payment Date, etc. The report also contains Payment Detail information; a list of payment details associated with the payment. Each Payment Detail is associated with a Drop of the Contract.
Navigation
Contract Management ► Contract Management Reports ► Contract Payment Detail Report
Contract Payment Detail Report screen fields
Field | Description |
Payment | Filter criteria to filter the report by Payment |
Overview
This Report shows a List of Payment Retentions within a Contract
Navigation
Contract Management ► Contract Management Reports ► Contract Payment Retentions Report
Contract Payment Retentions Report screen fields
Fields | Description |
Contract | Filter criteria to filter the report by Contract. |
Line Item | Filter criteria to filter the report by Line Item |
End Date From: | Filter criteria to filter the report by End Date From |
End Date To | Filter criteria to filter the report by End Date To. |
Status | Filter criteria to filter the report by Status. |
Comments | Additional comments to be added to output reports. |
Sort By | Filter criteria to sort the report by the selected criteria |
Payment Retention Id | Filter criteria to sort the report by Payment Retention Id |
Overview
This Report shows a List of Contracts each one with summary information of their Payments such as Contract Total Amount, Planned Payments Amount, Already Paid Amount, etc
Navigation
Contract Management ► Contract Management Reports ► Payment Summary by Contract Report
Payment Summary by Contract Report screen fields
| Field | Description |
Institution | Filter criteria to filter the report by Institution |
Vendor | Filter criteria to filter the report by Vendor |
Contract Type | Filter criteria to filter the report by Contract Type |
Initial Execution Fiscal Year | Filter criteria to filter the report by Fiscal Year |
Contract Status | Filter criteria to filter the report by Contract Status |
Comments | Additional comments to be added to output reports |
From date | Filter criteria to filter the report by Start Date From |
To Date | Filter criteria to filter the report by Start Date To |
Sort By | Filter criteria to sort the report by the selected criteria |
Funding Source Tab | Filter criteria to filter the report by Funding Source |
Project Tab | Filter criteria to filter the report by Project |
Overview
This Report shows the current situation of Physical Progress of a Contract. It includes Line Items, Drops, and Inspections each one with percentage of progress based on Physical Inspections or Receptions
Navigation
Contract Management ► Contract Management Reports ► Contract Physical Tracking Report
Contract Physical Tracking Report screen fields
| Fields | Description |
Contract | Filter criteria to filter the report by Contract ID |
Overview
This Report shows the current situation of Payment progress in a Contract. It includes Line Items, Drops, and Payments each one with amounts and percentages of progress based on completed Payments
Navigation
Contract Management ► Contract Management Reports ► Contract Payment Tracking Report
Contract Payment Tracking Report screen fields
| Fields | Description |
Contract | Filter criteria to filter the report by Contract ID |
Overview
This Report shows the current situation of Physical and Payment Progress in a Contract. It includes Line Items and Drops each one with amounts and percentages of progress based on Physical Inspections and completed Payments.
Navigation
Contract Management ► Contract Management Reports ► Contract Complete Tracking Report
Contract Complete Tracking Report screen fields
| Fields | Description |
Contract | Filter criteria to filter the report by Contract ID |