Can you link a customer and a vendor record

(1) Share

Report

Posted on by AndyEnhanced

If we have a Customer that is also a Vendor in Business Central, can these two records be linked? Or would we need to create separate companies in both Customers and Vendors?

I have the same question (0)

All responses (7)

Answers (2)

Suggested answer

keoma 32,729 on at

Like (0)

Report

simply create the company as customer and as vendor. thats needed, because the sales and purchase processes must be handled correctly.

then add the company's vendor no. to the customer comments and vice versa.

Was this reply helpful? Yes No
AndyEnhanced 35 on at

Like (0)

Report

Does this link them in BC though? Or does it just allow people to see that there is an accompanying vendor/customer record that they can search for themselves if they open it?

Was this reply helpful? Yes No
Suggested answer

keoma 32,729 on at

Like (0)

Report

this is only an information.

there is no concrete connection opportunity to link a customer and a vendor in bc.

why do you need that in detail? whats your aim?

Was this reply helpful? Yes No
AndyEnhanced 35 on at

Like (0)

Report

If we have a customer that is also a vendor and there outstanding invoices on both the credit and debit accounts, how would we go about doing contra postings?

Was this reply helpful? Yes No
Verified answer

keoma 32,729 on at

Like (1)

Report

that is not possible in standard bc, that needs a customization.

e.g. an additional infobox in the customer card with according vendor details and/or the possibility to add a discount row in sales invoices with invoice data from the according vendor, if the same company has outstanding bills aso. in the first step it would helpful for you the add the vendor's oustanding bill sum as new field on the customer card and vice versa.

Was this reply helpful? Yes No
Verified answer

Jeff Sergeant 60 on at

Like (1)

Report

You need to create them in both Vendors and Customers, but they can be linked via Contacts.

Create your customers, this will automatically create a 'Company' contact for each one.

Go to Business Relations for the Company Contact, Add a new Business Relation Code of e.g 'VENDINFO', (can't use the standard 'VEND' one)

Then, create a business relation for this contact with a code of 'VENDINFO', a Link-to table of 'Vendor' and select your Vendor code.

Now, from the Vendor Card, you can do Vendor > Contacts and see the related Customer Contact.

And from there get to the customer card

You could even set this contact as the 'Contact' for your vendor.

It's not perfect, and the link doesn't work as well the other way around, but a few small mods around this concept would give you a really neat solution.

Was this reply helpful? Yes No
AndyEnhanced 35 on at

Like (0)

Report

Thanks for your detailed response Jeff. This is a good solution and will definitely suffice.

Was this reply helpful? Yes No