Results
- About 48 SuiteScripts and 171 SDF custom objects
- Closed the 11 process gaps mapped in the current-state review
The problem
Product, pricing and scope-of-work data was re-entered by hand on every record: pricing calculator, item, BOM, order, work order, SOP. A current-state review found 11 gaps where that caused mismatched BOMs, prices and SOPs.
What I built
- One flow: Blueprint → Variation / Pricing Calculator → Item → BOM → Customer Order → Work Order → SOP. Each step inherits from the one before it.
- About 48 scripts:
- User Events for propagation, price inheritance, BOM-revision signature checks and DocuSign signed-contract hooks.
- Suitelets to create items, BOMs and SOPs.
- RESTlets for seeding and match-or-create.
- Map/Reduce backfills.
- 171 custom objects deployed through SDF in batches, with backups taken before each production change.
- Data migration across sandbox and production, with reports for every backfill.
- An interactive reference app for the business: data-flow diagram, ERD, decision tree and field-source map.