Study guide

13.3 Line Discounts, Invoice Discounts & Thresholds

Microsoft Dynamics 365 Business Central Functional Consultant MB-800

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: Company Creation & Data Migration

1.1 Creating Companies & Assisted Setup Wizards 1.2 Configuration Packages & RapidStart Worksheets 1.3 Opening Balances & Data Migration Strategies

2 Chapter 2: Security, Profiles & Auditing

2.1 Users, User Setup & Role Center Profiles 2.2 Permission Sets & Security Group Management 2.3 Security Filters, Change Log & Security Auditing

3 Chapter 3: Core System Configuration, Number Series & Copilot

3.1 Company Information, Number Series & Job Queues 3.2 Report Layout Management & Copilot AI Capabilities

4 Chapter 4: Dimensions Architecture & Governance

4.1 Dimension Concepts & Dimension Values 4.2 Global Dimensions vs Shortcut Dimensions 4.3 Default Dimensions, Combinations & Priorities

5 Chapter 5: Workflows & Approvals

5.1 Native Workflow Templates & Approval Hierarchy 5.2 Workflow User Groups & Notification Configuration

6 Chapter 6: Financial Setup, Periods & Currencies

6.1 General Ledger Setup & Accounting Periods 6.2 Payment Terms, Payment Methods & Deferrals 6.3 Multi-Currency Setup & Exchange Rates

7 Chapter 7: Chart of Accounts, Categories & Allocations

7.1 Chart of Accounts Structure & G/L Account Cards 7.2 Account Categories, Subcategories & Financial Reporting 7.3 General Ledger Allocation Accounts & Sharing

8 Chapter 8: Posting Groups & Posting Setup

8.1 Specific Posting Groups: Customer, Vendor, Bank & Inventory 8.2 General Posting Groups & General Posting Setup Matrix 8.3 Inventory Posting Setup & Alternative Posting Groups

9 Chapter 9: General Journals & Recurring Methods

9.1 Bank Account Cards & Posting Setup 9.2 General Journal Templates, Batches & Number Series 9.3 Recurring General Journals & Allocation Methods

10 Chapter 10: Accounts Payable & Accounts Receivable Setup

10.1 Purchases & Payables Setup & Vendor Master 10.2 Sales & Receivables Setup & Customer Master 10.3 Payment Journals, Cash Receipts & Payment Registration Setup

11 Chapter 11: Fixed Assets Setup & Depreciation Books

11.1 Fixed Asset Setup, Classes & Depreciation Books 11.2 Fixed Asset Cards, Main/Component Assets & Depreciation Methods

12 Chapter 12: Inventory Setup, Costing & Locations

12.1 Inventory Setup, Item Types, Categories & Variants 12.2 Costing Methods (FIFO, LIFO, Average, Standard) & Ledger Architecture 12.3 Locations, Transfer Routes & Stockkeeping Units (SKUs)

13 Chapter 13: Logistics Master Data, Pricing & Discounts

13.1 Shipping Agents, Locations & Vendor Lead Times 13.2 Sales Prices, Purchase Prices & Price Lists 13.3 Line Discounts, Invoice Discounts & Thresholds

14 Chapter 14: User Interface, Views, Inspection & Excel

14.1 Personalization, Profile Customization & Designer 14.2 Searching, Advanced Filters, Saved Views & Page Inspection 14.3 Edit in Excel, OneDrive & Data Analysis Mode

15 Chapter 15: Purchase & Sales Order Execution

15.1 Purchase Orders, Receiving, Over-Receipt & Undo 15.2 Purchase Invoicing, Recurring Lines & Blanket Orders 15.3 Sales Quotes, Availability Checks & Order Conversion 15.4 Sales Shipping, Invoicing, Undo & Blanket Orders

16 Chapter 16: Invoices, Credit Memos & Document Corrections

16.1 Direct Invoices, Credit Memos & Document Reopening 16.2 Correct, Cancel & Corrective Credit Memo Procedures 16.3 Combined Shipments/Receipts & Prepayment Workflows

17 Chapter 17: Cash Management, Bank Reconciliation & Ledger Applications

17.1 Processing Payment Journals & Cash Receipt Registrations 17.2 Applying, Unapplying & Reversing Customer/Vendor Entries 17.3 Bank Account Reconciliation & Statement Matching Rules

18 Chapter 18: Operational Adjustments, Inventory & Asset Accounting

18.1 Exchange Rate Adjustments & Dimension Corrections 18.2 Inventory Adjustments, Transfers & Physical Counting 18.3 Fixed Asset Acquisitions, Depreciation Runs & Disposals

13.3 Line Discounts, Invoice Discounts & Thresholds

Key Takeaways Explain This Topic AI

Line Discounts reduce individual line item prices based on Customer/Vendor Discount Groups and quantity tiers, whereas Invoice Discounts reduce the overall order subtotal based on monetary thresholds.

Customer Discount Groups (Page 512) and Vendor Discount Groups aggregate accounts to receive standardized commercial percentage deductions across product catalogs.

Invoice Discounts (Cust. Invoice Discounts Page 60, Vend. Invoice Discounts Page 66) support currency-specific minimum amounts, discount percentages, and service charge fees.

The Invoice Disc. Code field links multiple customer or vendor accounts to a single shared invoice discount schedule, simplifying corporate group terms.

Commercial discounts interact in a strict sequence: Base Unit Price -> Line Discount -> Invoice Discount -> Sales Tax/VAT -> Cash Payment Discount upon early settlement.

Last updated: September 2026

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 Line Amount = Quantity × Unit Price × ( 1 − Line Discount % 100 ) \text{Line Amount} = \text{Quantity} \times \text{Unit Price} \times \left(1 - \frac{\text{Line Discount \%}}{100}\right) Line Amount = Quantity × Unit Price × ( 1 − 100 Line Discount % ​ )

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:

  • Currency Code Minimum Amount Discount % Service Charge
  • Blank (LCY) $0.00 0% $25.00
  • Blank (LCY) $500.00 3% $0.00
  • Blank (LCY) $1,500.00 5% $0.00
  • Blank (LCY) $5,000.00 8% $0.00
  • EUR €500.00 4% €0.00

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

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.

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

Press Alt+Q , type Customer Discount Groups , click New , and add Code WHOLESALE , Description Wholesale Line Discounts .

Open Customer 10000 , expand the Invoicing FastTab, and set Customer Disc. Group to WHOLESALE .

Press Alt+Q , type Sales Price Lists , and create a new Price List.

Set Source Type to Customer Discount Group , Source No. to WHOLESALE , and Price Type to Discount .

On the Lines FastTab, add Item 1000 , set Minimum Quantity to 10 , and Line Discount % to 15 .

Set the Header Status to Active .

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

Press Alt+Q , type Customers , and open Customer 20000 .

In the Invoicing FastTab, note or enter CORP01 in the Invoice Disc. Code field.

Choose Related -> Customer -> Sales -> Invoice Discounts .

Add Tier 1: Currency Code blank, Minimum Amount 1000 , Discount % 5 .

Add Tier 2: Currency Code blank, Minimum Amount 3000 , Discount % 10 .

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

Press Alt+Q , type Sales & Receivables Setup .

On the General FastTab, toggle Calc. Inv. Discount to Yes .

Set the Discount Posting field to All Discounts .

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.

Loading diagram... Three-Tier Discount Execution Flow