MS Access VBA NetSuite API Integration
Budget: $30 – $250 USD
I need a clean, well-documented VBA routine that connects directly to NetSuite’s API from Access, retrieves fresh order details, and then pushes two kinds of updates back into the platform: new tracking numbers on each fulfilled order line and a separate call to update inventory stored in the Access table to NetSuite .
Here’s the workflow I want in place:
1. Authentication: handle token-based access (REST or SOAP—whichever you can implement reliably in pure VBA without third-party COM add-ins).
2. Pull: download all open sales orders since the last run, capturing internal IDs, SKUs, quantities, and any other fields the tracking step will rely on.
3. Update tracking: for each order that now ships, write the tracking number into the appropriate NetSuite field.
4. Update inventory: post revised on-hand counts so NetSuite reflects what actually remains in stock after shipment.
5. Output: surface a simple Access Table showing what was fetched and what was successfully updated, with basic error logging for any failed calls.
Deliverables
• An unlocked Access workbook containing the full VBA code.
• Clear inline comments plus a short README so I can adjust credentials and endpoints.
• A quick screen-share or recorded demo proving the script can run end-to-end on a sandbox account.
When you apply, point me to past work where you’ve automated NetSuite or other REST/SOAP APIs with VBA—code samples or short summaries are fine.
Here’s the workflow I want in place:
1. Authentication: handle token-based access (REST or SOAP—whichever you can implement reliably in pure VBA without third-party COM add-ins).
2. Pull: download all open sales orders since the last run, capturing internal IDs, SKUs, quantities, and any other fields the tracking step will rely on.
3. Update tracking: for each order that now ships, write the tracking number into the appropriate NetSuite field.
4. Update inventory: post revised on-hand counts so NetSuite reflects what actually remains in stock after shipment.
5. Output: surface a simple Access Table showing what was fetched and what was successfully updated, with basic error logging for any failed calls.
Deliverables
• An unlocked Access workbook containing the full VBA code.
• Clear inline comments plus a short README so I can adjust credentials and endpoints.
• A quick screen-share or recorded demo proving the script can run end-to-end on a sandbox account.
When you apply, point me to past work where you’ve automated NetSuite or other REST/SOAP APIs with VBA—code samples or short summaries are fine.