Open Forum

Expand all | Collapse all

Re-create check stub EFT payments with Word template

  • 1.  Re-create check stub EFT payments with Word template

    Posted 14 days ago
    We generate EFT numbers on our processing of EFT payments from within GP and then the vendor is emailed a .docx (word template check remittance) file.

    After that when the user tries to go into GP and "re-create check stub" they get only the standard GP report writer format.

    These 2 formats do not match and have different information/columns/fields included. This is confusing to our vendors if our "reprint" is different than the original. Is there a way to fix this?


    ------------------------------
    Lori Maxwell
    GP Functional Consultant
    The Heritage Group
    Indianapolis IN
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Re-create check stub EFT payments with Word template

    GPUG ALL STAR
    Posted 13 days ago
    In order to accommodate for this, you will need to modify the Reprint Check Remittance report in Report Writer to make sure it contains the same set of fields you have in the standard EFT remittance report.

    NOTE: you don't need to make the report pretty. You just need to drag and drop the fields you need into the correct sections of the report IF there are any missing.

    Back in GP, grant security to the modified report and print and change the Report Type from Standard to Template. Select File as the output.

    Once you've done that, you can then enable the Reprint Check Remittance report as a Word template -- Reports > Template Maintenance. Click on the Report Name drop-down, then select Product | Microsoft Dynamics GP, Series | Purchasing, and Status | Modified. Look for the Reprint Check Remittance report there. Click on Select to configure.

    Modify the template in Word to bring it in compliance with the layout you are looking for. Once you are done, save into a location where you can pick it up from.

    Back in GP, reimport the template. Finally assign to the company and/or users that need to run the report.

    ------------------------------
    Mariano Gomez Bent, MVP, Dynamics Credentialed Professional
    Director of Technology
    Mekorma
    ROSWELL GA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Re-create check stub EFT payments with Word template

    Posted 13 days ago
    Thank you! Creating the new word template for "reprint check remittance" solved the problem.

    ------------------------------
    Lori Maxwell
    GP Functional Consultant
    The Heritage Group
    Indianapolis IN
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Re-create check stub EFT payments with Word template

    TOP CONTRIBUTOR
    Posted 13 days ago
    Hi @Lori Maxwell,

    Mariano nailed how to get the reprint modified to your needs.

    Just a quick reminder on a piece that I find lots of our clients forget...When you use GP to email out documents like the EFT remittance,​ a copy is saved in the sent folder of the email address used to email out the original document.  You can always check the sent folder if you want to be able to forward/resend the original email and contents!

    It's one of the reasons I recommend clients consider a shared email (i.e. AP@theheritagegroup.com) so that the entire AP team can trace the email in the event the original sender is out of the office, etc.

    Thanks,

    Samantha

    ------------------------------
    Samantha Higdon ,CPA,CGMA
    Consultant
    Lagom, LLC
    Carmel IN
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Re-create check stub EFT payments with Word template

    Posted 13 days ago
    Exactly !   We also set up a dedicated email address for our payables and it makes it so much easier to track our payables in one place.  I still have a few vendors who prefer to deal with me directly, but overall it does help.

    ------------------------------
    Janet Schofield
    Accounts Payable Specialist
    Naval Aviation Museum Foundation
    ------------------------------

    Academy - Online Interactive Learning from Experts


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