Automated Vendor & Employee Bank Sync via NetSuite SuiteScript

Business Applications Specialist (Technical Product Manager) - Doctors of BC | 2025

Problem Statement

Manual bank account entry for vendors and employees into NetSuite was time-consuming, error-prone, and lacked real-time validation. Payment-related data was entered from an external website manually, resulting in:

Frequent entry errors
Delayed updates to records
Sync issues with payment runs
Compliance and audit risks

Solution

Developed custom SuiteScript RESTlet endpoints that:

Create and update Vendor and Employee bank details
Validate input fields (account number, transit & bank number)
Sync data from web tables in real time

Architecture Overview

[Website Table updates]
          |
          v
[Snowflake Daily Sync]  ← (data warehouse)
          |
          v
[Databricks Python Job]  ← (ETL logic & orchestration) 
          |
  Triggers REST API calls (insert/update)
          |
          v
[NetSuite SuiteScript RESTlets]
          |
  Updates Vendor/Employee Records

Tech Stack

SuiteScript 2.1 (RESTlet)
Postman
JSON POST/PUT APIs
External JS form integration
Deployed in NetSuite Sandbox → Production

Value Delivered

Metric	Before	After
Manual entry time	6–8 hrs/week	< 5 min
Error rate	10%+	< 1%
Sync delay	2–3 days	Real-time
Cost of errors	$5K+/quarter	< $500

Impact

✅ Reduced manual effort by 30+ hours/month
✅ Minimized payment re-issues and errors
✅ Built scalable REST pattern for future vendor/employee onboarding

← Back to Home