Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Susan Bratek]

Hello,
Can anyone tell me how I can generate a report showing all Vendors with their bank account and routing numbers?

Thanks,
Susan

——————————
Susan Bratek
Accountant
Allied Motion Technologies Inc.
Amherst NY
——————————

[Ian Waring]

Hiya,

I have a PowerBI report that sees all of this (bar the routing/sortcode) in the CustomersV2 or CustomersV3 Entity (has all the tax data in there too.

I’ve not found where the routing number is stored though (ran out of time with other priorities nagging at me :-)).

hth.

Ian W.

——————————
Ian Waring
Head of Finance Systems & Projects
Jisc
Bristol
——————————
——————————————-

[Mark Bailey]

Hi Susan,

There is no standard report that gives you this. The Bank data is held in a separate table VendBankAccount which needs to be joined to VendTable to produce the report.

There are 2  data entities VendorsV3 and VendBankAccount you can use these to extract the data through data management and then put the report together outside of the system through. (I.e. Vlookups in excel to return the Bank account & Sort Code.)

Alternatively you could set up an Electronic report which you can configure to do the above for you so you just run a report from within the system.

Hope that helps 🙂

——————————
Mark Bailey
Application Consultant
Annata
Portsmouth
——————————
——————————————-

[Ian Waring]

Apologies – Mark is correct, Vendors entity, not customers. Take 100 lines Ian!

——————————
Ian Waring
Head of Finance Systems & Projects
Jisc
Bristol
——————————
——————————————-

[Phil Dawson]

Hi Susan,

Another option to the above is to open the vendor bank account form. If you are using D365 just add &mi=vendbankaccounts to your URL, so

https://xxxx.operations.dynamics.com/?cmp=xxxx&mi=vendbankaccounts  (where xxxx is your instance).

From here you can see all the vendor bank accounts.  To get the data out you will need to personalise the form and add the routing number and account number to the pane on the left, you can then use export to excel to pull all the records out.

Cheers
Phil

——————————
Phil Dawson
Sunpork Fresh Foods Pty Ltd
——————————
——————————————-