This section describes the processing logic of the Post Processor service. The Post Processor service retrieves all documents in the ITP – Post Release to ERP Queue in which the Return Code Keyword Type value is set to Processed. The service then processes the documents in batches. For each batch, it takes the following steps:
-
Fetch Check Information from Costpoint
- For each document in the batch, the Vendor ID, Invoice Number, and Invoice Date Keyword Types are read from the document and used to try to locate a check in Costpoint. The Voucher Number and/or Fiscal Year Keyword Types (if available) are also used to help narrow the query.
- If exactly one check is found, then the fetch was successful, and the check information is recorded for that document.
-
Fetch AP Status from Costpoint
- For each document in the batch, the Vendor ID, Invoice Number, and Invoice Date Keyword Types are used to fetch the AP Status value from Costpoint.
- If the VP Tracking ID Keyword Type is not <blank> on the document, then it means this is an invoice that was submitted through VPConnect (Vendor Portal). The AP Status value from Costpoint is then used to update the AP_STATUS column in the VP_INVOICE_HDR table. This shows outside vendors the status of their payment through the AP Status field on the VPConnect interface.
-
Update Keyword Type Values in
OnBase