Study guide

7.6 Customer and Vendor Netting

Microsoft Certified: Dynamics 365 Finance Functional Consultant Associate MB-310

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: MB-310 Exam Overview & Financial Architecture

1.1 MB-310 Exam Structure, Skills Measured & Consultant Role 1.2 Dynamics 365 Finance Architecture, Legal Entities & Global Address Book 1.3 Hands-on Lab Strategy & Preparation Framework

2 Chapter 2: Chart of Accounts & Main Accounts

2.1 Designing Chart of Accounts & Main Account Types 2.2 Main Account Categories & Ledger Account Aliases 2.3 Balance Control Accounts & Year-End Opening Account Setup 2.4 Legal Entity Overrides for Main Accounts & Dimensions

3 Chapter 3: Financial Dimensions & Account Structures

3.1 Custom & Entity-Backed Financial Dimensions 3.2 Financial Tags: Limits, Storage & Ledger Settlement Use 3.3 Account Structures, Segment Criteria & Activation 3.4 Advanced Rules & Advanced Rule Structures 3.5 Derived Dimensions & Dimension Default Templates

4 Chapter 4: Ledgers, Calendars & Currencies

4.1 Fiscal Calendars, Period Statuses & Module Access Control 4.2 Posting Layers, Multi-GAAP Reporting & the Ledger Form 4.3 Currency Exchange Types, Rate Providers & Triangulation 4.4 Accounting & Reporting Currencies (Dual-Currency Architecture) 4.5 Foreign Currency Revaluation & Revaluation Posting Profiles

5 Chapter 5: General Ledger Journals & Allocations

5.1 Journal Names & Voucher Number Sequences 5.2 Journal Control & Posting Restriction Rules 5.3 Journal Entry, the One-Voucher Rule, Validation & Posting 5.4 Reversals, Storno Corrections & Excel Integration 5.5 Ledger Allocation Rules & the Four Allocation Methods 5.6 Allocation Processing & Periodic (Recurring) Journals

6 Chapter 6: Intercompany Accounting & Settlements

6.1 Intercompany Accounting Setup & Due-To / Due-From Postings 6.2 Intercompany Journal Processing & Multi-Company Vouchers 6.3 Ledger Settlements Configuration & Processing

7 Chapter 7: Cash and Bank Management

7.1 Bank Groups, Bank Accounts & Ledger Integration 7.2 Payment Formats, Bank FX Revaluation & Shared Payment Setup 7.3 Manual vs. Advanced Bank Reconciliation & Statement Formats 7.4 Matching Rule Sets, Reconciliation Execution & Reversals 7.5 Cash Flow Forecasting Setup & Automation 7.6 Customer and Vendor Netting

8 Chapter 8: Periodic Closing & Financial Consolidations

8.1 Financial Period Close Workspace, Closing Roles & Schedules 8.2 Year-End Close Configuration & General Ledger Balance Carryforward 8.3 Consolidations Online: Legal Entity Setup, COA Mapping & Currency Translation 8.4 Import Consolidations & Intercompany Elimination Rules

9 Chapter 9: Sales Tax & Withholding Tax

9.1 Sales Tax Engine Hierarchy, Authorities & Settlement Periods 9.2 Ledger Posting Groups, Sales Tax Codes & Calculation Methods 9.3 Sales Tax Groups, Item Sales Tax Groups & Tax Exemptions 9.4 Sales Tax Adjustments and Settle and Post Sales Tax 9.5 Withholding Tax & US 1099 Vendor Reporting

10 Chapter 10: Accounts Receivable Setup & Invoicing

10.1 Customer Master, Customer Groups & Shared Customers 10.2 Customer Posting Profiles & Account Code Precedence 10.3 Free Text Invoices, Recurring Invoice Templates & AR Charges 10.4 Sales Order Invoicing, Billing Classifications & Prepayments 10.5 Customer Payment Methods, Payment Processing & Customer Bank Accounts

