Batch Jobs

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 - 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 the Payment Hold Maintenance table. The process also applies a Hold Status at different Hold levels, 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) table.

AP

Consolidation By Payment Request Department

This batch job will set the Disbursement Request records Consolidated Object 6 field with the Transaction Department Code from the Payment Request mapped to the respective Disbursement Request table records.

This process automatically provides a mechanism within disbursement processing to consolidate payment requests based on the Payment Request Transaction Department Code. It will make use of one of the six (6) Consolidation Objects available fields on the Disbursement Request 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 transactions 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 Disbursement Parameters (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 Advantage Financial. 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 transaction 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 the Disbursement Request table.

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

Generate Positive Pay

The Generate Positive Pay batch process creates the Positive Pay files of disbursed and cancelled checks.

AP

Initiate Backup Withholding

The process will flag selected Taxpayer records on the 1099 Reporting Information (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 1099 Processing Options and Control (1099P) table for the current Calendar Year).

In addition to updating appropriate records on the 1099 Reporting Information table, the batch process will generate a Backup Withholding Initialization Report. This report will lists all records selected from the 1099 Reporting Information table 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 1099 Reporting Information table 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 transactions 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

MultiProcess Disb Printing

This process multi-threads the printing process by spawning the Disbursement Printing job and prints the Checks, Warrants, and Remittance Advises in clusters.

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

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

Treasury Offset

This process identifies scheduled payment requests that have a Tax Identification Number (TIN) and are eligible for offset. It creates an XML message for applicable taxpayers and calls a web service to an external agency, such as the Treasury, to check for outstanding debt. This occurs real time during the batch cycle and returns debt information for debtors utilizing a SOAP (Simple Object Access Protocol) request.

AP

Unprocessed Pcard Load

This process loads the XML file generated from the PCard 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

Retiree VCUST Extract

This process extracts non-retired individuals from Vendor Customer (VCUST) records and writes them to a text file for exporting.

This process is one of three that supports this specialized processing with an external payroll system.

AP