D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Vendor list with bank accounts

  • 1.  Vendor list with bank accounts

    Posted 20 days ago
    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
    ------------------------------
    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 2.  RE: Vendor list with bank accounts

    SILVER CONTRIBUTOR
    Posted 19 days ago
    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
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 3.  RE: Vendor list with bank accounts

    SILVER CONTRIBUTOR
    Posted 19 days ago
    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
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 4.  RE: Vendor list with bank accounts

    SILVER CONTRIBUTOR
    Posted 19 days ago
    Apologies - Mark is correct, Vendors entity, not customers. Take 100 lines Ian!

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

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


  • 5.  RE: Vendor list with bank accounts

    Posted 18 days ago
    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
    ------------------------------

    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready


If you've found this thread useful, dive deeper into User Group community content by role