Multi-Company AP Invoice Automation

The Challenge

In a multi-entity manufacturing enterprise, the parent company automatically transmits sales invoices to subsidiary companies via Epicor's native Multi-Company Direct processing, creating corresponding Accounts Payable (AP) invoices in the daughter entities.

However, when the Multi-Company engine pushed these AP invoices across entities, it generated miscellaneous freight, tooling, and surcharges at the Line level. The client's accounting standards, tax audit rules, and ledger setup strictly required these miscellaneous charges to reside at the Header level.

As a result, accounting staff in each subsidiary had to manually open every incoming intercompany AP invoice, inspect each line item, delete the line-level miscellaneous charges, and manually re-enter them as header charges before posting. This process created massive bottlenecks during monthly closes and introduced human rounding errors.

The Solution

I engineered a robust, automated backend solution using Epicor Functions (EFx) scheduled to run seamlessly alongside the multi-company batch pipeline:

• Scheduled Epicor Function (EFx): Developed a reusable server-side Epicor Function configured as a recurring scheduled task. The function executes automatically immediately after the Multi-Company processing queue completes.
• Automated Charge Consolidation Logic: The function queries newly generated unposted AP invoices in daughter companies, iterates through invoice line collections, identifies all line-level miscellaneous charge records, and calculates consolidated totals by charge code.
• Business Object Execution: Using Epicor's native `APInvoiceImpl` business object methods, the function programmatically removes the line charges and invokes `GetNewAPInvMsc` to instantiate new Header-level miscellaneous charges with matching tax classifications.
• Transaction Integrity & Logging: Built full transaction rollback handling and audit logging so the finance team can review execution histories and batch summaries at any time.

The Results

The automated solution completely eliminated manual AP intervention across all subsidiaries:

• Zero Manual Adjustments: Intercompany invoices are converted and ready for approval immediately upon delivery.
• 100% Tax & Audit Compliance: Header miscellaneous charges match statutory accounting requirements across all subsidiary jurisdictions.
• Accelerated Month-End Closes: Removed multiple hours of manual data manipulation during high-volume end-of-period processing.