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

Updated: 3 days ago


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.

Source: https://docs.microsoft.com/en-us/dynamics365-release-plan/2022wave1/smb/dynamics365-business-central/consolidate-customer-vendor-balances


 

[RELATED CONTENT: Top 10 Business Central 2022 Wave 1 Features]

 

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

What do you think about this new feature in Business Central? Let us know on the comments below.


If you need further guidance or need help training your team on taking full advantage of the new capabilities of Business Central, please visit this page.