For detailed information on the reports (such as input, output, and process parameters), refer to the associated run sheet in the CGI Advantage - Accounts Payable Run Sheets guide.
Report Name |
Description |
Catalog Section |
1099 Exception Report |
The 1099 Exception Report is created by the1099 Offline Batch Process and displays duplicate input records. Records with the same Calendar Year, TIN, Form Type, and 1099 Payer are written to the 1099 Exception Report along with the message, “Duplicate record exists on 1099R table.” Records that are displayed on this report require research to verify if the records are incorrect and if manual correction is needed. |
AP |
1099 Miscellaneous Vendor Report |
The 1099 Miscellaneous Vendor Report details Miscellaneous Vendor records on the 1099 Journal that contain reportable income and no TIN information. This report allows you to Audit these transactions and manually process corrections to the 1099 Reported Income table to issue forms to these vendors if they choose to do so. The report consolidates miscellaneous vendor data by Type of Income, as well as by Vendor Legal Name and Address. Both Legal Name and Address fields are required to prevent two miscellaneous vendors with the same name from being reported together. This report does not take 1099 Type of Income Thresholds into account. Instead, this report will show any miscellaneous vendor income that is reportable, regardless of threshold. |
AP |
1099/1042-S Transaction Report |
The 1099/1042-S Transaction Report captures all 1099 transactions, including Journal Voucher transactions and Disbursement Cancellations, for 1099 Reportable Vendors. |
AP |
1099-S Transactions by Vendor Report |
The 1099-S Transactions by Vendor Report is created by the 1099 Offline Batch Process when it is run in Testing, Magnetic Media, Corrections and Report modes to list all 1099-S transactions. This report will generate when the 1099 Transactions By Vendor check box on the 1099 Processing Options and controls (1099P) table is selected, the 1099-S Reporting indicator is set to Property on the 1099 Reported Income table, and 1099-S transactions have to be added to 1099 Reported Income table manually. |
AP |
Backup Withholding Detail Report By Accounting Distribution |
This report provides detail information by accounting distribution for all backup withholding offsets within a specified date range. This information will be used as an organization's backup withholding offset activity audit trail. |
AP |
Backup Withholding Detail Report By TIN |
The Withholding Detail by TIN report provides detail information by Taxpayer Identification Number and 1099 Form Type for all backup withholding offsets within a specified date range. This report is used as a Vendor Backup Withholding Offset activity audit trail. |
AP |
Backup Withholding Summary Report By Reporting Period |
This report provides summary information by date for all backup withholding offset amounts within a given date range. This report will be used for providing information relating to remittance schedule to the (IRS) Internal Revenue Service. |
AP |
Contract Withholding Detail Report by Accounting Distribution |
This report provides detail information by accounting distribution for all contract withholding offsets within a specified date range. This information is used as an organization’s Contract Withholding offset activity audit trail. The report job reads the 1099 Journal for posting pair K. |
AP |
Contract Withholding Detail Report by Tax Identification Number (TIN) |
This report provides detail information by TIN for all contract withholding offsets within a specified date range. The report job reads the 1099 Journal for posting pair ‘K’. This report is used as a vendor Contract Withholding offset activity audit trail. |
AP |
Contract Withholding Summary Report by Reporting Period |
This report provides summary information by date for all 3402(t) Contract Withholding offset amounts within a given date range. The report reads the 1099 Journal as input. This report is used for providing information relating to remittance schedule to the (IRS) Internal Revenue Service. The report is sorted by Transaction Record Date. |
AP |
Non-Reconciled Procurement Card Transaction by Status |
This report is generated as part of the Procurement Card Payment Creation process. The report displays procurement card transaction activities that have not been reconciled with a cardholder receipt. |
AP
|
Retainage Suspect After Encumbrance Correction |
The Retainage Suspect After Encumbrance Correction report exists because the chart of accounts elements (COA) on the accounting line of a purchase order move to a referencing payment request, then to a disbursement transaction, where retainage is recorded. If the COA, namely the Fund should have been different on the disbursement because the wrong purchase order was referenced, retainage will be recorded into the Retainage Liability account under a different Fund. That money liability will sit there until the retainage is paid out to the vendor or forfeited by the vendor. Purchase orders with retainage terms create retainage table entries where subsequent payment requests and disbursements make updates to track retainage from being withheld until being returned or forfeited. When an encumbrance correction is done for an encumbrance commodity line that has retainage terms, there may be retainage table entries that are not as accurate as they could have been initially. As a result of this retainage issue, Retainage Suspect After Encumbrance Correction report is provided that will identify encumbrance corrections that may have had retainage impacts so that those users responsible for retainage management can be notified and act accordingly. The job selects Final and Historical Final records in the Payment Request accounting line catalog that have the transaction code specified in the parameters. If a Start Date is specified, the job will select records in the Payment Request accounting line catalog with a Transaction Last Date value equal to or after the Start Date. The Transaction Last Date is the date the payment request accounting line went to Final status. If a Start Date is not specified, the job will select all Final and Historical Final records in the Payment Request accounting line catalog. The job compares the referenced purchase order transaction information from these selected Payment request accounting lines to the Retainage Detail Table. If the referenced purchase order line that was corrected is listed in the retainage detail table, then that record is selected for the report. |
AP
|
Review Payment for Offset |
The Review Payment for Offset report allows a site to review payments that may potentially be offset based on the active records on the Disbursement Parameters table. This report compares transactions on the Disbursement Request table with records on the Intercept Request table to determine if the DISRQ records are eligible for intercept based on the active records on the Disbursement Parameters table. The Review Payments for Offset report is run prior to the Disbursement process in order to determine the volume of payments that may be intercepted during the disbursement process. This report is sorted by Vendor and then Bank Account. |
|
Scheduled and Unscheduled Payment Report |
The Scheduled Payment report lists the payments that will be picked up by Automated Disbursement process. The Unscheduled Payment report lists the payments that will not be picked up by Automated Disbursement process. These reports should be run before the Automated Disbursement process. This allows you to determine if you need to make any corrections or reschedule any payment requests. |
AP |
System Hold Report |
This report lists all of the accounting lines that were selected by the Automated Disbursement run that were not able to be liquidated during that run and were put on System Hold. This report also displays the reason (system hold reason) why the records could not be liquidated. This report uses the Disbursement Request and Disbursement Parameters (DISPA) tables as input to generate the report by retrieving the records that are on System Hold on the Disbursement Request table that are associated with Active records on the Disbursement Parameters table. Once the System Hold records are selected from the Disbursement Request table, the system performs a lookup for the records on the Disbursement Parameters table based on the Bank Account of the selected records, and retrieves the Credit Memo Consolidation Options selected on those records and generates the output. |
AP |
Upload 1099 External Reported Income Exception Report |
The Upload 1099 External Reported Income Exception Report is created by the Upload 1099 External Reported Income Process and displays duplicate input records. Records with the same Calendar Year, TIN, Form Type, and Reporting Payer are written to the Upload 1099 External Reported Income Exception Report. Records that are displayed on this report require research to verify if the records are incorrect and if manual correction is needed. |
AP |
Vendor Customer Archiving Facilitator Report |
This report is produced by the Post Archive Process job step in the Vendor Customer Archiving chain when run in Full mode. The report lists each table with records archived, the number of records archived, and the filename containing the archived records. |
Utilities |
Vendor Customer Archiving Statistics Report for Financial |
This report is produced by the Archive Preprocessing job step in the Vendor Customer Archiving chain when run in Full mode. The report lists each table in the Table Parameter File along with the number of records from that table that are eligible to be archived or deleted. |
Utilities |