MS Access VBA NetSuite API Integration -- 2

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 Module: This is already completed in VBA and will be provided.
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.


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.