13.3 Line Discounts, Invoice Discounts & Thresholds

13.3 Line Discounts, Invoice Discounts & Thresholds

Quick Summary: Dynamics 365 Business Central supports a multi-tier commercial discount architecture. Line Discounts apply to individual document lines based on Customer/Vendor Discount Groups and item volume thresholds. Invoice Discounts apply to the entire document subtotal based on currency-specific order value thresholds configured in Cust. Invoice Discounts (Page 60) and Vend. Invoice Discounts (Page 66). Shared discount schedules are assigned using the Invoice Disc. Code on entity cards, while automated calculation is governed by setup toggles in Sales & Receivables Setup and Purchases & Payables Setup.

---

Sales & Purchase Line Discounts: Mechanics & Groups

Line discounts represent percentage or fixed amount price reductions applied to individual item lines on sales and purchase orders.

UI Navigation Path:
Tell Me (Alt+Q) -> Customer Discount Groups (Page 512 / Table 340)
Tell Me (Alt+Q) -> Sales Price Lists (Page 7000) -> New -> Price Type: Discount

Customer & Vendor Discount Groups

Rather than maintaining separate discount percentages for each individual customer or vendor, Business Central groups commercial partners:

• Customer Discount Groups (Table 340): Assigned on the Customer Card (Invoicing FastTab -> Customer Disc. Group). Examples include RETAIL, DISTRIBUTOR, VIP.
• Vendor Discount Groups: Assigned on the Vendor Card (Invoicing FastTab -> Vendor Disc. Group).
• Item Discount Groups: Items can also be grouped on the Item Card (Costs & Posting FastTab -> Item Disc. Group) to receive uniform discount treatment (e.g., ACCESSORIES, FURNITURE).

Modern Discount Configuration

In the modern price calculation experience, line discounts are defined inside Price Lists by setting the Price Type field:

• Discount: The price list lines contain strictly Line Discount % values without altering base unit prices.
• Price & Discount: A single price list line specifies both the net Unit Price and a qualifying Line Discount %.

Mathematical Line Calculation

$\text{Line Amount} = \text{Quantity} \times \text{Unit Price} \times \left(1 - \frac{\text{Line Discount \%}}{100}\right)$

If an explicit Line Discount Amount is entered, Business Central recalculates the Line Discount % automatically to maintain mathematical alignment.

---

Invoice Discounts: Monetary Thresholds & Service Charges

While line discounts reward volume on specific items, Invoice Discounts reward the customer for the total monetary value of their entire order.

UI Navigation Path:
Customer Card -> Related -> Customer -> Sales -> Invoice Discounts (Page 60 / Table 19)
Vendor Card -> Related -> Vendor -> Purchases -> Invoice Discounts (Page 66 / Table 24)

Multi-Tiered Threshold Configuration

Invoice discounts are defined per currency, allowing organizations to configure progressive discount tiers:

• Minimum Amount: The required order subtotal (excluding tax) to qualify for the tier.
• Discount %: The percentage deducted from the qualifying document subtotal.
• Service Charge: A handling or small-order fee added to the invoice if the subtotal falls below the specified minimum amount.

Shared Discount Schedules: The Invoice Disc. Code

On the Customer Card and Vendor Card (Invoicing FastTab), the Invoice Disc. Code field governs which discount table the entity uses:

• By default, Business Central sets Invoice Disc. Code to the entity's own No. (e.g., 10000).
• In corporate group purchasing or franchise networks, multiple customer cards can be assigned the same Invoice Disc. Code (e.g., CORP-PARENT).
• All subsidiary stores or branch offices then automatically share the exact same invoice discount tiers, eliminating redundant maintenance.

---

Automated Calculation Toggles & G/L Discount Posting

Whether invoice discounts calculate automatically or require manual intervention depends on system-wide configuration toggles.

UI Navigation Path:
Tell Me (Alt+Q) -> Sales & Receivables Setup (Page 459 / Table 311)
Tell Me (Alt+Q) -> Purchases & Payables Setup (Page 460 / Table 312)

Core Setup Parameters

1. Calc. Inv. Discount (Boolean):

   • When set to Yes (enabled), Business Central automatically recalculates the invoice discount whenever sales or purchase lines are created, modified, or deleted, and during document posting.
   • When set to No (disabled), invoice discounts are not calculated automatically. Users must manually click Actions -> Functions -> Calculate Invoice Discount on the document ribbon. If not executed, the discount remains $0.00.

2. Discount Posting Option: Defines whether discounts are posted to dedicated General Ledger discount accounts or netted against revenue/expense:

   • No Discounts: Both line and invoice discounts are netted directly into the primary Sales Revenue or Purchase Expense G/L accounts.
   • Invoice Discounts: Only invoice discounts post to dedicated G/L accounts (Sales Inv. Disc. Account / Purch. Inv. Disc. Account defined in General Posting Setup); line discounts are netted.
   • Line Discounts: Only line discounts post to dedicated G/L accounts (Sales Line Disc. Account / Purch. Line Disc. Account); invoice discounts are netted.
   • All Discounts: Both line discounts and invoice discounts post to separate, discrete G/L accounts, providing complete audit visibility on the Income Statement.

