Power Dynamics
  • Power Dynamics
  • 🍕My name
  • D365 CE
    • Copilot
      • 🥐Add Copilot into Rich Text Control
    • Sales
      • Copilot in D365 Sales
      • Export record to PDF
    • Customer Experience
      • Contact Center (Omnichannel)
        • 🐚Internal Live Chat in MDA
        • 📢Add Chat Widget to Power Pages - Proactive Chat
      • Attachment Control
      • Case Routing: Basic Routing rule set
      • Custom SLA for any Entity
      • Customer Insight
        • Journey - Custom Trigger - Call Power Automate
    • Field Service
  • Power Platform
    • Analytics
    • Dataverse
      • Use case for the feature of Record ownership across Business Unit
      • 💡Workaround: Change the OOB "Exchange Rate" of a record
      • Using a Virtual Entity to store historical log (sample)
      • Disable Empty Address record
      • Using Adaptive card
      • Block Unmanaged Customizations
      • 🪃Recycle Bin on Dataverse (Preview)
    • Model Driven App
      • 💡Run SSRS report on MDA mobile
      • 💡Tip: Create a Security Role with "App Opener" minimum privileges
      • Tag @person to notify in MDA
      • Auto search on the Lookup field
      • Activities with multiple related records
      • Embedded Power BI - Dashboard
      • Embedded Power BI - Form
      • "Custom Help" - Is it help?
      • New modern Command Bar
      • Tip: Hide the button "Add Existing Record" on subgrid
      • Custom Page - Why not?
      • Hiding sensitive column data
    • Canvas App
    • Fabric & Power BI
      • New Text slicer
      • Dataverse link to Microsoft Fabric
      • 💡Leveraging Interactive Warehouse Floor Maps in Power BI
      • Calculation Group for Time Intelligence
    • Power Automate
      • ✅Sequential Approval
      • 📤Create an Appointment by Outlook Graph API
      • Dowload SSRS Report and Send email
      • Power Automate: Add a table in Email
      • 💡Tips: Get "DisplayName" of the Lookup field on Power Automate
      • E-sign: Power Automate & DocuSign
  • D365 Finance & Operation
    • General
      • 🇻🇳D365 FnO - Virtual entities: Use case
    • Finance
      • Consolidating Customer & Vendor Balances
    • Supply Chain
      • Landed Cost Series
        • Landed Cost- Essential Configuration
        • Landed Cost Scenarios 1
Powered by GitBook
On this page
  • Configure: Journal name & Bridging account
  • Configure: Netting agreement
  • Doing...

Was this helpful?

  1. D365 Finance & Operation
  2. Finance

Consolidating Customer & Vendor Balances

#NettingCustomerVendor, #D365Finance, #D365FO

PreviousFinanceNextSupply Chain

Last updated 1 year ago

Was this helpful?

Checking the new functionality of D365 Finance (D365FO) -

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).

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.

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.

The subgrid will show all the pairs of customer accounts and vendor accounts that are available for netting.

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

Thank you & Hopping well. [NTD]yns.asia ... Thank you.

link.
☕
❤️
invite me a cup.
Net Customer and Vendor Balances.
Enable the netting feature
Journal Name
Netting Agreement
Customer and Vendor Balance: NTD Asia Group
Run Customer and vendor balance netting
Minial Customer Balance and Vendor Balance
Create Netting
Create Netting
Posted Netting History
The Balance after netting