Matching uses multiple tables to store and compare all of the Ordered, Received, Invoiced, and Paid amounts for a particular Award document. Such activity is tracked on the Matching Status (MATA) table. The following types of documents are eligible to update the Matching Status tables:
Commodity Based Purchase Orders (PO, CT, SC, RPO, DO, … - Any document codes in the PO document type)
Receivers (RC or other document codes in the RC document type that referenced an order)
Invoices (IN or other document codes in the IN document type that referenced an order)
Commodity Based Payment Requests (PRC, PRCI, PRM, PRMI, CEC, and any document code in the PR document type that referenced an order.)
CGI Advantage Procurement uses six different Matching Status tables to record data from Awards, Receivers, Invoices, and Payment Requests:
Matching Status Invoice Header
Matching Status Invoice Line
Matching Status Award
Matching Status Award Line
Matching Status Receiver Line
Matching Status Payment Line
Two different views are associated with Matching in CGI Advantage Procurement, the Matching Status view (MATA) and the Matching Status Award Line view. The Matching Status - Single Award Line view (MATSA) only shows Matching information for the selected Award Line (commodity line) and not all of the lines on the Award. Transitions between the two tables exist that perform searches on the second table when navigating between tables based on the selected record on the first table.
Each time one of the documents designated by the Matching Indicator value from the Commodity or Procurement Document Control table is generated via Matching Manager, the Document ID of the PR document appears as a hyperlink in the Payment Request Document column of the Matching Status Award Lines table. The PR document Phase and Status will also be displayed. When multiple PR documents are created, each document will be displayed as a separate row on the Matching Status Award Lines table.
Advantage allows authorized users to archive and unarchive records on the Matching Status tables by submitting the Matching Tables Archive or the Matching Tables Archive Restore chain job. Refer to the associated run sheets in the CGI Advantage Financial - Utilities Run Sheets guide for more information.
For situations in which you need to bypass the matching process and manually create a Payment Request for one or more Award lines, the Matching Status table provides the functionality to immediately generate PRC documents referencing designated Award Lines in the Draft Phase.
You can select the Create PRC indicator for the Award Lines that are displayed on the page and then select the Override action. This generates a PRC in the Draft Phase on the Document Catalog that must be manually processed by a user with the appropriate authority. The Document ID of the PRC or PRCI document that is generated appears as a hyperlink in the Payment Request Document section of the Matching Status Payment Line table (displayed at in the bottom section of the Matching Status page). The PR document Phase and Status will also be displayed. PRC documents created by the override functionality on MATA are consistent with PRM documents generated by the Matching process in the following two ways:
If available, IN document information is populated on the PRC Commodity Line.
Multiple PRC documents will be created if multiple IN’s reference the same Award document, and the IN Documents contain different disbursement information. If multiple PRC Documents are generated, each PRC document will be displayed as a separate row on the Matching Status Award Lines table.
If there is no IN Document information to be retrieved for a selected Award Commodity Line, the PRC will still be generated and no error will be issued upon selection of the Override link. (If the selected Award line contains an Order/Invoice commodity, an error will be issued when the PRC is validated or submitted).
Note: The Matching Status (MATA) page displays ten Award lines at a time. The override functionality will generate PRC documents for the selected Award line(s) on the active page. For example, a user selects the Create PRC flag on Award lines 1-10 and clicks the Next link to view Award lines 11-20. After checking the Create PRC flag for Award lines 11-20 and clicking the Override link, PRC documents are generated for Award lines 11-20. No PRC documents are generated for Award lines 1-10 because they were not displayed on the page when the Override link was selected.