top of page

Business Central 2022 Wave 1 New Feature: Consolidate Customer and Vendor Balances

Updated: Jul 17, 2022


As an accountant that used to manually reconcile vendor and customer balances of a company with the same information, I understand the pains of the errors you could make when processing this kind of payment and receipt. Previously, you could manage this in Business Central by using Dimensions only.


However, with Business Central 2022 Wave 1 release, you now have another option to consolidate customer and vendor balance.


Business Value: A company that you do business with might be both a customer and a vendor. When that's the case, you can avoid making unnecessary payments or receipts and save on transaction fees by consolidating the customer and vendor balances.


Explore how the consolidate customer and vendor balance feature works in Business Central by following these steps:


1. Search Customers using the search button.

2. Select and Open Customer Card.

Consolidate customer and vendor balances step by step

3. In Navigate menu, select Contact.

Consolidate customer and vendor balances step by step

4. Add Contacts. Once added, in Actions menu, click Functions, Create As, then select Vendor.

Consolidate customer and vendor balances step by step

5. Select a template for a new Vendor then Click OK. A new vendor card will be added.

Consolidate customer and vendor balances step by step

6. Once the purchase transaction is created, the Customer Card page provides the Balance as Vendor field, then the Vendor Card page includes the Balance as Customer field for companies. The transactions are recorded or linked to the same contact company.

Consolidate customer and vendor balances step by step

Net Customer/Vendor Balances Process


This functionality allows to create payment to which Customer and Vendor net balances are linked.


1. Open Payment Journal, Select batches.

2. On Prepare menu, select Net Customer/Vendor Balances.

Consolidate customer and vendor balances step by step

3. Input Document Number and Vendor Number then click OK.

Consolidate customer and vendor balances step by step

4. Payment journal is now created for Vendor and Customer.

Consolidate customer and vendor balances step by step

This feature is just one of the top ten new functionalities we love about the Business Central 2022 Wave 1 release. You can read the other cool new features in our upcoming blogs here:

  1. Auto-accept transactions for intercompany journals.

  2. Check documents and journals in while you work.

  3. Change default company bank on sales and service documents.

  4. Finding documents and entries efficiently in Dynamics 365 Business Central.

  5. Shopify connector.

  6. Support inventory and pick and warehouse pick operations for jobs.

  7. Set default dimensions on locations.

  8. Log in emails using a shared mailbox and Graph API.

  9. Create bank deposits.


See Business Central's latest features in action.


We hope you find this new feature useful and interesting. Would like to see other cool features available in Dynamics 365 Business Central's latest release? Comment below or book your personalized demo here.

bottom of page