How to Merge Customer and Vendor Payments in Business Central
In this how-to video, Dave Wiser, UG Expert, gives a tutorial of how to merge customer and vendor payments in Business Central.
Key Takeaways
- Overview: In Business Central, customer and vendor balances can be linked and viewed on both customer and vendor cards. This allows users to see how much they owe and are owed.
- Customer cards: Next, Dave explains how to link customer and vendor accounts in Business Central using contact cards. By establishing business relationships through the contact card, users can link a customer card to a vendor card, effectively merging the accounts.
- Different views: Upon reopening the customer card in Business Central, the related vendor balance is displayed alongside the customer receivable balance. This linkage allows users to view and drill down into both customer and vendor balances from either card.
- Payment journal: As an alternate method, Dave shows how to merge customer and vendor balances in Business Central using the payment journal. By selecting the “net customer vendor balances” option, users can bring in and merge ledger entries, resulting in a net payable or receivable.
- Example: After posting the transaction in Business Central, he reviews the vendor balance and notes that some receivables and payables due after March 31 remain open. The merged transactions have closed the customer entries, and the net amount due to the vendor is $739.57.
