Skip to main content

How to Consolidate Customer and Vendor Balances in Business Central

Understand that some customer of the company might be the vendor of the company too. There is a feature in Business Central that allows users to consolidate both customer and vendor balances without making unnecessary payment or receipts.


Prerequisite Setup for Customer and Vendor Consolidation

Page: Marketing Setup

        1.       Setup a Business Relation Code for each Customers and Vendors.





        2.       Assign a number series under Contact Nos. A number will be pickup from the number series when there is a new Contact code created.






To Link the Relation between Customer Card and Vendor Card

1.       Go to Customer Card, look for the customer that you need to link in Customer Contact.






2.       Confirm the Customer Name that you have selected.



3.       Link with the Customer with existing Vendor.

(Path: Actions > Functions > Link with Existing > Vendor)






4.       Select the Vendor No. from the vendor listing to link.








5.       The Contact Business Relation status should have changed from Customer to Multiple.



6.       You can now see the balance from Vendor Ledger in Customer Card.





7.       Same goes in Vendor Card, you will be able to see the balance of the Customer Ledger.


Take note that you can also do it another way around which is linking business relation from Vendor Card.




Customer and Vendor Consolidation

 

Page: Payment Journal

 

1.       To consolidate the documents of same vendor and customer, you will need to do it in Payment Journal page. Select “Net Customer/Vendor Balances” from Prepare.







2.       Select Vendor No. that need to be consolidated, then select OK to proceed.






3.       The offset entries will be automatically created.




















Comments

Popular posts from this blog

How to Reverse Posted Documents in Business Central

  If you need to amend or change a posted documents in Business Central, there are few ways to do it instead of having you to manually create a reversal journal or Credit Memo to rectify a Posted Document. Before you proceed to Correct or Cancel any document that posted in Business Central, you need to identify the origin of the posted document, as the method of cancellation depends on the document type.   There are 2 types of documents that posted in Business Central. i.                      Journals – E.g., General Journals, Purchase Journals, Payment Journals, Sales Journals, Receipt Journals etc. ii.                    Documents – E.g., Purchase Invoice, Purchase Credit Memo, Sales Invoice, Sales Credit Memo etc.   A.       A.     C orrecting ...

Foreign Currency Revaluation in Microsoft Dynamics 365 Business Central

Microsoft Dynamics 365 Business Central (BC) allow users to account for foreign currency transactions. BC also able to translate the registered foreign currency amount into functional currency that setup in the entity using the conversion rates which setup in Exchange Table.   Due to the exchange rates fluctuate constantly, as a dollar worth in foreign currency today might not equivalent to the same foreign currency worth the next day. Hence, users are required to adjust the open documents that transact in foreign currency which include open invoices, credit memos, and advance payments. Once the open documents transacted in foreign currency is revalued, the gain and loss which calculate after comparing the closing rates at the period end will be posted to profit and loss as unrealised gain and loss, ensuring that the subledgers and general ledger can be reconciled.   This process can be done using Adjust Exchange Rate in BC, a batch job to adjust the exchange rates fo...

Disposal of Fixed Asset in Business Central

You can perform Fixed Asset Disposal in Business Central in Fixed Asset G/L Journals . The reason for performing fixed asset disposal may be result of several events: i.                       An asset is fully depreciated and must be disposed of ii.                        An asset needs to be removed due to unforeseen events (EG., theft) iii.                     An asset was captured with wrong information and need to be reversed   In the following example here, the user has registered the asset in the fixed asset book, and there is depreciation being perform too, but later identified that the asset was registered with wrong date. It will be easier to dispose this asset and capture again using new Fixed Asset ID...