It is possible to register one company as both vendor and customer. And usually in such case, it is natural that Customer and Vendor balance for the same company to be consolidated at the end of the month, so that you are not making unnecessary payments or receipts. In standard function you can use the journal entry to manipulate the balance, but it is not user friendly. It is ideal to pre-define the customer/vendor relationship, and then execute a "function" where system consolidates the balance between Customer and Vendor.
Comments
I would see this bigger.
Have possibility to create groups of customer
Create a new table head customer
Link head customer to customers
Have possibility to link customer to vendors
Possibility to see overview of balances (& details) customer + linked vendor in 1 company
Possibility to see overview of balances (& details) headcustomer + linked vendors in company
Possibility to see overview of balances (& details) customer + linked vendor in all reporting companies (new parameter to be defined)
Possibility to see overview of balances (& details) headcustomer + linked vendors in all reporting companies
Category: Financial Management
This would be very helpful
Category: Financial Management
Business Central Team (administrator) on 9/21/2022 8:14:03 AM
This was completed in april 2022:
See Consolidate customer and vendor balances - Dynamics 365 Release Plan | Microsoft Learn
Best regards,
Brian Nielsen, Program Manager
Business Central team