Skip to content

Accounting Integrations

NetSuite: vendor bills from Demurly

For fuel buyers: approved charges become vendor bills in NetSuite, and payments go both ways.

For fuel buyersCompany admins

For fuel buyers, free. Connect NetSuite on Settings > Integrations and each charge you approve becomes a vendor bill from the carrier.

What syncs

  • You approve a charge: a vendor bill for exactly the approved amount, dated the day you approved it, with the carrier's invoice number as Reference No., one expense line, and a memo with the record number, terminal, date, billed time and a link to the record. NetSuite numbers the bill (for example VB1042).
  • You pay in Demurly: a vendor payment applied to that bill, from your payment account.
  • You pay the bill in NetSuite: within about 10 minutes the charge shows as paid outside Demurly ("NetSuite payment 4471", the check number), and the carrier confirms the money arrived.
  • On the record: "In NetSuite as VB1042", then ", paid (check 4471)".

Set it up

  1. In NetSuite, turn on Token-Based Authentication and REST Web Services (Setup > Company > Enable Features > SuiteCloud). Create an integration record and a role with: Lists > Vendors (Full), Transactions > Bills (Full), Pay Bills (Full), Find Transaction (View), Accounts (View), Setup > REST Web Services (Full), Log in using Access Tokens (Full) and SuiteAnalytics Workbook. Make an access token for a user with that role.
  2. Settings > Integrations > NetSuite > Connect: Account ID, Consumer Key, Consumer Secret, Token ID and Token Secret. Saving runs a connection test.
  3. On the NetSuite bills card, map each carrier to its vendor (search by name or vendor ID), or turn on Create vendors.
  4. Expense account (the account number, such as 6150, or internal ID; empty uses the vendor's default expense account) and Payment account (the bank account; empty uses the form's default). Payment terms in days are optional.
  5. Charges approved before you connected: Bill earlier charges (see the QuickBooks article for how it works).

What doesn't sync

  • No invoice PDF on the bill: NetSuite's REST API can't attach files. The bill's memo links to the record, where the PDF is.
  • A bill waiting in a NetSuite approval workflow reads as a draft: a Demurly payment waits until it's approved.
  • Subsidiary, currency, AP account and approval routing come from NetSuite.

Troubleshooting

  • "Waiting for a vendor mapping": map the carrier on the bills card.
  • "NetSuite has no active account numbered …": fix Expense account or Payment account, then Retry.
  • "Choose the expense account for NetSuite bills …": set Expense account, or give the vendor a default expense account in NetSuite.
  • "NetSuite needs the bank account bill payments come from …": set Payment account.
  • "NetSuite is busy or unreachable …; trying again later": Demurly tries again by itself.
  • A login or permission error on Test Connection: check the role's permissions and that the token isn't revoked.

Still stuck? Signed in, use Help & feedback in your account menu, or contact us.

Next: SAP Business One: A/P invoices from Demurly