Our ERP system prints a pdf containing either remittances, invoices or purchase orders. We use A-PDF to split the bulk file into single PDF files for each item.
v1 Remittance VBScript used only the file name to create and email Remittance Advice to the recipients.
v2 Purchase Order VBScript was a rewrite of v1 but using Purchase Order numbers. Only the PO# was saved in the file name which is used to looked up recipient details directly from the ERP database. It then attached the PO PDF file and customised the email before sending it to the recipient.
v3 - It was intended to extend v2 to process Remittance Advises the same way as Purchase orders by looking up the Remittance number in the database.
v3 - THIS PROJECT.
STEP - 1
To cleanup and extend v2 to Email Remittance and Invoices to customer by looking up details in the database (like v2 purchase orders).
STEP - 2
Convert test and approved v3 vbscript to Python. The ODBC for the ERP System may be an issue with Python. Given timeframe it is prudent to complete VBScript first then migrate to Python and potential issues.
The SQL queries will be written in house for the remittance and invoice items.