# Consolidating Customer & Vendor Balances Checking the new functionality of D365 Finance (D365FO) -[ **Net Customer and Vendor Balances.**](https://learn.microsoft.com/en-us/dynamics365/finance/cash-bank-management/net-customer-and-vendor-balances) {% hint style="info" %} Currently, this feature is a preview feature in **D365 Finance** **version *****10.0.38*** and is available only in the ***Sandbox*** environment (as of today 06-Jan-2024). {% endhint %} Please make sure the feature has been enabled

When your organization engages with a company that serves **both** as a **Customer** and a **Vendor**, there's a remarkable opportunity to streamline financial transactions and optimize savings. By **consolidating** the **balances** between **your organization** and **the company**, you can eliminate unnecessary payments or receipts, effectively minimizing transaction fees. \ This approach creates a win-win scenario, enhancing financial management efficiency while reducing costs significantly. The **Net Customer and Vendor Balance** functionality serves as the solution to achieve this objective seamlessly. ## Configure: Journal name & Bridging account The bridging account is for netting purposes. ***Path: GL > Journal Setup > Journal Name***

## Configure: Netting agreement The purpose of the Netting Agreement is to enable the management of paired customer and vendor accounts for netting within a specified and effective timeframe. ***Path: Account Payable > Payments > Netting > Netting agreement***

* Journal name (1): select the Customer and Vendor netting journal name. * Account (2): select a bridging account that is used for netting balance purposes. * Parties (3): configure the mapping Customer Account and Vendor Account within the effective timeframe. This configuration will be used in the Netting functionality. ## Doing... In our organization, have a company named **NTD Asia Group** that serves as **both** a **Customer** and a **Vendor** within our systems. The current Customer Balance and Vendor Balance: * Customer: **100003350** - NTD Asia Group - Balance: **110,000,000 VND.** * Vendor : **202439** - NTD Asia Group - Balance: **30,000,000 VND.**

Customer and Vendor Balance: NTD Asia Group

I will run the **Customer and vendor balance netting** to net off the balances between our customers and vendors. ***Path: Account Payable > Payments > Netting >** Then click the menu **Customer and vendor balance netting** ==>* This functionality will be run automatically.

The system will automatically calculate the minimal amount between the Customer invoice balance and the Vendor invoice balance as the netting amount.

Minial Customer Balance and Vendor Balance

{% hint style="info" %} The subgrid will show all the pairs of customer accounts and vendor accounts that are available for netting. {% endhint %} After that, we need to select a paired record, and then select **Create Netting**.

In the Netting journal, we need to **Mark Select** the Open Customer Invoice and Open Vendor Invoice first. Then, we must input the **Netting Date** and click **Post** as the final step.

Check the posted netting

Finally, we will check the Customer and Vendor balance after netting. The balances after netting: * Customer: **100003350** - NTD Asia Group - Balance: **80,000,000 VND** * Vendor : **202439** - NTD Asia Group - Balance: **0 VND**

For more details at the [link.](https://learn.microsoft.com/en-us/dynamics365/finance/cash-bank-management/net-customer-and-vendor-balances) Thank you & Hopping well.\ \&#xNAN;**\[NTD]yns.asia**\ ...[invite me a cup.](https://ko-fi.com/ntdyns/?ref=qr\&v=2) :coffee: Thank you. :heart: --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://dyns.ntd.asia/power-dynamics/d365-finance-and-operation/finance/consolidating-customer-and-vendor-balances.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.