ERP guides
Accounts payable in Oracle NetSuite
What NetSuite checks for you, the reports that show what was paid, and where duplicates and overpayments slip through.
- Duplicate paymentsThe built-in duplicate check, its gaps, and how to find bills already paid twice.
- Duplicate vendorsWhy the same supplier ends up in the vendor list twice, and how merging works.
- Payment terms and discountsHow terms and discounts are held, and the mistakes that lead to overpaying.
NetSuite's duplicate bill check
- The Duplicate Number Warnings accounting preference (Setup > Accounting > Preferences > Accounting Preferences) can be set to No Warnings, Warn (UI only) or Warn and Block. Warn and Block covers vendor bills and vendor credits, among other transactions, and compares a number with other records of the same type. Source 1 (opens in a new tab)
Checked against the vendor's documentation on Nov 6, 2026. Products change; the vendor's current help is the final word.
Reports for reviewing payables
- Standard payables reports include A/P Aging Summary and Detail, A/P Register, A/P Payment History by Bill, A/P Payment History by Payment and Open Bills; saved searches give custom lists of bills. Source 1 (opens in a new tab)
Checked against the vendor's documentation on Nov 6, 2026. Products change; the vendor's current help is the final word.
Merging duplicate vendors
- The Duplicate Detection & Merge feature, enabled under Data Management, finds duplicate customers, vendors, partners and contacts. Source 1 (opens in a new tab)
- A vendor is merged into another from the record's Actions menu. The merge cannot be undone, both vendors must share the same primary subsidiary, and tax agency vendors cannot be merged. Source 2 (opens in a new tab)
Checked against the vendor's documentation on Nov 6, 2026. Products change; the vendor's current help is the final word.
Payment terms and discounts
- Term records carry % Discount and Days Till Discount Expires (Day Discount Expires on date-driven terms), and the discount applies to vendor bills. Source 1 (opens in a new tab)
Checked against the vendor's documentation on Nov 6, 2026. Products change; the vendor's current help is the final word.
In a paid-bills export from NetSuite, the supplier's invoice number is in the Reference No. column. Export paid bills from NetSuite.