If you’re doing business with a company that’s both a customer and a vendor, you can streamline your financial transactions and save money. By consolidating the balances between you and the company, you can avoid making unnecessary payments or receipts and reduce transaction fees. It’s a win-win situation that makes financial management more efficient and cost-effective.

Creation of Customer/ Vendor From Contact Card

Customer/vendor Creation from Contact Card:

Vendors. After that, we will post a Journal entry. In a hypothetical scenario, we have purchased $600 of goods from this vendor. Later, we sold $1000 worth of more refined goods to this same vendor. Now this vendor is also our customer. We input this data and click on Post/ Print and Post.

General Journal For Transaction

After that, on the customer card, we can see the balance of the customers, as well as the balance of vendors, as shown above.

Balance (Customer/Vendor) on Customer Card

Figure 1 “The value shown in these fields is the same as the amount present in the general journal line level. Right now, these are 2 separate balances, but d365 Business Central can help you to net off both the values.” Now go to the payment journal, and there is an option for Net Customer/ Vendor Balances in the Prepare field. Click on it, and a new window will open. Specify the criteria in it. This includes document numbers, specifying the vendor, etc. Specify the criteria according to each requirement, then click OK. After this, two lines will be created in the payment journal. Once done, post the journal. As a result, the balance will be netted off, as shown below:

Net Balance on Customer Card

Figure 2“Now you can see that we are no longer liable to the vendor. The value is already net off, and the remaining balance of $400 is showing in here.” I hope you find this article helpful.

Best Regards,

Ahmad Subhani

D365 Business Central Functional Consultant

Email – ahmadsubhani424@gmail.com

WhatsApp – +923357687164

By Ahmad Subhani

Microsoft Certified Consultant | Chartered Management Accountant | Working At Adrem Technologies As a Business Central Functional Consultant

Leave a Reply

Your email address will not be published. Required fields are marked *