Study guide

5.3 Trade Agreements, Price/Discount Journals, and Smart Rounding

Microsoft Dynamics 365 Supply Chain Management Functional Consultant MB-330

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: Product Master and Released Products

1.1 Product Masters, Variants, and Configuration Technologies 1.2 Product Templates, Category Hierarchies, and Product Lifecycle States 1.3 Product Attributes, Attribute Types, and Attribute Groups

2 Chapter 2: Bills of Materials (BOM) and Formulas

2.1 BOM Lines, Line Types, and Component Configurations 2.2 BOM Versions, Activation, Approvals, and Circularity Checks 2.3 BOM Calculations, Cost Group Types, Flushing Principles, and Scrap Handling

3 Chapter 3: Product Prerequisites and Dimension Groups

3.1 Product, Storage, and Tracking Dimension Groups 3.2 Item Model Groups, Inventory Models, and Physical/Financial Posting 3.3 Reservation Hierarchies and Unit Sequence Groups

4 Chapter 4: Additional Product Details and Warehouse Fit

4.1 Bar Codes, GTINs, and Product Unit Conversions 4.2 Default Order Settings and Site-Specific Order Settings 4.3 Product Filter Codes and Physical Warehouse Dimensions

5 Chapter 5: Inventory Costing and Pricing

5.1 Costing Versions, Costing Sheets, and Standard Costing 5.2 Base Item Prices, Price Groups, and Price Tolerances 5.3 Trade Agreements, Price/Discount Journals, and Smart Rounding

6 Chapter 6: Inventory Journals and Core Transactions

6.1 Movement, Adjustment, and Transfer Journals 6.2 Counting Journals, Tag Counting, and Cycle Count Adjustments 6.3 Item Arrival Journals, Output Orders, and BOM Journals

7 Chapter 7: Inventory Operations, Blocking, and Closing

7.1 Transfer Orders, In-Transit Warehouses, and Delivery Schedules 7.2 Inventory Blocking Mechanisms, Batch Disposition Codes, and Inventory Status 7.3 Inventory Closing, Recalculation, Settlement, and ABC Classification

8 Chapter 8: Quality Management and Nonconformance

8.1 Quality Control Setup: Tests, Test Groups, and Item Sampling 8.2 Quality Associations, Automatic Generation, and Quality Orders Processing 8.3 Nonconformances, Corrections, Corrective Operations, and Quarantine Orders

9 Chapter 9: Asset Management: Setup and Maintenance

9.1 Assets, Asset Types, and Functional Locations Setup 9.2 Asset Lifecycle Models, Lifecycle States, and Asset Loans 9.3 Work Orders Configuration, Work Order Settings, and Maintenance Capacity Management 9.4 Maintenance Plans, Maintenance Requests, Work Order Scheduling, and Journal Consumption

10 Chapter 10: Procurement and Sourcing Configuration

10.1 Vendors, Vendor Groups, and Procurement Category Hierarchies 10.2 Purchasing Policies, Spending Limits, Procurement Workflows, and Charge Codes 10.3 Purchase Agreements, Vendor Rebates, and Vendor Collaboration Portal

11 Chapter 11: Purchase Order Lifecycle and Consignment

11.1 Purchase Requisitions, Requests for Quotation (RFQs), and Bidding Processes 11.2 Purchase Orders Creation, Over/Under-Delivery Tolerances, Delivery Schedules, and Product Receipt 11.3 Consignment Inventory Replenishment/Ownership Change and Vendor Return Orders

12 Chapter 12: Landed Cost and Inbound Logistics

12.1 Landed Cost Architecture: Voyages, Shipping Containers, Folios, and Journey Templates 12.2 Cost Type Codes, Auto-Costs, and Allocation Methods 12.3 Tracking Control Center, Goods in Transit Orders, and Over/Under Tolerances

13 Chapter 13: Sales Management and Order Processing

13.1 Customers, Customer Groups, Sales Agreements, and Sales Quotations 13.2 Sales Order Processing, Manual and Automatic Reservation, and Sales Returns 13.3 Order Promising: ATP, CTP, Delivery Schedules, and Product Bundles 13.4 Intercompany Trading Chains, Sales Commissions, and Customer Rebates

14 Chapter 14: Warehouse Setup and Core Infrastructure

14.1 Warehouse Topology: Sites, Warehouses, Locations, Profiles, Formats, and Zones 14.2 Work Policies, Work Breaks, and Packing Dimensions 14.3 Wave Templates, Work Templates, and Location Directives Configuration 14.4 Label Layouts, Document Routing, Wave Label Printing, and GS1 Number Sequences

15 Chapter 15: Warehouse Execution Processes

15.1 Inbound Receiving Processes, Planned Cross-Docking, and Putaway 15.2 Outbound Waves, Wave Processing, Picking (Order, Cluster, Batch), and Manual Packing 15.3 Replenishment Strategies (Wave vs. Min/Max) and Inventory Movements via Warehouse Work 15.4 Cycle Counting Plans, Thresholds, Blind Counting, and Automated Containerization

