13.1 Customers, Customer Groups, Sales Agreements, and Sales Quotations

13.1 Customers, Customer Groups, Sales Agreements, and Sales Quotations

Quick Answer: In Microsoft Dynamics 365 Supply Chain Management (D365 SCM), sales management begins with establishing Customer master records linked to the shared Global Address Book (GAB) party model. Customers inherit financial defaults, credit limits, and ledger integration rules from Customer groups and Accounts Receivable posting profiles. Commercial commitments are managed through Sales agreements—supporting four commitment types (Product quantity, Product value, Product category value, and Value commitment)—and pre-sales interactions are captured via Sales quotations, which support prospect-to-customer conversion, margin alerts, and mandatory win/loss reason tracking.

---

1. Customer Master Creation and Global Address Book Integration

In D365 SCM, customer master records do not exist in isolation within a single legal entity. Instead, they are built upon the Global Address Book (GAB) architecture (DirPartyTable). The GAB stores party records that can represent either an Organization (e.g., a corporate client, distributor, or vendor) or a Person (e.g., an individual consumer or contact person).

+-------------------------------------------------------------------------+
|                    GLOBAL ADDRESS BOOK (DirPartyTable)                  |
|  Party ID: PTY-00892 | Type: Organization | Name: Contoso Retail Corp   |
|  Shared Logistics Addresses, Contact Information, Tax Registrations     |
+--------------------+-------------------------------+--------------------+
                     |                               |
+--------------------v-------------+   +-------------v--------------------+
|   LEGAL ENTITY USMF (CustTable)  |   |   LEGAL ENTITY DEMF (CustTable)  |
|   Customer Account: CUST-US-101  |   |   Customer Account: CUST-DE-402  |
|   Customer Group: Wholesale-US   |   |   Customer Group: Retail-EU      |
|   Posting Profile: GEN-AR        |   |   Posting Profile: EUR-AR        |
+----------------------------------+   +----------------------------------+

Creating Customer Records

When creating a new customer (Accounts receivable > Customers > All customers > New):

1. Party Selection: The system checks if the party already exists in the Global Address Book. If an existing party is selected (for example, a company that is already a vendor in another legal entity), all shared demographic data—such as addresses, tax registration numbers, and phone numbers—is linked automatically without duplication.
2. Customer Account Numbering: Account numbers can be assigned manually or generated automatically via a number sequence configured in Accounts receivable > Setup > Accounts receivable parameters > Number sequences.
3. Legal Entity Specifics: While the party record is shared across all legal entities, the Customer record (CustTable) is specific to the current legal entity. It holds company-specific commercial terms, credit limits, sales tax groups, and default delivery warehouses.

---

2. Customer Groups and Default Operational Parameters

Every customer record must be assigned to a Customer group (Accounts receivable > Setup > Customers > Customer groups). Customer groups are the primary administrative mechanism for establishing standardized financial and operational behaviors across cohorts of customers.

---

3. Accounts Receivable Posting Profiles and Credit Management

Accounts Receivable Posting Profiles

An Accounts Receivable posting profile (Accounts receivable > Setup > Customer posting profiles) directs the financial postings generated by sales order packing slips, sales invoices, credit notes, and customer payments into the General Ledger.

Key posting profile controls include:

• Summary Account: The balance sheet asset account (Accounts Receivable Trade) debited when a sales invoice is posted and credited when customer payment or credit notes are applied.
• Settle Periods: Determines the cash discount period hierarchy.
• Interest Code & Collection Letter Sequence: Controls automated overdue interest calculations and dunning letter tiers for delinquent balances.
• Prepayment Account: The balance sheet liability account used to hold customer advance payments or prepayments before final invoice settlement.

[!NOTE] Posting profiles are resolved using a standard D365 table hierarchy: Table (specific customer account), Group (customer group), or All (all customers). The system selects the most specific configuration rule available.

Credit Limits, Credit Ratings, and Hold Statuses

Protecting enterprise cash flow requires rigorous credit risk controls configured under Accounts receivable > Customers > All customers > Credit and collections FastTab:

Customer Open Balance ($35,000)
  + Delivered Packing Slips Not Invoiced ($12,000)
  + Open Sales Order Lines Unreleased ($8,000)
  ================================================
  Total Credit Exposure = $55,000
  vs. Credit Limit ($50,000) ---> ORDER AUTOMATICALLY BLOCKED

1. Credit Limit Check Types (configured in AR Parameters):
   • None: No automated credit limit verification is performed.
   • Balance: Verifies whether the open customer invoice balance exceeds the credit limit.
   • Balance + Packing slip / delivery note: Evaluates open invoice balances plus goods delivered on packing slips that have not yet been billed.
   • Balance + All: The most comprehensive check. Evaluates open invoice balances, delivered un-invoiced packing slips, and open sales order lines that have not yet been picked or delivered.
