Payment terms and early-payment discounts in Business Central

How Business Central handles terms

Payment terms define when an invoice is due and whether an early-payment discount applies. In Business Central, payment discounts are calculated from the payment terms when a document is posted, and the same payment terms are used for purchases. That means the terms on the purchase document drive the discount calculation at posting, not a separate manual calculation after the fact.

AP teams should compare the terms on the vendor record with the terms printed on the supplier invoice before posting. A vendor may change terms mid-year, or a clerk may use an old template. If the terms are wrong at posting, the due date and discount are wrong in Business Central. Correct the terms before posting rather than trying to fix the payment later.

Supplier invoice numbers belong in the External Document No. field when they are carried into an export from Business Central. Use that field to match what the supplier printed on the invoice, not just the internal document number. Re-keyed numbers such as INV-1043 and 1043 are a common source of duplicate payments, because a search on one format misses the other.

Early-payment discounts

Because the discount is calculated from the payment terms when the document is posted, the terms must be right before posting. If a vendor offers a discount for early payment, confirm the discount terms against the supplier invoice and the vendor record. A wrong term at posting can mean no discount is calculated, or a discount is calculated when none was offered.

Payment timing matters more than the discount field. If the discount date falls before the next scheduled payment run, AP must decide whether to pay earlier or forgo the discount. Compare the discount with your own cost of funds; a discount is a financing decision, not an automatic win. If paying early strains cash, the discount may not be worth it.

Review open credits before paying a discounted invoice. An unapplied vendor credit can change the amount you should remit and whether the remaining balance still earns the discount. Ask the vendor for a corrected statement if the credit is not showing. Do not pay the full amount and assume the credit will sort itself out later.

A small worked situation: a vendor invoice is entered with standard terms instead of the discount terms. Business Central calculates the payment discount from the posted terms, so the discount is missed. The clerk pays the full amount, and the supplier has no reason to volunteer the difference. The fix is a pre-posting check of terms on every invoice that carries a discount.

Mistakes to watch for

Duplicates usually come from ordinary workarounds, not fraud. A clerk re-keys INV-1043 as 1043 and both entries reach the payment run. The same supplier is set up twice, so matching by name misses half the activity. A statement is paid as well as the invoices listed on it. A payment run is re-sent after a file rejection, and the second file is not cancelled.

Matching on vendor, amount and date windows catches many duplicates, but it is not enough on its own. Normalize invoice numbers before matching: treat INV-1043 and 1043 as the same supplier reference unless the vendor confirms they are different. Check the vendor record for duplicate supplier setups before adding a new supplier. Use the External Document No. field in Business Central to compare the supplier invoice number with the payment record.

Statement reconciliation is where statements paid as well as invoices show up. Reconcile the statement to open items in Business Central rather than paying the statement total. If the statement includes an invoice already paid, the reconciliation should show it as cleared, not open. A statement that does not reconcile is a reason to pause, not a reason to pay the difference.

Missed credits are a quiet loss. If a duplicate is found, asking suppliers for credits back is the next step, and keep the request with the payment record. Do not net the credit against a future invoice without a clear reference. AP teams that track credits separately from payments are less likely to pay the same balance twice.

Checking past payments

The Aged Accounts Payable report (322) shows open vendor balances by age. Use it to see what is still open, then pair that with a payment history review in Business Central or your ERP. Open balances alone will not reveal a duplicate that was already paid. You need the cleared payments, the vendor, the amount and the date window.

Start with a list of vendors where duplicate setups are suspected. Compare payments in the same amount to the same vendor within a narrow date window. Then normalize invoice numbers: INV-1043 and 1043 should be reviewed together. Use the External Document No. field to tie the payment back to the supplier invoice. If two payments point to the same supplier invoice number, stop and verify before asking for a refund.

Reconcile supplier statements against cleared payments, not just open items. A statement paid as well as the invoices will show a payment that has no matching open invoice. A re-sent payment run will show two payments close together. When you find a duplicate, ask the supplier for a credit back and record the request. Keep the evidence: vendor, amount, date, invoice number and the payment reference.

Review past payments on a schedule, not only when a vendor calls. Small duplicates compound across many vendors. A simple log of confirmed duplicates, credits requested and credits received keeps the work visible. If the vendor issues a credit, apply it to the right vendor record and confirm it clears the duplicate.

Questions