Open Forum

Expand all | Collapse all

print all invoices attached to vendors

  • 1.  print all invoices attached to vendors

    Posted Jan 17, 2019 07:25 PM
    we have account numbers that we have to print all the invoices attached to certain vendors for that account.  Is there a way to do a SQL script or access the info in bulk format in GP to print all the attachments for certain vendors?

    Please advise

    Betty Hall
    Powell Christensen inc
    Richland WA

  • 2.  RE: print all invoices attached to vendors

    Posted Jan 18, 2019 09:07 AM

    @Betty Hall

    I think what you are asking for is a report showing the General Ledger Account distributions for AP transactions.  Is this correct?

    If so, the indomitable Victoria Yudin has one that you can use. (Below Link)

    I'm, however, unsure of what you mean by "print" the invoices for Vendors?  Some type of report?  Or, do you use Document Attachment and need to print the invoice FROM the vendor again?

    SQL view for Payables GL distributions in Dynamics GP

    Victoria Yudin remove preview
    SQL view for Payables GL distributions in Dynamics GP
    Here is a view that will return the General Ledger distributions for all posted or unposted payables transactions. Unposted is also called 'work' and posted includes any open or historical transactions. If you're going to use this with SmartList Buidler, make sure to include the section at the end to grant permissions to DYNGRP.
    View this on Victoria Yudin >

    Kindest Regards,
    Jo deRuiter , MCP, DCP
    "That GP Red Head"
    GPUG Academy Instructor
    Dynamics GP Credentialing Council-Vice Chair
    770-906-4504 (Cell)


  • 3.  RE: print all invoices attached to vendors

    Posted Jan 18, 2019 02:07 PM
    Hi Betty,

    There are a couple of things that could accomplish this. One would be a macro to pull the invoices and print them. A second way would be with a SQL script but building that would need to be done by a developer.
    The macro would probably be relatively quick, the only issue would be that you would need to have the report writer format for historical invoices done, I am not sure if you have that. If you do, all you would need would be a spreadsheet of vendors and invoice numbers that you wish to print (maybe from a smartlist) and then build the base macro, do a mail merge in word and generate the complete macro file and run it.
    Once you have that, you could re-run the macro with a new spreadsheet and it would not take long at all.

    Randy Chapman
    Implementation Specialists (IS)
    Hawley MN

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