Sales line discounts vs invoice discounts in Business Central

Business Central has two distinct discount mechanisms — line discounts and invoice discounts — that look similar at first glance but compute and post differently. Understanding the difference and configuring them coherently is the difference between predictable margin reporting and constant reconciliation surprises.

Line discounts. A line discount is applied to a single sales line. It can come from:

• A manual override on the line (the seller types 10% in the Line Discount % field).
• A sales discount in a price list that intersects customer + item + quantity criteria.
• A customer-specific discount on a price list bound to the customer's group.
• A campaign discount active for the customer.

The discount reduces the line amount before VAT and posting. The system records both the original price and the discounted amount on the posted document; the GL posting reflects the discounted revenue.

Invoice discounts. An invoice discount is applied to the whole document — a percentage off the document total, or a fixed amount across the whole invoice. It comes from:

• Invoice discount table — customer-specific minimum amount tiers ("If invoice over 10,000, give 5% off the whole invoice").
• Manual entry at posting time by the seller.

The invoice discount is calculated after line discounts. It distributes proportionally across all lines, posting to a designated Sales Invoice Discount Account in the GL — separate from regular sales revenue. This separation makes the management view of revenue vs discount transparent.

The interaction. A single sales document can have both:

• Each line's amount = unit price × quantity × (1 − line discount %).
• The sum of line amounts is the Total Excluding VAT before invoice discount.
• Invoice discount applies to that total.
• The final invoice amount reflects both reductions.

The GL posts:

• Revenue at the line discount level (to standard sales accounts).
• The invoice discount portion to the dedicated invoice discount account.

This lets finance see "we discounted X via line, Y via invoice" without conflating them.

Configuration choices.

• Calculate Invoice Discount field on customers — toggles whether invoice discount applies automatically.
• Customer invoice discount table — configurable thresholds and percentages per customer or customer group.
• GL accounts for invoice discount — typically separate from line discount accounts.
• Posting setup — whether discounts post net (reducing revenue) or gross (revenue full, discount as expense).

Most implementations post net — revenue shows after discount.

When to use which.

• Line discount — for product-specific or quantity-based discounts. "20% off Item X for Customer Y" goes on the line. "Volume tier of 100+ units gets 10% off" goes on the line via price-list configuration.

• Invoice discount — for whole-order incentives. "Spend over 10,000, get an additional 5% off the whole order". The customer sees a single line discount on the invoice that doesn't depend on individual items.

Reporting implications.

• Sales by product — line discounts directly affect product-level revenue. A product with heavy line discounts shows lower per-unit margin.
• Discount analysis — separating line vs invoice discount lets finance see which sales tactics drive margin erosion.
• Customer profitability — both discount types reduce the customer's contribution; combined view is the meaningful one.

Common pitfalls.

• Stacking unintended discounts. A customer-specific line discount plus a campaign discount plus an invoice discount can cumulate to give away more than intended. Audit periodically.
• Wrong GL account configuration. Invoice discount posting to the same account as revenue obscures the distinction.
• Manual overrides without policy. Sellers manually entering discounts at posting without managerial discipline erodes margin over time.

Operational discipline. Define the discount policy at customer-group level; use price lists for systematic discounts; reserve manual line discounts for exceptions; use invoice discount tables for whole-order incentives. Review quarterly.