Open Forum

Expand all | Collapse all

Selecting Payables EFT's with multiple checkbooks

  • 1.  Selecting Payables EFT's with multiple checkbooks

    Posted Aug 13, 2019 04:31 PM
    In the past we have only had one checkbook for our EFT transactions. We will be implementing EFT with our other checkbooks now as well. When I go to create an EFT file for the new checkbook it pulls in the vendors that are associated with our other checkbooks even though I specifically said which checkbook I wanted to run EFT's with and have it setup to pull by vendor. Does anyone know how I can prevent ALL EFT vendors from pulling into the batch without having to create a bunch of restrictions in the select payables checks window? I thought by doing it by checkbook should be enough. What am I missing?

    ------------------------------
    Crissy Wolverton
    Teck American Incorporated
    Spokane WA
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Selecting Payables EFT's with multiple checkbooks

    GPUG ALL STAR
    Posted Aug 14, 2019 08:11 AM
    Hi @Crissy Wolverton

    When you decided to switch to the new EFT, were these transactions already entered in GP or were they entered afterwards?

    You'd also need to check which Checkbook ID was associated with the batch of payables when they were entered and if the vendors on the Vendor Card>Options have a hard-coded Checkbook ID in them.


    ------------------------------

    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: Selecting Payables EFT's with multiple checkbooks

    Posted Aug 14, 2019 10:14 AM
    We have 5 bank accounts for one company. Up until now we have only processed EFT's out of our general account for AP purposes. I would like to switch our Medical/Dental bank account (we are self-insured) to be EFT as well. So vendors A,D,Z are AP vendors that need to be paid out of the general bank account via EFT and vendors B,C,G,Y are medical provider vendors that need to be paid out of the medical bank account via EFT. The vendor cards for each vendor specify which bank account the vendor is related to and the bank accounts have each been setup for EFT. When I tried to run an EFT batch for the medical vendors (B,C,G,Y) all of the vendors A-Z pulled in no matter whether they were for the general or for the medical checkbook.

    ------------------------------
    Crissy Wolverton
    Teck American Incorporated
    Spokane WA
    ------------------------------

    Conference-GPUG_200x200


  • 4.  RE: Selecting Payables EFT's with multiple checkbooks

    SILVER CONTRIBUTOR
    Posted Aug 14, 2019 09:26 AM
    I agree with Jo's post - some changes in AP are not retro-active.  Each voucher's payment information needs to be updated

    ------------------------------
    Deanne Rasmussen
    ePlanPartners
    Houston TX
    ------------------------------

    Conference-GPUG_200x200


  • 5.  RE: Selecting Payables EFT's with multiple checkbooks

    Posted Aug 15, 2019 03:43 PM
    Crissy,

    We pay employees and states (garnishment) using EFT. We create the same vendor class ID for employees and doing the same thing for all garnishment vendors.  When building payment by vendor Class ID, our garnishment ones are not included in employee ones. Even though it's the same checkbook for us, i doubt that 2 separate checkbooks won't work.  Which version are you on? We're on 2016 R2.


    ------------------------------
    Houston TX
    ------------------------------

    Conference-GPUG_200x200


  • 6.  RE: Selecting Payables EFT's with multiple checkbooks

    Posted Aug 15, 2019 04:50 PM
    Thank you, I kinda had a feeling this would be the way I would have to go. I was just hoping to have as few touches for our check processing person as possible. I think I am going to look into the Mekorma Multi-batch so I can create it for her and then she doesn't have to do any extra work.

    ------------------------------
    Crissy Wolverton
    Teck American Incorporated
    Spokane WA
    ------------------------------

    Conference-GPUG_200x200


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