# Duplicate invoice checks in NetSuite for freight and logistics companies

NetSuite covers part of duplicate invoice checks on its own. The same consignment can appear on a consignment invoice and again on a monthly statement. If both are entered, the carrier is paid twice.

## Why it matters for freight and logistics companies

- Owner-drivers and subcontract carriers send many small bills a week, so a repeat is easy to miss.
- Fuel, tolls and tyre bills are small and similar. A repeated fuel card line looks like normal use.

## For freight and logistics companies in NetSuite

- Set Duplicate Number Warnings to Warn and Block at Setup > Accounting > Preferences > Accounting Preferences, on the Items/Transactions subtab. Oracle lists vendor bills and vendor credits among the types it affects.
- Carriers send many small invoices. Key each carrier invoice number in Reference No. (up to 45 characters). A repeat for the same vendor can then raise the warning.
- Warn and Block works on the document number only. Reference No. gives a separate warning that a user can override with OK.

## What NetSuite does on its own

When a vendor bill is saved with the same Reference No. as another bill for that vendor, NetSuite may show a warning, and you can click OK to save anyway. The Duplicate Number Warnings preference also has a Warn and Block option that stops the save of a repeated document number on vendor bills and vendor credits.

- The Reference No. warning can be overridden with OK.
- Warn and Block works on the document number, so a re-typed number or a different format will not trigger it.

Reference No. holds up to 45 characters.

What you need and the setup steps: https://www.pulsify.tech/duplicate-invoice-checks-for-netsuite/

## Example

Example Road Freight Pty Ltd bills consignment ERF-5521 on an invoice for $1,240. The carrier's monthly statement lists the same consignment again.

- Consignment ERF-5521, Sydney to Melbourne: $1,130.00 (Invoice entered from email)
- Fuel levy: $110.00 (Included on the invoice)
- Same consignment on monthly statement: $1,240.00 (Same consignment number and amount)

The statement line is ticked off against the invoice already entered by consignment number and amount. It is not entered as a second bill.

## Common mistakes

- Entering bills from the monthly statement when the consignment invoices are already in.
- Not recording the consignment number, so a repeat cannot be matched.

## Step-by-step guides for NetSuite

- How to stop paying a vendor bill twice in NetSuite: https://www.pulsify.tech/how-to/stop-paying-a-bill-twice-in-netsuite/

## What Pulsify adds

Pulsify checks every invoice for a duplicate, including bills keyed straight into NetSuite, and asks before approval. Pulsify connects to NetSuite. We set up the connection for you. More: https://www.pulsify.tech/duplicate-invoice-checker/

## Common questions

### Does NetSuite warn me about a repeated carrier invoice?

Yes. The Duplicate Number Warnings preference has a Warn and Block option that stops the save for vendor bills and vendor credits. The Reference No. field also shows a warning when the same number is used for the same vendor, but a user can click OK to save.

### How do freight companies get duplicate carrier bills?

A carrier sends a consignment invoice and later a monthly statement with the same jobs. If both are entered, one gets paid twice. Match on consignment number, not only invoice number.

### How do I find duplicates already in NetSuite?

Make a saved search on the Vendor Bill transaction, show Vendor, Reference No. and Amount, and sort by vendor then reference. Repeats sit next to each other.

## Sources

- https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_N547300.html
- https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/article_161968486146.html
- https://www.ato.gov.au/businesses-and-organisations/gst-excise-and-indirect-taxes/gst/tax-invoices

Source: https://www.pulsify.tech/duplicate-invoice-checks-in-netsuite-for-freight-companies/ (last checked 2026-10-19)
