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.
[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.
3. In Navigate menu, select Contact.
4. Add Contacts. Once added, in Actions menu, click Functions, Create As, then select Vendor.
5. Select a template for a new Vendor then Click OK. A new vendor card will be added.
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.
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.
3. Input Document Number and Vendor Number then click OK.
4. Payment journal is now created for Vendor and Customer.
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.