Study guide

10.2 Sales & Receivables Setup & Customer Master

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

10.2 Sales & Receivables Setup & Customer Master

Key Takeaways Explain This Topic AI

Sales & Receivables Setup (Page 459) centralizes commercial policies including Discount Posting options, Credit Warnings, Stockout Warnings, and master document Number Series.

Credit Warnings evaluate whether orders breach a customer's Credit Limit (LCY) or trigger alerts for overdue open balances, providing real-time risk controls during sales document entry.

The Customer Card (Page 21) defines commercial parameters across General, Address, Invoicing, Payments, and Shipping FastTabs, where the Blocked field restricts shipping, invoicing, or all activities.

Ship-to Addresses (Page 300) decouple billing legal entities from multiple physical delivery locations, while Customer Bank Accounts (Page 423) support automated SEPA direct debit collections.

The Receivables subledger architecture routes transactions from Customer (Table 18) to Customer Ledger Entries (Table 21) and Detailed Customer Ledger Entries (Table 379), reconciling to the General Ledger via Customer Posting Groups.

Last updated: September 2026

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:

Credit Warning Option Trigger Condition Operational Impact During Order Entry

No Warning Never performs credit verification. Sales orders and quotes proceed without user notification, regardless of customer balance or payment status.

Credit Limit Evaluates customer Balance (LCY) + outstanding order amounts against Credit Limit (LCY) . Displays a non-blocking notification if the current document value pushes total exposure beyond the customer's approved credit ceiling.

Overdue Balance Evaluates open Cust. Ledger Entries past their Due Date . Displays a notification if the customer has any unpaid, overdue invoice balances, regardless of remaining credit headroom.

Both Warnings Evaluates both Credit Limit and Overdue Balance . Displays an alert if either the credit limit ceiling is breached or the customer carries any past-due open entries.

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

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.

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

Implementation Issue Root Cause System Impact Corrective Action

Orders Blocked Incorrectly Customer Card Blocked field set to All instead of Ship or Invoice . Customer cannot even make payments on open invoices, and sales reps cannot draft preliminary quotes. Adjust Blocked to Ship (to halt fulfillment while allowing billing/payments) or Invoice based on business policy.

Credit Limit Exceeded Without Notice Credit Warnings set to No Warning in Sales & Receivables Setup, or Customer Credit Limit (LCY) is 0. Sales orders are released and shipped to insolvent customers without triggering credit risk reviews. Set Credit Warnings to Both Warnings in Sales & Receivables Setup and configure approved Credit Limit (LCY) on Customer Cards.

COGS Distortion on Sales Returns Exact Cost Reversing Mandatory is unchecked in Sales & Receivables Setup, and a return is posted with estimated costs. Returned inventory enters the warehouse at arbitrary cost, skewing item valuation and gross margin reports. Enable Exact Cost Reversing Mandatory in Sales & Receivables Setup. Use Get Posted Document Lines to Reverse on return orders.

Customer Invoices Sent to Wrong Address New retail branch locations created as duplicate customer cards rather than Ship-to Addresses. Customer balances and credit exposure are fragmented across multiple records, complicating collection and statement management. Maintain a single parent Customer Card for the billing entity and create multiple Ship-to Addresses for separate delivery locations.

Loading diagram... Sales and Receivables Architecture and Subledger Flow