10.2 Sales & Receivables Setup & Customer Master

10.2 Sales & Receivables Setup & Customer Master

Quick Summary: In Microsoft Dynamics 365 Business Central, customer relations, order fulfillment, and accounts receivable are governed by Sales & Receivables Setup (Page 459) and individual Customer Cards (Page 21). Sales & Receivables Setup establishes company-wide controls including Credit Warnings (No Warning, Credit Limit, Overdue Balance, Both Warnings), Stockout Warnings, Discount Posting options, and master Number Series for quotes, orders, shipments, and invoices. Customer cards manage commercial credit ceilings, pricing tiers, payment terms, and Blocked states (Ship, Invoice, All). Complex customer logistics leverage Ship-to Addresses for multi-location deliveries, while automated collections rely on Customer Bank Accounts and SEPA Direct Debit Mandates. The receivables subledger pairs Customer Ledger Entries (Table 21) with immutable Detailed Customer Ledger Entries (Table 379) to maintain auditable financial tracking.

---

Sales & Receivables Setup: Distribution Rules & Governance

The Sales & Receivables Setup card (Page 459 / Table 311 Sales & Receivables Setup) establishes company-wide operational defaults, inventory reservation parameters, credit risk checks, and document number series across all sales workflows.

UI Navigation Path:
Tell Me (Alt+Q) -> Sales & Receivables Setup (opens Page 459)

1. Credit Warnings & Risk Governance

To protect the organization from uncollectible receivables, Business Central includes automated credit evaluation during sales quote, order, and invoice processing. The Credit Warnings field on the General FastTab provides four operational settings:

[!TIP] Credit Warnings in standard Business Central are informative notifications in the web client header; they do not automatically prevent document release unless extended via approval workflows or dedicated credit management extensions.

2. Stockout Warnings & Inventory Reservations

• Stockout Warning: A boolean toggle on the General FastTab. When checked (Yes), Business Central automatically checks inventory availability as order processors key lines into sales quotes, orders, and invoices. If the requested quantity exceeds the projected available balance on the planned shipment date, a real-time notification warns the user and provides visibility into gross requirements, inventory on hand, and incoming purchase receipts.
• Stockout Warning Calculation: Evaluates availability based on Current Inventory - Quantity on Sales Orders + Quantity on Purchase Orders/Production Orders.

3. Discount Posting & Exact Cost Reversing

• Discount Posting: Mirrors the purchasing module with four options: No Discounts, Invoice Discounts, Line Discounts, and All Discounts. When configured for discounts, Business Central posts customer discounts to dedicated contra-revenue accounts in General Posting Setup (Sales Line Disc. Account and Sales Inv. Disc. Account) rather than netting directly against primary sales revenue.
• Exact Cost Reversing Mandatory: When enabled (Yes), sales return orders and sales credit memos cannot be posted unless linked to original posted sales shipment lines using the Applies-to Item Entry field or the Get Posted Document Lines to Reverse action. This guarantees that returned items are brought back into inventory at their original Cost of Goods Sold (COGS), maintaining accurate gross margins.
• Shipment on Invoice: When enabled, posting a sales invoice directly without a prior warehouse shipment automatically creates a Posted Sales Shipment in the background.

4. Number Series Configuration

The Number Series FastTab specifies the sequential numbering rules governing sales documents:

• Customer Nos.: Number series for creating customer master records.
• Quote Nos. / Order Nos. / Invoice Nos. / Credit Memo Nos.: Preliminary numbering for unposted sales documents.
• Posted Shipment Nos.: Number series stamped on warehouse shipments upon posting.
• Posted Invoice Nos. / Posted Credit Memo Nos.: Continuous legal number series stamped on posted commercial invoices and credit memos.
• Posted Return Receipt Nos.: Number series assigned when processing inbound customer returns.

---

The Customer Master Card (Page 21 / Table 18)

Customer accounts are created and configured on the Customer Card (Page 21). When onboarding new customers, organizations use Customer Templates to pre-populate default posting groups, payment terms, delivery methods, and tax definitions based on client profile (e.g., Domestic Commercial, Retail Consumer, EU B2B, Overseas Export).

UI Navigation Path:
Tell Me (Alt+Q) -> Customers -> Action: New (select template) or Edit (opens Page 21)

Customer Card FastTab Structure:

Customer Card (Page 21)
 ├── General FastTab       ──► No., Name, Balance LCY, Credit Limit LCY, Blocked
 ├── Address & Contact     ──► Legal Billing Address, Contact, Phone, E-Mail
 ├── Invoicing FastTab     ──► Gen. Bus. Posting Group, Customer Posting Group, Prices & Discounts
 ├── Payments FastTab      ──► Payment Terms, Payment Method, Application Method, Reminder Terms
 └── Shipping FastTab      ──► Ship-to Code, Location Code, Shipping Advice, Shipment Method

