We are looking for an experienced NetSuite developer to build a custom integration between our Aloha POS system and Oracle NetSuite. The integration will automate the daily transfer of store-level financial data from Aloha to NetSuite as GL Journal Entries.
Project Scope:
Build a custom middleware application that:
• Extracts end-of-day (EOD) data from our centralized Aloha SQL Server database
• Transforms and maps the data to NetSuite GL accounts
• Posts data into NetSuite as store-wise Journal Entries via a custom RESTlet
• Runs automatically on a daily schedule with logging, error handling, and reconciliation
GL Transactions to Post Daily (per store):
1. AR — Cash sales
2. AR — Credit/Debit card sales
3. AR — Online sales
4. Sales by category
5. COGS by category
6. Wastage
7. Variance
Preferred Tech Stack:
• Python (extractor + middleware)
• MS SQL Server (Aloha database)
• NetSuite SuiteScript 2.1 (RESTlet for journal entry creation)
• OAuth 2.0 / Token-Based Authentication
• Hosting: hybrid (on-prem extractor + cloud middleware) — Aloha SQL will move to cloud later
Deliverables:
• Fully working integration deployed in our environment
• Complete source code with full IP ownership transferred to us (pushed to our GitHub/GitLab)
• Technical documentation: architecture diagram, data mapping, API specs, deployment guide, error handling, reconciliation process, admin guide
• Knowledge transfer session
• 60-day post-go-live warranty for bug fixes
Required Experience:
• 3+ years of NetSuite SuiteScript 2.x development (RESTlets, Scheduled Scripts)
• Strong experience with NetSuite Journal Entries, multi-subsidiary / multi-location setups
• Solid Python and MS SQL Server skills
• At least one prior POS-to-ERP integration project (Aloha experience is a strong plus)
• Experience with OAuth 2.0 / TBA authentication
Nice to Have:
• NetSuite SuiteFoundation or SuiteCloud Developer II certification
• Familiarity with Aloha POS database schema
• Familiarity with ZATCA e-invoicing (Saudi Arabia)
What to Include in Your Proposal:
1. Brief overview of your proposed approach and architecture
2. Timeline with milestones
3. Fixed price (preferred) or estimated hours
4. 2 examples of similar past projects (links or short case studies)
5. A short sample of past SuiteScript code (if shareable)
Project Type: Fixed-price, milestone-based
Estimated Duration: 6–10 weeks
Start Date: Immediate
Please apply only if you have direct, hands-on NetSuite integration experience. We will run a small paid trial task with shortlisted candidates before awarding the full project.