Open Forum

Expand all | Collapse all

Vendor List w/bank and routing info

  • 1.  Vendor List w/bank and routing info

    SILVER CONTRIBUTOR
    Posted Aug 28, 2019 09:30 AM
    Hello,

    Is it possible to pull a vendor report (excel) that lists their bank account number including the routing number?

    Thanks in advance!
    Shelley

    ------------------------------
    Shelley Kirk
    Accounts Payable Manager
    Salo Inc
    Columbus OH
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Vendor List w/bank and routing info

    TOP CONTRIBUTOR
    Posted Aug 29, 2019 12:37 PM
    If you have smartlist builder/designer, you can create a smartlist from the EFT Bank Information table.
    You can also use the SQL code below if you have access to SQL:

    SELECT
    s.VENDORID AS 'Vendor ID'
    ,p.VENDNAME AS 'Vendor Name'
    ,ADRSCODE AS 'Address Code'
    ,BANKNAME AS 'Bank Name'
    ,EFTBankAcct AS 'Bank Account'
    ,[EFTTransitRoutingNo] as 'Routing No'
    FROM
    SY06000 s inner join pm00200 p on s.VENDORID=p.VENDORID
    WHERE s.SERIES=4

    ------------------------------
    Mark LeRette
    Application System Analyst II
    Muscatine Power and Water
    Muscatine IA
    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: Vendor List w/bank and routing info

    SILVER CONTRIBUTOR
    Posted Aug 29, 2019 03:10 PM
    Thank you, Mark.

    Shelley

    ------------------------------
    Shelley Kirk
    Accounts Payable Manager
    Salo Inc
    Columbus OH
    ------------------------------

    Conference-GPUG_200x200


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