11 Chapter 11: Credit Management & Collections

11.1 Credit Management Architecture & Customer Credit Groups 11.2 Risk Scoring, Credit Limits, Blocking Rules & Credit Holds 11.3 Aging Definitions, Collections Workspace & Customer Pools 11.4 Collection Letter Sequences & Interest Notes 11.5 Customer Write-Offs, Bad Debt & Write-Off Reversals

12 Chapter 12: Subscription Billing & Revenue Deferrals

12.1 Recurring Contract Billing, Billing Schedules & Milestones 12.2 Deferral Principles, Deferral Defaults & Schedule Calculation Methods 12.3 Recognition Processing, Expense Deferrals & Modifying Schedules 12.4 Multiple Element Revenue Allocation (MEA / ASC 606)

13 Chapter 13: Accounts Payable & Invoice Processing

13.1 Shared Vendors, Global Address Book & Vendor Groups 13.2 Vendor Posting Profiles, AP Parameters & Vendor Bank Accounts 13.3 Invoice Matching Setup (2-Way, 3-Way), Tolerances & Exceptions 13.4 Vendor Invoicing Methods, Journals & Invoice Automation

14 Chapter 14: Vendor Payments & Expense Management

14.1 Methods of Payment & the Vendor Payment Proposal Engine 14.2 Generating Payments, Centralized Payments & Check Lifecycle 14.3 Expense Management Configuration, Categories & Policies 14.4 Expense Reports Processing, Mobile Receipts & Intercompany Expenses

15 Chapter 15: Budgeting & Budget Control

15.1 Budget Models, Budget Codes & Allocation Terms 15.2 Budget Register Entries, Workflows & Budget vs. Actual 15.3 Budget Transfer Rules & Processing Budget Transfers 15.4 Budget Control Configuration, Cycles, Rules & Budget Groups 15.5 Budget Funds Available, Over-Budget Permissions & Document Budget Check 15.6 Budget Planning Framework, Organization Hierarchies & Planning Processes 15.7 Budget Plans, Scenarios, Allocations & Generating Register Entries

16 Chapter 16: Fixed Assets Configuration & Transactions

16.1 Fixed Asset Groups, Asset Records & Group/Book Mapping 16.2 Depreciation Profiles: Methods & Conventions 16.3 Fixed Asset Books, Derived Books & Posting Profiles 16.4 Fixed Asset Acquisition Pathways 16.5 Depreciation Proposals, Multi-Company Runs & Fixed Asset Budgets 16.6 Fixed Asset Disposals: Sale, Scrap & Disposal Accounting 16.7 Fixed Asset Splits, Transfers & Reclassification 16.8 Asset Leasing (IFRS 16 / ASC 842)

7.6 Customer and Vendor Netting

Key Takeaways Explain This Topic AI

Netting settles a receivable against a payable when the same trading partner is both a customer and a vendor.

The customer and vendor records must be linked to each other before a netting proposal can be created.

A netting clearing account defined in the netting setup holds the offsetting entries generated by the settlement.

The netting proposal shows the netted amount and the residual balance that still has to be paid or collected.

Last updated: August 2026

7.6 Customer and Vendor Netting

Quick Summary: Customer and vendor netting offsets what a trading partner owes against what is owed to them, settling both subledgers through a clearing account. This section covers the required customer-to-vendor link, the proposal workflow, and the resulting vouchers.

1. Customer and Vendor Netting Architecture & Workflows