16 Chapter 16: Transportation Management and Logistics

16.1 Shipping Carriers, Carrier Groups, Carrier Services, and Rate/Route Engines 16.2 Route Plans, Route Guides, Inbound/Outbound Loads, and Dock Appointment Scheduling 16.3 Freight Bills, Freight Invoicing, and Manual/Automatic Freight Reconciliation

17 Chapter 17: Warehouse Management Mobile App

17.1 Mobile App Installation, Display Settings, Connection Profiles, and Warehouse Worker Setup 17.2 Mobile Device Menus, Work-Based and Indirect Menu Items, and Inventory Inquiries 17.3 Step Detours Configuration and GS1 Barcode Scanning Implementation

18 Chapter 18: Master Planning and Planning Optimization

18.1 Master Planning Parameters, Coverage Groups, and Planning Optimization Cloud Service Architecture 18.2 Item Coverage Settings, Positive/Negative Days, Time Fences, and Action Messages 18.3 Running Master Planning, Analyzing Results, Planned Orders Firming, and Supply Schedule 18.4 Safety Stock Journals, Safety Margins, and Copilot in Dynamics 365 Supply Chain Management

5.3 Trade Agreements, Price/Discount Journals, and Smart Rounding

Key Takeaways Explain This Topic AI

Trade agreements establish contractual pricing and discount rules across five relation types: Price, Line discount, Multiline discount, and Total discount for sales and procurement.

Pricing evaluation follows a strict 3x3 matrix of Account code (Table, Group, All) and Item code (Table, Group, All), where Table/Table is the most specific and All/All is universal.

Price/discount agreement journals provide the transactional mechanism to author, validate, mass-index, and post trade agreements into the operational PriceDiscTable repository.

The Find next parameter enables discount chaining and compounding across multiple hierarchy tiers; if disabled, search stops immediately upon the first matching agreement.

Smart rounding rules enforce psychological charm pricing ($X.99, $X.95) by applying mathematical rounding increments and syntax offsets during trade agreement mass updates.

Last updated: September 2026

5.3 Trade Agreements, Price/Discount Journals, and Smart Rounding

Quick Answer: Trade agreements in Microsoft Dynamics 365 Supply Chain Management (D365 SCM) govern contractual customer and vendor pricing, volume price breaks, and multi-tier discounts. Configured via Price/discount agreement journals , trade agreements resolve prices using a strict 3x3 matrix across Account codes ( Table , Group , All ) and Item codes ( Table , Group , All ). The search engine evaluates from most specific ( Table/Table ) to least specific ( All/All ). While prices stop searching upon the first valid match, discounts utilize the Find next parameter to chain and compound multiple discounts across hierarchy levels. Smart rounding rules automate psychological pricing (such as rounding calculated prices to end in .99 or .95 ).

1. Trade Agreement Architecture and Relation Types

Trade agreements override standard base prices and provide flexible discount structures across sales and purchasing operations via five distinct relation types:

  • Navigation Paths
  • Sales Trade Agreements : Sales and marketing > Prices and discounts > Price/discount agreement journals

Procurement Trade Agreements : Procurement and sourcing > Prices and discounts > Price/discount agreement journals

Activate Price/Discount Matrix : Sales and marketing > Setup > Prices and discounts > Activate price/discount

  • Relation Type Direction Functional Purpose Order Application Level
  • Price (sales) Sales Defines base selling price or quantity tiered volume breaks. Order Line Unit Price
  • Price (purch.) Procurement Defines contracted vendor purchase price by quantity break. PO Line Unit Price

Line discount Sales / Purch. Percentage or monetary discount applied to a specific item line. Single Order Line

Multiline discount Sales / Purch. Discount triggered when combined items in a multiline group meet quantity thresholds. Order Line (Group Aggregated)

Total discount Sales / Purch. Percentage discount applied across the entire order when gross order value exceeds a threshold. Order Header Summary

2. The 3x3 Account Code and Item Code Specificity Matrix

The D365 SCM pricing engine evaluates a 3x3 matrix combining Account code and Item code , resolving rules in strict priority order:

Priority Tier Account Code Item Code Specificity Description Common Business Use Case

1 (Highest) Table Table Specific Customer + Specific Item Dedicated contract price for a strategic client.

2 Table Group Specific Customer + Item Group Special client discount on an entire product category.

3 Table All Specific Customer + All Items Master agreement giving a client 5% off everything.

4 Group Table Price Group + Specific Item Promotional wholesale pricing on a high-volume SKU.

5 Group Group Price Group + Item Group Standard wholesale discount on replacement parts.

6 Group All Price Group + All Items Flat distributor pricing across the full catalog.

7 All Table All Customers + Specific Item Public promotional sale price for a new product.

8 All Group All Customers + Item Group Clearance discount on discontinued inventory items.

9 (Lowest) All All All Customers + All Items Universal storewide baseline discount or catalog markup.

