Automated Invoice Creation System

I want to replace a patchwork of spreadsheets and email threads with one streamlined process that automatically produces accurate, professional invoices the moment a purchase order is fulfilled. The focus is automating processes, specifically invoice processing, and within that niche I only need help with creating invoices—the sending and payment-tracking stages are handled elsewhere.

Here is the workflow I need you to wire together:

• Pull vendor and customer details, PO numbers, line items and receipt data from our existing Access database.
• Apply my communication rules (naming conventions, reference numbers, tax formatting and due-date logic) to generate a PDF and a native file that can be imported back into Access.
• Save each invoice with the correct file name, attach it to the matching record and flag any missing data before the file is created.

You are free to choose the tech stack—VBA inside Access, a lightweight Python script, or another approach—so long as it plugs into our current Access tables without breaking existing queries. Clean, well-commented code and a brief hand-off call will be part of the acceptance criteria.