Results
- Unit-tested against live NetSuite record values
The problem
Co-packing deals are priced in a NetSuite pricing calculator that is slow and shows nothing until you save. The sales pipeline lives in Salesforce, so the two drifted apart.
What I built
- A pricing web app with a pure TypeScript engine that re-implements the NetSuite math: labor-cost ladder, machine cost per minute, headcount and gross margin. It previews cost, price and margin instantly.
- NetSuite stays the source of truth. Saves go through a RESTlet so NetSuite’s own scripts recalculate.
- NetSuite → Salesforce sync:
- User Events on the pricing calculator, completion and customer records call a Lambda.
- The Lambda upserts Opportunities and marks them Closed Won when a quote completes.
- It creates Accounts without overwriting existing ones.