Payment terms and early-payment discounts in NetSuite

How NetSuite handles terms

Payment terms are the rules that decide when a vendor bill is due and whether a discount is available for paying early. In NetSuite, term records carry % Discount and Days Till Discount Expires (Day Discount Expires on date-driven terms), and the discount applies to vendor bills. The term is not a memo on the vendor record; it drives what AP sees when the bill is entered and paid. If the term record is wrong, every bill that uses it inherits the error.

Review the term record before the bill is entered, not after approval. A vendor may have standard terms, but a specific bill can carry different terms. Confirm which term applies to the bill, then check that the % Discount and the discount-expiry field match the supplier's invoice or contract. On a date-driven term, the field is Day Discount Expires rather than Days Till Discount Expires. That distinction matters when a payment run crosses a month end or when a bill is entered late.

Use the standard payables reports: 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 when you need a narrower view. Compare the term on the bill with the payment date to see whether a discount was available and taken.

Early-payment discounts

An early-payment discount is a reduction in the vendor bill amount for paying inside the discount window. In NetSuite, the discount applies to vendor bills, and the term record carries % Discount and Days Till Discount Expires (Day Discount Expires on date-driven terms). The discount is not automatic just because the term exists; AP has to schedule the payment so it lands inside the window.

Worked situation: a vendor bill carries a term with a % Discount and Days Till Discount Expires. The bill is approved, but payment is scheduled after the discount window. The discount is no longer available. If the term is date-driven, check Day Discount Expires on the bill instead of counting days from the invoice date.

Discount decisions are financing decisions. Compare the discount rate with your own cost of funds before changing a payment run. A discount that looks attractive on the invoice may not be worth pulling cash forward if your cost of funds is higher. Keep the comparison general and document the reason for taking or skipping the discount.

When a discount is missed, a practical follow-up is asking suppliers for credits back if the payment was late because of an internal delay or a terms setup error. Put the request in writing and attach the bill, payment record and term record. If the supplier agrees, apply the credit to the next bill or request a refund. Do not net it against an unrelated bill without the supplier's agreement.

Mistakes to watch for

Duplicate payments rarely arrive as a clean second copy of the same invoice. They come from re-keyed invoice numbers such as INV-1043 and 1043, the same supplier set up twice, statements paid as well as invoices, and re-sent payment runs. Each pattern leaves a different trail, so use more than one check.

For re-keyed invoice numbers, use matching on vendor, amount and date windows rather than the invoice number alone. A bill entered as INV-1043 and another entered as 1043 can pass a simple duplicate check that requires an exact invoice-number match. Pull the payment history by bill and compare the vendor, amount and date window. If the two entries are the same invoice, stop the second payment and ask the supplier for a credit back.

When the same supplier set up twice, bills can sit under two vendor records. One record may carry the correct payment terms and the other may not, so the discount field can differ for the same supplier. Run statement reconciliation against both records and look for overlapping bills. Merge or inactivate the duplicate vendor record only after you have moved open bills and checked the payment history.

Statements paid as well as invoices are another common source. A statement is a summary, not a bill. Paying from a statement without matching it to open bills can pay an invoice twice. Reconcile the statement to Open Bills and A/P Payment History by Bill before releasing a payment. Re-sent payment runs also cause duplicates when a run is repeated after a partial failure. Check A/P Payment History by Payment before re-sending a run.

Checking past payments

Start with A/P Payment History by Bill, A/P Payment History by Payment, A/P Register and Open Bills. A/P Aging Summary and Detail help you see what remains open by vendor and age. Saved searches give custom lists of bills for a narrower view. Use the reports together; one can miss a duplicate that another shows.

When you export bill data, the supplier invoice number is Reference No. Sort by vendor and Reference No. to catch variants such as INV-1043 and 1043. Then compare the payment records for the same vendor, amount and date window. If the same invoice appears under two Reference No. values, check whether both were paid. If they were, ask the supplier for a credit back and apply it to the next bill or request a refund.

For early-payment discounts, compare the payment date with the term record. In NetSuite, term records carry % Discount and Days Till Discount Expires (Day Discount Expires on date-driven terms), and the discount applies to vendor bills. A payment after the discount window is a missed discount. A payment inside the window without the discount means the term was not applied to the bill or the payment was applied without it.

Reconcile vendor statements to the payment history, not just the open balance. A statement can show a credit never applied, a duplicate bill that was paid, or a discount the supplier says was taken but your records do not show. Resolve each line before treating the statement as clean. Keep the term record, bill, payment record and supplier confirmation together.

Questions