Important

Under Sales and marketing > Setup > Prices and discounts > Activate price/discount , consultants must explicitly enable the matrix combinations used. Unchecked combinations are skipped by the search engine, accelerating system performance.

3. Price/Discount Agreement Journals Lifecycle

Trade agreements are authored, validated, and posted through Price/discount agreement journals :

Header Creation : Create a journal selecting a configured Journal name defining default relation types and number sequences.

Line Entry : Specify relation type, Account code/relation, Item code/relation, product dimensions, quantity tier breaks ( From / To Quantity ), currency price or discount percentage, and validity date windows ( From date / To date ).

Mass Revision Tools : The Select tool imports existing lines into the journal; Edit selected lines applies percentage price adjustments (e.g., +4%); Apply smart rounding enforces psychological price endings.

Posting : Commits lines to PriceDiscTable . Posted lines become active and cannot be directly deleted; revisions require posting supersede lines.

4. The "Find Next" Parameter and Discount Compounding

While price searches stop immediately upon locating the first valid match, discount searches can evaluate multiple matching lines based on Find next :

Find next = No (Cleared) : Search stops immediately after the first matching discount. Lower-tier discounts are ignored.

Find next = Yes (Enabled) : Applies the current discount and continues searching down the hierarchy for additional matching discounts.

Compounding vs. Summing Discounts

Configured in Accounts receivable parameters ( Prices > Discount calculation ):

Compound Discounts : Applied successively to the reduced net amount: Net Price = Gross Price × ( 1 − d 1 ) × ( 1 − d 2 ) × … \text{Net Price} = \text{Gross Price} \times (1 - d_1) \times (1 - d_2) \times \dots Net Price = Gross Price × ( 1 − d 1 ​ ) × ( 1 − d 2 ​ ) × …

Sum (Additive) Discounts : Percentages are added together: Net Price = Gross Price × [ 1 − ( d 1 + d 2 + … ) ] \text{Net Price} = \text{Gross Price} \times [1 - (d_1 + d_2 + \dots)] Net Price = Gross Price × [ 1 − ( d 1 ​ + d 2 ​ + … )]

Example : For Gross Price = $200.00 , Discount 1 = 10% (Find next = Yes ), Discount 2 = 5% (Find next = No ). Under compounding, $ 200.00 × 0.90 = $ 180.00 \text{\textdollar}200.00 \times 0.90 = \text{\textdollar}180.00 $ 200.00 × 0.90 = $ 180.00 , then $ 180.00 × 0.95 = $ 171.00 \text{\textdollar}180.00 \times 0.95 = \text{\textdollar}171.00 $ 180.00 × 0.95 = $ 171.00 net unit price.

5. Smart Rounding Rules: Psychological Pricing

Retail and distribution organizations utilize psychological pricing (charm pricing) to set prices ending in .99 or .95 . In D365 SCM, this is automated via Smart rounding ( Sales and marketing > Setup > Prices and discounts > Smart rounding ).

Configured per currency, smart rounding rules define lower/upper limits, a rounding method ( Nearest , Up , Down ), a rounding unit (e.g., 1.00 ), and addition/subtraction syntax (e.g., subtract 0.01 to force .99 endings). Running Apply smart rounding in agreement journals automatically converts adjusted prices like $24.18 into $24.99 .

6. Trade Agreement Evaluation Precedence and Base Price Fallback

When a sales order line is entered, D365 SCM resolves pricing through a structured five-step lifecycle:

Trade Agreement Price Search : Evaluates the 3x3 matrix from Tier 1 ( Table/Table ) through Tier 9 ( All/All ). If an active price line is found, that price becomes the Unit Price.

Base Sales Price Fallback : If no matching trade agreement price exists, the system pulls the Base sales price from the Released Product Sell FastTab.

Line Discount Evaluation : Searches for Line Discount trade agreements using the 3x3 hierarchy, evaluating Find next to compound or terminate discount searches.

Multiline Discount Evaluation : Aggregates all items on the order sharing the same Multiline discount group to evaluate group thresholds.

Total Discount Evaluation : Evaluates the order net total against Total discount agreement tiers, applying order-level percentage reductions before invoicing.

Exam Tips and Common Traps

Tip

Exam Tip — Specificity Precedence: Whenever multiple price agreements match an order line, the most specific combination wins: Table/Table overrides Table/Group , which overrides Group/Group , which overrides All/All .

Important

Exam Tip — Find Next on Prices vs. Discounts: The Find next parameter has no effect on Prices . D365 SCM stops searching the moment it finds the first valid price agreement. Find next operates exclusively on Discounts .

Warning

Exam Trap — Product Dimensions in Trade Agreements: If a trade agreement is posted for a specific color (e.g., Red) but does not apply on orders, verify the Product dimension group . If For sales prices is unchecked on Color, the pricing engine ignores color during evaluation.

Loading diagram... 3x3 Trade Agreement Specificity Matrix and Evaluation Hierarchy