---

Three-Way Discount Sequential Interaction & Pipeline

A critical competency on the MB-800 exam is understanding the exact order in which Business Central calculates and applies multiple overlapping discounts:

Discount Execution Pipeline:

[1. Gross Line Price: Qty x Unit Price]
                 │
                 ▼
[2. Apply Line Discount %] ──► Produces Net Line Amount
                 │
                 ▼
[3. Evaluate "Allow Invoice Disc." Flag on Lines]
                 │ (Only lines with Flag = Yes are included in subtotal)
                 ▼
[4. Sum Eligible Lines & Compare Against Invoice Discount Table]
                 │
                 ▼
[5. Deduct Invoice Discount Amount] ──► Subtotal Excl. Tax
                 │
                 ▼
[6. Calculate Sales Tax / VAT] ──► Total Incl. Tax
                 │
                 ▼
[7. Cash Payment Discount] ──► Applied in Cash Receipt/Payment Journal if paid early

The Allow Invoice Disc. Line Control

Each sales and purchase document line includes an Allow Invoice Disc. boolean flag:

• Inherited from the Item Card (Costs & Posting FastTab -> Allow Invoice Disc.).
• If set to No on a document line, that line's value is excluded from the order subtotal when determining if the minimum threshold is met, and no invoice discount is deducted from that line. This protects low-margin items from being discounted twice.

Cash Payment Discounts (Early Payment Terms)

Payment terms (e.g., 2% 10 Net 30) are decoupled from line and invoice discounts. They represent an early settlement incentive calculated against the final posted invoice amount. If the customer pays within the Pmt. Discount Date, the cash discount is recognized during bank reconciliation and cash receipt journal posting.

---

Step-by-Step UI Configuration Workflows

Workflow A: Configuring Customer Discount Groups and Line Discounts

1. Press Alt+Q, type Customer Discount Groups, click New, and add Code WHOLESALE, Description Wholesale Line Discounts.
2. Open Customer 10000, expand the Invoicing FastTab, and set Customer Disc. Group to WHOLESALE.
3. Press Alt+Q, type Sales Price Lists, and create a new Price List.
4. Set Source Type to Customer Discount Group, Source No. to WHOLESALE, and Price Type to Discount.
5. On the Lines FastTab, add Item 1000, set Minimum Quantity to 10, and Line Discount % to 15.
6. Set the Header Status to Active.

Workflow B: Configuring Multi-Tier Invoice Discounts with Shared Codes

1. Press Alt+Q, type Customers, and open Customer 20000.
2. In the Invoicing FastTab, note or enter CORP01 in the Invoice Disc. Code field.
3. Choose Related -> Customer -> Sales -> Invoice Discounts.
4. Add Tier 1: Currency Code blank, Minimum Amount 1000, Discount % 5.
5. Add Tier 2: Currency Code blank, Minimum Amount 3000, Discount % 10.
6. Open Customer 2010 and Customer 2020, and on their Invoicing FastTabs, set their Invoice Disc. Code to CORP01.

Workflow C: Enabling Automated Calculation and G/L Discount Posting

1. Press Alt+Q, type Sales & Receivables Setup.
2. On the General FastTab, toggle Calc. Inv. Discount to Yes.
3. Set the Discount Posting field to All Discounts.
4. Press Alt+Q, type General Posting Setup, locate the active combinations (e.g., DOMESTIC + RETAIL), and verify that Sales Line Disc. Account and Sales Inv. Disc. Account point to valid Chart of Accounts accounts.

---

Common Pitfalls & Exam Traps

• Pitfall 1: Calc. Inv. Discount Disabled in Setup. If an order subtotal clearly exceeds an invoice discount threshold but the invoice discount shows $0.00, check Calc. Inv. Discount in Sales & Receivables Setup. When disabled, the user must manually trigger the calculation action.
• Pitfall 2: Overlooking the Allow Invoice Disc. Toggle on Lines. High-value machinery or clearance lines configured with Allow Invoice Disc. set to No will not count toward the invoice discount subtotal, often causing orders to miss discount thresholds unexpectedly.
• Pitfall 3: Currency Inconsistencies in Invoice Discount Tables. Invoice discount tables are currency-specific. If an enterprise defines thresholds for blank (LCY) but creates an order in EUR, Business Central will not apply any invoice discount unless a dedicated EUR line exists in the Invoice Discounts table.
• Pitfall 4: Confusing Invoice Disc. Code with Customer Price Group. Customer Price Groups control unit selling prices and price list selection. The Invoice Disc. Code controls the master table used for order subtotal invoice discounts.