Study guide
13.2 Sales Prices, Purchase Prices & Price Lists
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.2 Sales Prices, Purchase Prices & Price Lists
Key Takeaways Explain This Topic AI
Dynamics 365 Business Central features a modern price calculation engine (Tables 7000/7001) that unifies sales prices, purchase prices, and line discounts into a structured document model.
Price Lists operate under a three-state lifecycle: Draft (editable, non-operational), Active (operational and locked from casual edits), and Inactive (archived).
Price List Headers establish commercial scope using Source Types: All Customers, Customer, Customer Price Group, and Campaign on sales; All Vendors and Vendor on purchases.
Price List Lines define prices across multiple product asset types (Item, Resource, Resource Group, G/L Account) with volume-tiered Minimum Quantities.
The Best Price calculation algorithm resolves candidate prices by evaluating validity dates, currency matches, quantity thresholds, and assigning the lowest unit price to the customer.
Last updated: September 2026
13.2 Sales Prices, Purchase Prices & Price Lists
Quick Summary: Dynamics 365 Business Central utilizes a unified Price Calculation Experience that consolidates sales prices, purchase prices, and line discounts into Sales Price Lists (Page 7000) and Purchase Price Lists (Page 7001). Governed by a three-phase lifecycle ( Draft , Active , Inactive ), price lists define prices and discounts across four product asset types: Items , Resources , Resource Groups , and G/L Accounts . When transactions are entered, the Best Price Calculation Engine evaluates dates, currencies, customer price groups, and quantity tiers to automatically deliver the most favorable price to the document line.
Evolution of Business Central Pricing: Legacy vs. Modern Architecture
Historically, Dynamics NAV and early Business Central versions managed pricing through separate, isolated tables:
Legacy Pricing Tables: Table 7002 Sales Price , Table 7004 Sales Line Discount , Table 7012 Purchase Price , Table 7014 Purchase Line Discount .
Limitations: Record-per-line maintenance with no header-level metadata, no approval or draft state, inability to manage prices and discounts in a unified view, and difficult developer extensibility. Modern Pricing Architecture:
- Feature Management -> "Feature Update: New sales pricing experience"
- ├── Page 7000: Sales Price Lists (Table 7000 Price List Header / Table 7001 Price List Line)
- └── Page 7001: Purchase Price Lists (Table 7000 Price List Header / Table 7001 Price List Line)
The modern pricing experience replaces these legacy tables with a standardized document pattern. In Sales & Receivables Setup (Page 459) and Purchases & Payables Setup (Page 460), the Price Calculation Method field determines the active calculation engine (defaulting to Lowest Price , with support for custom AL extensions via the Price Calculation interface).
The Price List Lifecycle
To ensure pricing integrity, every Price List Header enforces strict operational status controls:
Draft: The price list is under development. Pricing lines can be inserted, edited, imported via Excel, or deleted. The pricing calculation engine completely ignores draft price lists.
Active: The price list is verified and operational. Business Central includes these lines in real-time document price resolution. To prevent accidental mid-day price changes, lines cannot be modified while Active; the status must first be reverted to Draft.
Inactive: The price list is expired, cancelled, or archived. It is excluded from price lookup calculations.
Price List Headers: Scopes, Assignments & Control Flags
The Price List Header (Table 7000) specifies the commercial parameters and qualifying boundaries for a group of prices: UI Navigation Path:
- Tell Me (Alt+Q) -> Sales Price Lists (Page 7000) -> New
- Tell Me (Alt+Q) -> Purchase Price Lists (Page 7001) -> New
- Key Price List Header Attributes
Header Attribute Supported Values Operational Role & Business Rules
Source Group Customer , Vendor Establishes whether the document is a sales or purchasing price list.
Source Type (Assign-to Type) Sales: All Customers , Customer , Customer Price Group , Campaign ; Purchase: All Vendors , Vendor Dictates which entities qualify for the price list. All Customers establishes a global baseline; Customer Price Group groups accounts sharing commercial agreements.
Source No. (Assign-to No.) Code (links to Customer, Vendor, Price Group, or Campaign) Identifies the specific entity or group code. Locked to blank when Source Type is All Customers or All Vendors .
Currency Code Code (linked to Currency table) or Blank Blank represents Local Currency ( LCY ). If a foreign currency is specified (e.g., EUR ), the price list applies only to transactions in that specific currency.
Starting / Ending Date Date Range Establishes the exact promotional or contractual validity period evaluated against the document line's date.
Allow Line Disc. Boolean ( Yes / No ) Controls whether sales or purchase line discounts can be combined with the prices in this price list. If No , line discounts are suppressed.
Allow Invoice Disc. Boolean ( Yes / No ) Controls whether lines using this price list contribute toward invoice discount subtotal calculations.
Price List Lines: Product Asset Types & Quantity Tiers
The lines of a Price List (Table 7001 Price List Line ) define the specific commercial terms for individual products.
Supported Product Asset Types
Unlike legacy pricing which focused heavily on inventory items, modern price list lines support four distinct Asset Types :
Item: Physical inventory and non-inventory goods.
Resource: Individual labor, machinery, or consultant capacity billing.
Resource Group: Broad labor categories (e.g., SENIOR CONSULTING , JUNIOR TECHNICIAN ).
G/L Account: Direct financial charges, pass-through services, or disposal fees.
Line Qualification & Value Fields
Asset No.: The specific item, resource, or G/L account code.
Variant Code: Defines variant-specific pricing (e.g., color, packaging). Leaving this field blank applies the price to all variants.
Unit of Measure Code: Specifies unit-specific pricing (e.g., PCS vs. BOX vs. PALLET ).
Minimum Quantity: Establishes volume-tiered pricing. For example:
- Min Qty 1 = Unit Price $100.00
- Min Qty 10 = Unit Price $90.00
- Min Qty 50 = Unit Price $75.00
Unit Price / Direct Unit Cost: The selling price or vendor cost per unit.
Cost Factor / Markup %: Enables dynamic cost-plus pricing calculations.
Price Type: Lines can define Price , Discount , or Both within the same price list.
The Best Price Determination Algorithm & Priority Hierarchy
When an order processor enters an item on a sales order line, Business Central executes the Best Price Calculation Engine to identify and apply the correct price. Best Price Calculation Engine Flow:
- Step 1: Filter Active Price Lists (Status = Active, Starting Date <= Doc Date <= Ending Date)
- │
- ▼
- Step 2: Filter by Entity (Document Customer No. OR Customer Price Group OR All Customers)
- │
- ▼
- Step 3: Filter by Currency (Exact Document Currency match takes priority over LCY)
- │
- ▼
- Step 4: Filter by Product & Variant (Exact Variant Code match beats blank Variant)
- │
- ▼
- Step 5: Filter by Quantity Tier (Document Line Qty >= Price List Line Minimum Quantity)
- │
- ▼
- Step 6: Resolve Best Price -> Select the LOWEST Unit Price among all qualifying lines
- The Lowest Price Rule & Specificity
Under the default Lowest Price calculation method, Business Central does not simply take the most specific customer price if a broader promotional price is cheaper. Instead:
It filters all candidate lines that the customer is eligible to receive.
Among all qualifying lines meeting the date, currency, variant, UOM, and minimum quantity criteria, the system selects the lowest unit price .
If an organization requires that a contracted individual customer price strictly override a lower general promotional price, a custom price calculation algorithm can be implemented via AL extensions.
- Step-by-Step UI Configuration Workflows
- Workflow A: Enabling Modern Pricing and Setting the Calculation Method
Press Alt+Q , type Feature Management , and verify that Feature Update: New sales pricing experience is enabled for all users.
Press Alt+Q , type Sales & Receivables Setup , and expand the General FastTab.
Verify that Price Calculation Method is set to Lowest Price .
Repeat in Purchases & Payables Setup to confirm procurement pricing behavior.
Workflow B: Creating a Tiered Customer Price Group Sales Price List
Press Alt+Q , type Customer Price Groups , and ensure group DISTRIB exists.
Press Alt+Q , type Sales Price Lists , and click New .
On the General FastTab, enter Description Wholesale Tiered Pricing 2026 .
Set Source Type to Customer Price Group , and Source No. to DISTRIB .
Leave Currency Code blank for Local Currency, and set Starting Date to 2026-01-01 .
On the Lines FastTab:
Line 1: Asset Type Item , Asset No. 1000 , Min Qty 1 , Unit Price 100.00 .
Line 2: Asset Type Item , Asset No. 1000 , Min Qty 25 , Unit Price 85.00 .
Line 3: Asset Type Item , Asset No. 1000 , Min Qty 100 , Unit Price 70.00 .
Change the Status field on the header from Draft to Active .
Workflow C: Setting Up Promotional Campaign Pricing
Press Alt+Q , type Sales Price Lists , and click New .
Set Source Type to Campaign , and Source No. to SUMMER2026 .
Set Starting Date to 2026-06-01 and Ending Date to 2026-08-31 .
Set Allow Line Disc. to No (blocking additional line discounts during the campaign).
Add promotional items, unit prices, and set Status to Active .
Common Pitfalls & Exam Traps
Pitfall 1: Leaving Price Lists in Draft Status. The single most common implementation error is creating a price list and forgetting to change the Status to Active . Business Central silently ignores Draft price lists on sales and purchase orders.
Pitfall 2: Currency Mismatch Causing Unexpected LCY Conversion. If a customer is invoiced in EUR but the Price List is configured with a blank Currency Code (LCY), Business Central will take the LCY price and convert it using current Currency Exchange Rates, leading to floating foreign prices rather than fixed contractual amounts.
Pitfall 3: Assuming Minimum Quantity Aggregates Across Document Lines. Minimum quantity tiers evaluate per document line , not across the entire order. If an order has two separate lines of 15 units of Item 1000, neither line qualifies for a 25-unit minimum quantity discount tier.
Pitfall 4: Neglecting the Allow Line Disc. Flag. If an enterprise sets up generous special net prices on a price list but forgets to set Allow Line Disc. to No , customers may receive both the special net unit price and an additional customer discount group percentage, severely eroding profit margins.