Organizations frequently establish bilateral trading relationships where a single business entity acts as both a Customer (purchasing finished goods) and a Vendor (supplying raw materials or specialized services). +---------------------------------------------------------------------------------------------------------+

  • | Customer and Vendor Netting Conceptual Model |
  • +---------------------------------------------------------------------------------------------------------+
  • | COUNTERPARTY: Contoso Industrial Supplies |
  • | - As a Customer (AR Account CUST-501): Owes USMF $25,000.00 (Open AR Invoices) |
  • | - As a Vendor (AP Account VEND-204): USMF owes Contoso $18,000.00 (Open AP Invoices) |
  • | |
  • | TRADITIONAL SETTLEMENT (Inefficient): |
  • | - USMF issues bank wire of $18,000 to Contoso. (Incurs $25 bank fee) |
  • | - Contoso issues bank wire of $25,000 to USMF. (Incurs $25 bank fee + 3 days settlement risk) |
  • | |
  • | D365 BILATERAL NETTING (Optimal Treasury Practice): |
  • | - Netting Amount = Min($25,000, $18,000) = $18,000.00 |
  • | - Netting Execution: Offsets $18,000 AP against $18,000 AR directly in the subledgers. |
  • | - Result: Contoso Vendor Balance = $0.00 | Contoso Customer Balance = $7,000.00 (Remaining AR) |
  • | - Cash Moved Through Bank = $0.00! (Zero fees, zero bank settlement risk!) |
  • +---------------------------------------------------------------------------------------------------------+
  • Step 1: Netting Agreement Setup

To establish netting rules between customer and vendor master accounts:

Navigation: General ledger > Periodic tasks > Customer and vendor netting > Netting agreement (or Cash and bank management > Setup > Customer and vendor netting ). +-----------------------------------------------------------------------------+

  • | Netting Agreement Setup |
  • | Agreement ID: NET-CONTOSO Netting Type: Bilateral Netting |
  • +-----------------------------------------------------------------------------+
  • | - Customer Account: CUST-501 (Contoso Electronics) |
  • | - Vendor Account: VEND-204 (Contoso Components) |
  • | - Netting Journal: NET_JRN (Daily Journal Name) |
  • | - Start Date: 01/01/2026 - End Date: 12/31/2026 |
  • | - Netting Currency: Single currency / Cross-currency allowed |
  • +-----------------------------------------------------------------------------+
  • Step 2: Creating and Generating a Netting Proposal

Navigate to General ledger > Periodic tasks > Customer and vendor netting > Netting .

Click Netting proposal > Create netting proposal .

Select the Netting agreement ( NET-CONTOSO ) and specify the transaction cutoff date.

D365 queries open vendor invoices and customer invoices, matches balances, and calculates the maximum nettable amount.

2. Worked Netting Calculation & Accounting Voucher Entries

Consider an enterprise scenario where USMF trades with Fabricam Corp :

Open Accounts Receivable (Customer CUST-109):

  • Invoice CIV-1001 : $12,000.00
  • Invoice CIV-1002 : $8,000.00
  • Total AR Receivable = $20,000.00

Open Accounts Payable (Vendor VEND-804):

  • Invoice VIV-5001 : $14,000.00
  • Total AP Payable = $14,000.00

Netting Calculation Matrix Netting Amount = min ⁡ ( Total Open AR , Total Open AP ) = min ⁡ ( 20,000.00 , 14,000.00 ) = 14,000.00 USD \text{Netting Amount} = \min(\text{Total Open AR}, \text{Total Open AP}) = \min(20{,}000.00, 14{,}000.00) = 14{,}000.00\text{ USD} Netting Amount = min ( Total Open AR , Total Open AP ) = min ( 20 , 000.00 , 14 , 000.00 ) = 14 , 000.00 USD +---------------------------------------------------------------------------------------------------+

  • | Netting Subledger Settlement Allocation |
  • +---------------------------------------------------------------------------------------------------+
  • | Subledger Document | Original Amount | Settled by Netting | Remaining Open Balance | Status |
  • | ------------------ | --------------- | ------------------ | ---------------------- | ------------ |
  • | AP Invoice VIV-5001| $14,000.00 | $14,000.00 | $0.00 | Closed |
  • | AR Invoice CIV-1001| $12,000.00 | $12,000.00 | $0.00 | Closed |
  • | AR Invoice CIV-1002| $8,000.00 | $2,000.00 | $6,000.00 | Open |
  • +---------------------------------------------------------------------------------------------------+
  • Accounting Voucher Commits

