Finance | Project Operations, Human Resources, ...

Export vendor list - with bank account details

(0) Share

Report

Posted on by ocrx8

Hi team

Our internal auditors have requested a vendor list complete with bank account details. Unfortunately you can't add bank details to the export through the personalisation option, so does anyone have any smart ways of pulling this data?

Thanks.

All responses (4)

Answers (0)

Suggested answer

BillurSamdancioglu 15,786 Most Valuable Professional on at

Like (0)

Report

Export vendor list - with bank account details

Hi,

Please check vendor bank account inquiry form

https://community.dynamics.com/blogs/post/?postid=88955156-5588-ee11-a81c-6045bd86143b
Hana Xue Microsoft Employee on at

Like (0)

Report

Export vendor list - with bank account details

Hi,
There is no such report in the standard, but existing vendor base data reports can be extended (customized) to display bank details. Or use data management to create a custom data entity containing bank account information. You can also look at the existing vendbankaccount entity to see if it fits your needs. VendBankAccount in Main - Common Data Model - Common Data Model | Microsoft Learn
Best Regards,
Hana
ocrx8 12 on at

Like (0)

Report

Export vendor list - with bank account details

Thanks Ramit. How can I run the report from your suggestion?
Suggested answer

Ramit Paul 22,300 Most Valuable Professional on at

Like (0)

Report

Export vendor list - with bank account details

Hi,

Since bank can be multiple for a vendor so vendor bank details can't be extracted with vendor data entity.

However, vendor bank accounts having a separate data entity, which will give vendor account along with bank details, you can share the same with auditors.