Open Forum

Expand all | Collapse all

Printing Checks & EFT's

  • 1.  Printing Checks & EFT's

    TOP CONTRIBUTOR
    Posted 5 days ago
    Hello,

    I would like to change the setting when printing checks and EFT's so they are printed by Vendor Name instead of Vendor ID. Where in GP do I need to go to make this change? Thanks!

    ------------------------------
    Amber Schmoll
    Accounting Supervisor
    Milk Source LLC
    Kaukauna WI
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Printing Checks & EFT's

    TOP CONTRIBUTOR
    Posted 5 days ago
    Hi @Amber Schmoll,

    When you go to print your payments there is a "Sort Checks By:" field.  The default is "Payment Number" I believe.

    If you happen to be using Mekorma's Multi Batch printing process (and if you're not, I'd highly recommend considering it), there is an options window where you can set those choices as well.  I'm including a link below to their user guide that goes into more detail.

    https://userguide.mekorma.com/mymanual/x78/en/topic/check-sorting-options

    Does that make sense?  If you have any questions, please let me know.

    Thanks,

    Samantha


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

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Printing Checks & EFT's

    TOP CONTRIBUTOR
    Posted 5 days ago
    @Samantha Higdon yes this makes sense for checks but what about EFT's? We are not using Mekorma's Multi Batch printing process. ​

    ------------------------------
    Amber Schmoll
    Accounting Supervisor
    Milk Source LLC
    Kaukauna WI
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Printing Checks & EFT's

    TOP CONTRIBUTOR
    Posted 5 days ago
    Hi @Amber Schmoll,

    So you aren't using Mekorma at all or you just aren't using their multi batch printing?

    Apologies on not including this before. I somehow missed the EFT portion (insert face palm).

    My understanding is that the generation and sorting of the EFT remittance form is based on the underlying GP report writer report (even if you're using​ word templates).  If you're using only the native GP check/EFT functionality, the best way I've seen to control the EFT side of the house is by changing the sort order on the GP Report Writer report.

    In the Report Definition window for that report within Report Writer, there's a Sort button. You can tell it to sort by vendor name instead of Vendor ID, and GP uses that sorting method for the check remittance.  If you go this route, you'll want to make sure you're using the modified version of the report by going to Microsoft Dynamics GP >> Tools >> Setup >> Alternate/Modified Forms and Reports.  Users will have to log out and log back in for that sorting to take effect.

    As always, when using report writer, I recommend having a back up of dictionaries, and ensuring that users are not logged into the system when you make the changes OR to have your dictionary ("your" being the person making the changes) pointed to a separate dictionary from the rest of the users to avoid dictionary corruption.  The new form can then be imported into the user's dictionary.

    Does that make sense?  I'd be curious to see if other users have better ways to handle it than the sort option in report writer though.

    Thanks,

    Samantha

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

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Printing Checks & EFT's

    TOP CONTRIBUTOR
    Posted 4 days ago
    @Samantha Higdon - Yes, this makes sense. I will give it a try. Thank you!​​

    ------------------------------
    Amber Schmoll
    Accounting Supervisor
    Milk Source LLC
    Kaukauna WI
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: Printing Checks & EFT's

    TOP CONTRIBUTOR
    Posted 5 days ago

    We use Mekorma MICR with our system. If you have Mekorma you can sort checks and EFTs using the instructions below:

    https://userguide.mekorma.com/mymanual/x78/en/topic/sort-checks-when-printing?q=configure+a+checkbook+s+micr+linefor

    If you are using standard GP printing, I am not sure how/if that can be set up.


    Academy - Online Interactive Learning from Experts


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