ERP & financeAutomated detention and demurrage recovery for Oracle NetSuite
Audit D&D vendor bills in NetSuite before they are approved for payment
- Sync
- Every 60 minutes
- Authentication
- NetSuite token-based authentication on a dedicated integration role
- Data exchanged
- Vendor bills · Custom fields · Audit status · Vendor credits
How it connects
Oracle NetSuite is a cloud ERP widely used by mid-sized importers, distributors and consumer brands for accounting, purchasing and inventory. Ocean carrier, forwarder and terminal invoices typically enter NetSuite as vendor bills.
ATAHSKIA reads vendor bills and expense lines coded to your D&D, per diem and storage accounts through NetSuite's web services, matches them to containers and B/Ls, and runs the 20 element check of 46 CFR § 541.6 plus the 30-day issuance rule of § 541.7. With write-back enabled, failing bills get a custom field value or approval status your team defines, and the audit packet is attached to the bill.
For mid-sized importers without a dedicated D&D desk, this is often the first time anyone checks a demurrage line before it is paid. The bill stays in NetSuite, AP keeps control, and the dispute runs on the § 541.8 clock.
Data flows
Vendor bills
Reads
Vendor, bill date, reference number, memo and expense lines on D&D accounts.
Custom fields
Reads
Container and B/L references where your team records them on the bill or line.
Audit status
Writes
Optional: custom field or approval status set on audited bills, plus the packet as a file attachment.
Vendor credits
Reads
Credits from carriers matched back to disputed bills.
Field mapping
| ATAHSKIA | Oracle NetSuite | Note |
|---|---|---|
| Billing party | Vendor record on the bill | |
| Invoice number | Reference number on the vendor bill | |
| Invoice date | Bill date | |
| Charge amount | Expense line amount on the D&D account | |
| Container number | Line memo or custom column field | |
| Bill of lading number | Memo or custom body field | |
| Dispute hold | Approval status or custom field | Defined with your NetSuite administrator. |
| Recovered amount | Vendor credit applied to the bill |
Setup
Create an integration record
Your NetSuite administrator creates an integration record and an integration role limited to vendor bills, vendor credits and the fields you choose.
Issue tokens
Generate token-based authentication credentials for that role and enter them on the Integrations page.
Map accounts and fields
Choose the expense accounts used for D&D and the fields that carry container and B/L numbers.
Decide on write-back
Pick whether failing bills get a custom field value, a pending approval status, an attachment, or nothing at all.
Backfill 12 months
Historic bills load for the retrospective audit, with the report ready in 48 hours.
What it recovers
Missing free time dates
A forwarder's pass-through demurrage bill lists no free time start or end date. It is held in approval and the relief request is drafted.
Duplicate charges across vendors
The same container's storage appears on a terminal bill and a forwarder bill. The overlap is flagged before both are paid.
Recovery reporting for finance
Vendor credits are tied to the original bill, so the CFO sees billed, disputed and recovered D&D by carrier and month.
Oracle NetSuite integration FAQ
Do we need to add custom fields?
Only if you want container and B/L numbers on the bill and they are not there today. Many teams already record them in the memo.
Can the role be restricted?
Yes. We recommend a dedicated integration role limited to the records the audit needs.
Is this an Oracle partner integration?
No partnership is claimed. ATAHSKIA uses the web services NetSuite makes available to its customers.
Related connectors
Don't let your 30-day dispute window expire.
Send your recent D&D invoices for a free audit. We report what is recoverable within 48 hours.