7.6 Customer and Vendor Netting

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

1. Navigate to General ledger > Periodic tasks > Customer and vendor netting > Netting.
2. Click Netting proposal > Create netting proposal.
3. Select the Netting agreement (NET-CONTOSO) and specify the transaction cutoff date.
4. 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

$\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 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:

• 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

1. Confirm the trading partner exists as both a customer and a vendor.
2. 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.
3. 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.
4. 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:

1. Create the journal and choose the netting function.
2. Select the vendor; the proposal lists the open payable transactions and the linked customer's open receivable transactions.
3. Mark the transactions to offset. The proposal shows the netted amount and the residual that still has to be paid or collected.
4. 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:

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.

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.