ERP & APOracle NetSuite and Trace Global
Read utility vendor bills and payments from NetSuite through SuiteTalk REST and create audited vendor bills for approval.
- Vendor
- Oracle
- Method
- SuiteTalk REST web services and SuiteQL queries, with token-based authentication
- Direction
- Bidirectional
- Typical setup
- 3 to 7 days
Mid-market multi-site operators often run NetSuite with utility bills entered as vendor bills, one per account, coded to a location or department. Trace Global reads those records so the audit compares what the utility billed with what you entered and paid.
We connect through SuiteTalk REST web services using token-based authentication tied to a dedicated integration role. SuiteQL lets us pull vendor bills, bill payments and locations in a few queries instead of exporting saved searches by hand.
If you choose, Trace Global creates vendor bills from audited statements with subsidiary, location, account and amount filled in, and attaches the bill PDF.
How the data feeds the audit
- Detect bills paid twice under different reference numbers.
- Measure late payment fees and deposits charged after missed due dates.
- Find utility accounts still billing to locations marked inactive.
- Track utility refunds and credits through to the vendor record.
Setup
- 1Enable token-based authentication and REST web services in NetSuite.
- 2Create an integration record and a Trace Global role with read access to vendor bills and payments.
- 3Generate a token for that role and share it through the credential vault.
- 4List the utility vendors and subsidiaries in scope.
- 5Review the first reconciliation of NetSuite bills to captured statements.
Data exchanged
| Object | Detail |
|---|---|
| Vendor bills | Transaction ID, vendor, reference number, date, due date, amount and approval status. |
| Expense lines | Account, department, class and location for each bill line. |
| Vendor payments | Payment dates and amounts applied to each utility bill. |
| Locations and subsidiaries | Site records used to map utility accounts to your entity structure. |
| Audited vendor bills (outbound) | New vendor bills created in pending approval status with the source PDF attached. |
Oracle NetSuite questions
No. An administrator can enable the features and create the role in under an hour with our setup guide.
Yes. Some customers start with a scheduled saved search export and move to the API later.
No. Bills are created in pending approval status and follow your existing workflow.
Related connectors
Find out what your utilities owe you.
Connect bills for up to 50 meters. Get the findings report in about three weeks. Pay nothing unless money comes back.
- from bill access to first findings report
- 21 daysfrom bill access to first findings report
- of filed claims accepted by the utility in full or in part
- 94%of filed claims accepted by the utility in full or in part