Results
- First month: 171 customers and jobs, 109 invoices and 232 payments synced, with no failures
- Production replay matched 81 of 81 invoices
The problem
The off-the-shelf connector left invoices stale, mapped products badly and gave finance no view of failures. Revenue had to land in NetSuite with the right class, department, posting period and AR account.
What I built
- Five flows in dependency order (renamed jobs, new customers and jobs, new invoices, invoice updates, payments). One bad record is set aside without stopping the batch.
- Closed-period safety. If an invoice’s period is locked, the original is never edited. A credit memo and a reissued invoice are created and applied automatically.
- Unmapped products get a placeholder item, so finance can fix every affected invoice by renaming one item.
- Full audit trail. Every run and record is logged in NetSuite, with saved-search dashboards and a button for finance to run a sync on demand.