When the netting proposal is approved and posted, Dynamics 365 Finance executes an atomic journal posting:

  • Voucher ID Main Account Account Title Posting Type Debit Credit Subledger Impact
  • NET-00018 210100 Accounts Payable Control Vendor Balance $14,000.00 — Vendor VEND-804 settled
  • NET-00018 120100 Accounts Receivable Control Customer Balance — $14,000.00 Customer CUST-109 settled

Trial Balance Equilibrium: Debit AP Liability ($14,000) = Credit AR Asset ($14,000). Net GL Impact = $0.00.

Subledger Status: Vendor VEND-804 balance is reduced to zero. Customer CUST-109 open balance is reduced from $20,000 to $6,000.

3. Exam Traps & Real-World Best Practices

Warning

Exam Trap: Netting Setup Location and Module Integration Questions on MB-310 often test where Netting is configured and executed. While netting directly affects Accounts Payable and Accounts Receivable subledgers, the core Customer and vendor netting feature is accessed through General ledger > Periodic tasks > Customer and vendor netting or Cash and bank management > Setup > Customer and vendor netting . Do not look for it under Accounts Payable parameters!

Important

Consultant Pro-Tip: Cash Flow Forecast Recalculation Overhead Running full cash flow recalculations during peak business hours in large enterprise databases can cause transaction locking across Sales Orders and Purchase Orders. Always configure Process Automation to execute cash flow recalculations during nightly non-peak batch windows.

4. Configuring Netting Step by Step

Confirm the trading partner exists as both a customer and a vendor.

On the vendor record, open the Miscellaneous details / Netting area and select the corresponding customer account . The link is what makes the partner eligible; without it the netting proposal returns nothing.

Define the netting clearing account in Accounts payable (or netting) setup. This balance sheet clearing account receives both sides of the offset and should net to zero once the settlement posts.

Confirm both subledgers have open transactions in the same currency. Netting works transaction by transaction, so a foreign-currency invoice cannot be netted against a local-currency invoice.

5. The Netting Proposal and Settlement Flow

Run netting from the vendor payment journal or the dedicated netting page:

Create the journal and choose the netting function.

Select the vendor; the proposal lists the open payable transactions and the linked customer's open receivable transactions.

Mark the transactions to offset. The proposal shows the netted amount and the residual that still has to be paid or collected.

Post. Dynamics 365 Finance settles both subledgers and routes both legs through the netting clearing account.

Worked Result

A partner owes $30,000 as a customer and is owed $18,000 as a vendor. Netting $18,000 leaves a $12,000 receivable still to collect:

  • Entry Debit Credit
  • Accounts payable (vendor control) $18,000
  • Netting clearing account $18,000
  • Netting clearing account $18,000
  • Accounts receivable (customer control) $18,000

Both control accounts are relieved by $18,000, the clearing account nets to zero, and no cash moves . The remaining $12,000 receivable is collected normally.

6. Netting vs. Centralised Payments vs. Intercompany

These three are easy to confuse because all three reduce the number of cash movements.

Mechanism Parties involved Cash moves?

Customer/vendor netting One external partner that is both customer and vendor Only the residual

Centralised payments Several of your own legal entities, one paying on behalf of the others Yes, once, from the paying entity

Intercompany accounting Two of your own legal entities trading with each other Internal due-to/due-from, not necessarily cash

If the scenario names an outside company that both buys from you and sells to you, the answer is netting. If it names two of your own subsidiaries, it is intercompany or centralised payments.

Exam trap: Netting settles subledger transactions; it does not write anything off. If the residual is uncollectible, that is a separate customer write-off.

Loading diagram... Customer and Vendor Netting Proposal, Settlement & Voucher Generation