1. General FastTab: Identification & Operational Blocking

• No.: Primary unique identifier assigned from the Customer Nos. series.
• Name & Search Name: Legal trading name and indexed search string.
• Balance (LCY) & Balance Due (LCY): Dynamic FlowFields calculating the total open receivable balance and the portion currently past due.
• Credit Limit (LCY): The monetary ceiling of allowable credit exposure. Setting this field to 0.00 enforces no credit limit unless Credit Warnings are enabled, in which case any order generates a warning.
• Blocked: Enforces strict operational boundaries across commercial workflows:
  • [Blank]: Open for all business activities (quotes, orders, shipments, invoices, cash receipts).
  • Ship: Prohibits releasing sales orders, creating warehouse shipments, or posting shipments. Invoicing existing shipments and posting customer payments remain fully permitted.
  • Invoice: Shipments and payments are permitted, but sales orders and shipments cannot be invoiced.
  • All: Completely blocks all transactions for this customer, preventing order entry, shipping, invoicing, and cash receipt processing.

2. Invoicing FastTab: Financial Mapping & Pricing Architecture

• Gen. Bus. Posting Group: Links the customer to the General Posting Setup matrix, determining which G/L sales revenue, sales line discount, sales invoice discount, and COGS accounts are utilized on transaction lines.
• Customer Posting Group: The critical control link connecting the customer subledger to the G/L Receivables Account (balance sheet asset account). It also specifies payment discount debit/credit accounts, payment tolerance accounts, and rounding accounts.
• Customer Price Group & Customer Disc. Group: Assigns the customer to specific pricing hierarchies and discount schedules defined in the sales price and sales line discount tables.
• Allow Line Disc.: Boolean controlling whether sales line discounts can be calculated for this customer.
• Prices Including VAT: Specifies whether sales prices entered on lines include or exclude Value Added Tax.
• Currency Code: Blank = Local Currency (LCY); populated (e.g., EUR, CAD) = foreign currency default.

3. Payments FastTab: Credit Collection & Dunning Governance

• Payment Terms Code: References Table 3 Payment Terms, establishing net due date formulas (e.g., 1M, 30D, CM), cash discount date formulas (e.g., 10D), and cash discount percentages (e.g., 2%).
• Payment Method Code: Identifies default settlement channel (e.g., DIRECTDEBIT, CHECK, WIRE, CREDITCARD).
• Application Method:
  • Manual (Default): Cash receipts and credit memos must be specifically applied to designated invoices by the cashier using Applies-to Doc. No. or Apply Entries.
  • Apply to Oldest: Any unapplied cash receipt automatically applies to the customer's oldest open debit entry (earliest posting date).
• Reminder Terms Code: References Table 292 Reminder Terms, establishing dunning levels, grace periods, reminder fees, and automated late collection letters.
• Fin. Charge Terms Code: References Table 247 Finance Charge Terms, establishing interest rates, grace periods, and calculation methods for charging interest on overdue invoices.
• Print Statements: Boolean controlling whether monthly account statements are generated for this customer during bulk statement print runs.

4. Shipping FastTab: Fulfillment Controls

• Ship-to Code: Specifies the default physical delivery address when distinct from the legal billing address.
• Location Code: Specifies the default distribution warehouse from which orders are fulfilled.
• Shipping Advice: Controls shipment completion rules:
  • Partial: The customer permits partial shipments across multiple fulfillment runs.
  • Complete: The sales order must be shipped entirely in a single shipment; partial posting is blocked.
• Shipment Method Code & Shipping Agent Code: Defines commercial delivery terms (e.g., FOB, CIF) and courier services (e.g., FEDEX, UPS, DHL).

---

Ship-to Addresses & Customer Bank Accounts

Enterprise customers frequently separate financial billing responsibilities from physical logistics, requiring distinct master records:

1. Ship-to Addresses (Page 300 / Table 222)

When a single corporate customer operates multiple retail stores, regional distribution centers, or job sites, organizations configure Ship-to Addresses.

UI Navigation Path:
Customer Card -> Related -> Customer -> Ship-to Addresses (opens Page 300)

• Each Ship-to Address record defines an independent delivery destination: Code, Name, Address, City, Post Code, Location Code, Shipment Method, and Shipping Agent.
• On a Sales Order, the Sell-to Customer No. and Bill-to Customer No. identify the parent legal entity receiving the invoice, while selecting a Ship-to Code dynamically overrides delivery coordinates and default tax jurisdictions without creating redundant customer master accounts.

