13.2 Sales Prices, Purchase Prices & Price Lists

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

---

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:

1. Item: Physical inventory and non-inventory goods.
2. Resource: Individual labor, machinery, or consultant capacity billing.
3. Resource Group: Broad labor categories (e.g., SENIOR CONSULTING, JUNIOR TECHNICIAN).
4. 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:

1. It filters all candidate lines that the customer is eligible to receive.
2. Among all qualifying lines meeting the date, currency, variant, UOM, and minimum quantity criteria, the system selects the lowest unit price.
3. 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

1. Press Alt+Q, type Feature Management, and verify that Feature Update: New sales pricing experience is enabled for all users.
2. Press Alt+Q, type Sales & Receivables Setup, and expand the General FastTab.
3. Verify that Price Calculation Method is set to Lowest Price.
4. Repeat in Purchases & Payables Setup to confirm procurement pricing behavior.

Workflow B: Creating a Tiered Customer Price Group Sales Price List

1. Press Alt+Q, type Customer Price Groups, and ensure group DISTRIB exists.
2. Press Alt+Q, type Sales Price Lists, and click New.
3. On the General FastTab, enter Description Wholesale Tiered Pricing 2026.
4. Set Source Type to Customer Price Group, and Source No. to DISTRIB.
5. Leave Currency Code blank for Local Currency, and set Starting Date to 2026-01-01.
6. 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.
7. Change the Status field on the header from Draft to Active.

Workflow C: Setting Up Promotional Campaign Pricing

1. Press Alt+Q, type Sales Price Lists, and click New.
2. Set Source Type to Campaign, and Source No. to SUMMER2026.
3. Set Starting Date to 2026-06-01 and Ending Date to 2026-08-31.
4. Set Allow Line Disc. to No (blocking additional line discounts during the campaign).
5. 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.