← All work

Education & student travel

Salesforce → NetSuite revenue sync that replaced DBSync

A custom sync that moves customers, jobs, invoices and payments from Salesforce into NetSuite. It handles closed periods safely and logs every record so finance can see it.

  1. Salesforce
  2. Sync Lambda
  3. Credit memo & reissue
  4. NetSuite invoices & payments
Salesforce → NetSuite revenue sync that replaced DBSync
IllustrativeIllustrative: Salesforce revenue landing in NetSuite.
Client
Terra Education ↗
Education & student travel
Stack
Python, AWS Lambda, Salesforce REST, NetSuite REST & RESTlets, SuiteScript 2.1, SDF

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.