2. Customer Bank Accounts (Page 423 / Table 287) & SEPA Direct Debit

To execute automated accounts receivable collections via direct debit, organizations capture customer banking coordinates:

UI Navigation Path:
Customer Card -> Related -> Customer -> Bank Accounts (opens Page 423)

• Captures domestic Transit No., Bank Account No., SWIFT Code (BIC), and IBAN.
• Links to Direct Debit Mandates (Page 1230 / Table 1230 SEPA Direct Debit Mandate):
  • Mandate ID & Date of Signature: Legal authorization identifiers required under European banking regulations.
  • Type of Payment: Recurrent (ongoing collections) vs. One-Off (single collection).
  • Expected Number of Direct Debits & Debits Conducted: Tracks mandate consumption.
  • Closed / Blocked: Mandate validity toggles.
• When processing collections in the Payment Journal, Business Central utilizes these mandates to generate ISO 20022 XML direct debit files (pain.008.001.02).

---

Receivables Subledger Architecture & Financial Ledger Integration

The receivables module utilizes a dual-tier subledger architecture that maintains granular audit records while guaranteeing General Ledger reconciliation:

Receivables Data Architecture:

[Customer Card: Table 18 (Master Data)]
         │
         ├──► [Cust. Ledger Entry: Table 21 (Operational Document Summary)]
         │         - Document Type (Invoice, Payment, Credit Memo, Reminder)
         │         - Document No., Posting Date, Due Date, Pmt. Discount Date
         │         - Amount, Remaining Amount, Open (Yes/No), Closed by Entry No.
         │         │
         │         └──► [Detailed Cust. Ledg. Entry: Table 379 (Granular Balance Adjustments)]
         │                   - Entry Type (Initial Entry, Application, Payment Discount)
         │                   - Realized / Unrealized Gain/Loss, Correction, Rounding
         │
         └──► [General Ledger Entry: Table 17 (Financial Balance Sheet Impact)]
                   - Linked via Customer Posting Group (Receivables Control Account: e.g., 10400)

1. Cust. Ledger Entry (Table 21)

Represents financial transactions at the document level. Key fields include Document Type, Document No., Amount, Remaining Amount, Due Date, Pmt. Discount Date, and Open.

2. Detailed Cust. Ledg. Entry (Table 379)

Business Central appends immutable records to Table 379 for every financial event affecting a Customer Ledger Entry:

• Initial Entry: Created upon posting invoices, payments, or credit memos, establishing the original balance.
• Application: Created when cash receipts or credit memos are applied to invoices, reducing Remaining Amount.
• Payment Discount: Created when cash receipts are applied within the cash discount window, writing off the earned discount and reducing the invoice remaining balance to zero.
• Realized Gain/Loss & Unrealized Gain/Loss: Records foreign exchange differences between sales invoicing and cash collection dates.
• Correction & Rounding: Accommodates unapplying transactions or posting invoice rounding differences.

3. Lifecycle Walkthrough: Invoice with Cash Discount Applied

1. Post Sales Invoice for $5,000 (Terms: 2% 10 Net 30):
   • Cust. Ledger Entry: Doc Type = Invoice, Amount = +$5,000, Remaining Amount = +$5,000, Open = Yes.
   • Detailed Cust. Ledg. Entry: Entry Type = Initial Entry, Amount = +$5,000.
   • G/L Entry: Debit G/L 10400 (Accounts Receivable) $5,000; Credit G/L 40100 (Sales Revenue) $5,000.
2. Receive $4,900 within 10 days taking early payment discount:
   • Cust. Ledger Entry (Payment): Doc Type = Payment, Amount = -$4,900, Remaining Amount = $0.00, Open = No.
   • Cust. Ledger Entry (Invoice): Remaining Amount becomes $0.00, Open = No, Closed by Entry No. populated.
   • Detailed Cust. Ledg. Entries:
     • Entry Type = Initial Entry (Payment CLE), Amount = -$4,900.
     • Entry Type = Application (Payment CLE), Amount = -$4,900.
     • Entry Type = Application (Invoice CLE), Amount = +$4,900.
     • Entry Type = Payment Discount (Invoice CLE), Amount = +$100 (closes remaining invoice balance).
   • G/L Entry: Debit G/L 10100 (Bank Cash) $4,900; Debit G/L 40900 (Sales Discounts Granted) $100; Credit G/L 10400 (Accounts Receivable) $5,000.

---

Common Implementation Pitfalls & Exam Traps