The batch jobs are listed alphabetically in the below table and the last column indicates the location in the Batch Catalog. For detailed information on the jobs (such as when to run, input, output, and process parameters) refer to the associated run sheet in the following user guides: CGI Advantage Financial - Accounts Payable Run Sheets and CGI Advantage Financial - Utilities Run Sheets.
|
Job Name |
Description |
Batch Catalog Section |
|
Automated Payment Hold |
This process selects payment request lines from the Disbursement Request table to determine the corresponding active request/removal payment hold records from Payment Hold Maintenance Table and applies a Hold Status at different Hold levels and identifies the highest priority Hold Type and sets this as the new Current Hold Type and Hold Level. It also updates the Payment Hold Activity table to close the hold and update the number of days held. |
AP |
|
Backup Withholding History |
This process will select applicable records associated with Backup withholding from the Accounting Journal and populate them in the Backup Withholding History Detail (BWNPH). |
AP |
|
Consolidation By Payment Request Department |
This batch job will set the Disbursement Request (DISRQ) records Consolidated Object 6 field with the Document Department Code from the Payment Request mapped to the respective DISRQ records. This process automatically provides a mechanism within disbursement processing to consolidate payment requests based on the Payment Request Document Department Code. It will make use of one of the six (6) Consolidation Objects available fields on the DISRQ record for each payment request. Consolidation Objects are placeholders for fields not included in the standard consolidation that are part of the AD consolidation logic but are not utilized to group applicable payment requests. |
AP |
|
CTX EDI Formatting |
This process generates the CTX Addenda Records based on the EDI ANSI ASC X12 820 Remittance Advice/Payment Order. This batch process is only applicable to EFT documents with the Disbursement Format of ‘CTX’. |
AP |
|
Disbursement Correction |
The Check Correction process is used to void and/or renumber records that are in the disbursement cycle and have not been posted to ledgers. In addition, the process allows the user to reprint physical checks that were printed on pre-printed check stock (after the Disbursement process is finished). |
AP |
|
Disbursement Parameter Updates |
Disbursement Parameter Update process automatically updates all active records on the DISPA table with the 'To Date' selection criteria for the next disbursement process. |
AP |
|
Disbursement Printing |
The Disbursement Printing job in Advantage prints checks, warrants, and remittance advices with check stub details. |
AP |
|
EFT ACH File Reversal |
This process is used to correct the situation in which the entire ACH file with EFT payments was processed by the bank more than one time but the EFT payments were processed only once in FMS/3. The process should be run only if the EFT transactions were sent to the bank erroneously more than one time since this job is not going to make any updates to the any document or table in the application. |
AP |
|
Extended Payment Request Scheduling |
This process sets and calculates the Schedule Payment Date, Disbursement Priority and Scheduling Reason code on Disbursement Request (DISRQ) table (R_AP_DISB_RQST). |
AP |
|
Flat File To Xml |
The PCard Flat to XML process converts the flat file sent by the credit card company into XML format. This job is part of the Procurement Card Chain job. |
AP |
|
Initiate Backup Withholding |
The process will flag selected Taxpayer records on the 1099I table as subject for Backup Withholding. The process will select applicable records from the 1099I table, for which the number of calendar days since the last B Notice was sent is greater than or equal to the number of Compliance Days (the number of Compliance Days is defined on 1099P table for the current Calendar Year). In addition to updating appropriate records on the 1099I table, the batch process will generate a Backup Withholding Initialization Report. This report will lists all records selected from the 1099I and flagged as subjects to Backup Withholding (this means the report will reflect the state of the records after they have been updated by the Initiate Backup Withholding job). |
AP |
|
IRS TIN/Name Match Extract |
This process extracts Taxpayer ID information from vendor registration information so that it can be matched to IRS records using the IRS TIN/Name Match e-Service. This job selects all eligible records from 1099I where the Taxpayer ID and TIN Type are populated and the Send to IRS and 1099 Reportable flags are checked. |
AP |
|
IRS TIN/Name Match Update |
This process updates entries on the 1099 Reporting Information (1099I) table based on the IRS TIN/Name Match Status file that is returned from the IRS TIN/Name Match e-service. |
AP |
|
Journal Posting Initiator |
This process will read documents with a specified Journal Posting Indicator of "Not Ready to Post", and update the Journal Posting Indicator to "Ready to Post". The process runs off of the user entered parameters. |
AP |
|
Mass Cancellation |
The Mass Cancellation batch process cancels Checks (automated or manual), Warrants or Electronic Fund Transfers (EFT). It gives users the flexibility to Reschedule, Hold and Cancel Checks / Warrants / EFTs in bulk. |
AP |
|
Multi Process Disb Journal Posting |
The Multi Process Disbursement (Disb) Journal Posting is used in conjunction with the Asynchronous Posting setting on the Document Control (DCTRL) page for the Auto Disbursement document codes. The job performs the same tasks as the Journal Posting Initiator and then spawns multiple Journal Engine jobs to post all of the selected automatic disbursements. |
AP |
|
Offline 1099 |
The 1099 Reporting Process consolidates vendor income by predetermined criteria and generates IRS form and correction data files that can then be imported into a third party tool to generate 1099 MISC, 1099 INT, 1099 G, 1099 S and 1042 S forms as well as Magnetic Media records. |
AP |
|
Paid Check Table Restore |
This process restores records to the Paid Checks (PDCHK) table that were removed by the Paid Check Archiving chain. |
UTIL |
|
Print Payment Hold Notice |
This process prints Notice Letters for applicable held payment requests on the Payment Hold Activity table or for requested held payments on the Print Payment Hold Notice table. This process runs after executing the Automated Payment Hold batch process. |
AP |
|
Select Payment Hold by TIN |
This process selects the records from the Payment Hold by TIN table to insert or update corresponding records to the Payment Hold Maintenance table. |
AP |
|
Stale Escheat |
This process is used to Stale Date or Escheat checks issued by the automated disbursement process when the criteria have been met. |
AP |
|
Unprocessed Pcard Load |
This process loads the XML file generated from the P Card Flat File to XML process (FlatToXml utility) to the Unprocessed Procurement Card Activity table. This job is part of the Procurement Card Chain job. |
AP |