2. Credit Rating: An alphanumeric rating string (e.g., AAA, RISK-1) used to classify creditworthiness.
3. Customer Hold Statuses (Invoicing and delivery on hold):
   • No: Customer is active for all transactions.
   • Invoice: Quotations and orders can be created and delivered, but invoices cannot be posted.
   • All: All order creation, picking, packing slip posting, and invoicing are blocked.
   • Payment: Payments cannot be posted for the customer.
   • Requisition: Prevents internal purchase requisitioning for the party.
   • Never: Explicitly exempts the customer from automated credit holds even if balances exceed limits.

---

4. Sales Agreements and Commitment Types

A Sales agreement (Sales and marketing > Sales agreements > Sales agreements) is a formal contractual commitment between an organization and a customer committing to buy specific quantities or monetary values over a designated timeframe in exchange for negotiated pricing or discounts.

The Four Sales Agreement Commitment Types

The MB-330 exam tests your ability to select the correct commitment type based on business requirements:

Agreement Lifecycle and Fulfillment Tracking

• Agreement Statuses: Draft -> Effective (active for release) -> On hold (temporarily blocked) -> Closed.
• Enforcing Commitments:
  • Max is enforced: If checked, the system blocks sales order releases that would cause cumulative order quantities or values to exceed the agreement threshold.
  • Min is enforced: If checked, each individual sales order release line must meet or exceed the specified minimum quantity or amount.
• Release Orders: To draw against an agreement, users navigate to Sales agreement > Action Pane > New > Release order. D365 SCM creates a linked sales order, populates contract pricing, and automatically updates the Fulfillment FastTab (tracking Released, Invoiced, and Remaining quantities).

---

5. Sales Quotations: Lifecycle, Reason Codes, and Conversion

Sales quotations (Sales and marketing > Sales quotations > All quotations) manage pre-sales pricing, availability estimates, and formal bids presented to prospects or established customers.

Quotation Types and Pricing Controls

• Quotation Type:
  • Sales quotation: Standard commercial quote for goods or services.
  • Project quotation: Used within Project Management and Accounting for milestone-based or time-and-materials project bids.
• Account Types: Quotations can be issued to an existing Customer or an unconfirmed Prospect. Using prospects keeps the customer master clean until a transaction is won.
• Margin Alerts: When line items are entered, D365 SCM evaluates cost vs. price. If the expected contribution margin drops below corporate thresholds, visual margin alerts flag the line for supervisory review.

Quotation Status Lifecycle and Reason Codes

  [Created] ----> [Sent] ----+----> [Confirmed] ----> [Converted to Sales Order]
                             |            │
                             |            ▼ (Win Reason Code: E.g., Superior Quality)
                             |            
                             +----> [Lost] ---------> (Loss Reason: Competitor Price)
                             |            
                             +----> [Cancelled] ----> (Cancel Reason: Budget Cut)

1. Created: Initial quote entry; lines and pricing entered.
2. Sent: Quotation document is generated and transmitted to the prospect/customer.
3. Confirmed / Lost / Cancelled: Status transitions require assigning a Reason code (Sales and marketing > Setup > Quotations > Reasons). Reason codes are configured with a Reason type (Won, Lost, or Cancelled) to capture business intelligence regarding competitor wins, pricing sensitivity, and product performance.

Converting Quotations to Sales Orders

When the customer accepts the bid:

1. Click Confirm on the Action Pane.
2. In the confirmation dialog, specify the Reason code (e.g., WIN-PRICE).
3. If the quotation was issued to a Prospect, D365 SCM automatically opens the customer creation wizard, prompting the user to assign a Customer group. The system creates the new customer master record in CustTable using the GAB party details.
4. D365 SCM generates the new Sales Order, copies header and line details, updates the quotation status to Confirmed, and stores the historical quotation version in the quotation journal.

---

6. Implementation Scenarios and Common Exam Traps

[!IMPORTANT] Exam Tip — Prospect to Customer Conversion: On the MB-330 exam, pay close attention to questions involving pre-sales workflows. You do not need to manually recreate customer records or re-enter quotation lines. Confirming a quotation for a Prospect prompts automated creation of the Customer record in CustTable while preserving the linked GAB party ID and carrying over all quotation lines into the new Sales Order.

[!WARNING] Exam Trap — Sales Agreement Pricing vs. Trade Agreements: When a Product quantity commitment agreement line is active, its fixed contract unit price takes precedence over any active sales trade agreements (price discount journals), even if a lower trade agreement price exists. Conversely, Product value commitments and Category value commitments do not establish fixed unit prices; they draw unit pricing directly from standard trade agreements.

[!TIP] Exam Tip — Credit Limit 'Balance + All': Remember that the Balance + All credit limit parameter includes unbilled sales order lines. If an exam scenario describes a customer whose open invoice balance is well under the limit, but whose newly entered order is placed on credit hold, the cause is typically unreleased open sales order lines consuming the remaining credit headroom.