Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

EFT Batch only using check number for first payment in batch?

Posted on by 65

we are trying to deploy a customization so that we can send our bank an integrated payment file, so they can print and send our checks. To do so, we have to process the check payment batch, as an EFT. We changed the checkbook EFT specifics to use check numbers instead of EFT numbers, assuming it would assign each payment in line with the check numbers. when we built and processed the batch via the "build check batch" module, it only used the check number series for the payment number on the first document. So payment 1 was number 12345 (the correct next check number), and then payment 2 and beyond were then EFT0000123, etc. Has anyone used that "use check number" feature successfully? is it not supposed to be used for multiple payments in a batch?

I'm thinking the only other option would be to use a separate checkbook for our check payments, which may cause some difficulty with reconciliation.

Categories:
  • Mike Bresnan Profile Picture
    Mike Bresnan 65 on at
    RE: EFT Batch only using check number for first payment in batch?

    This unfortunately didn't work. it's still pulling the EFT number for any payments after the first one. Not sure if it makes a difference, but we changed this option after the invoices were posted, but before the check batch was created.

    We are on GP version 2018.00.0496 if that changes anything.

    Hopefully we are moving to a version beyond R2 this year, but i'd like to find a workaround for this.

  • Mike Bresnan Profile Picture
    Mike Bresnan 65 on at
    RE: EFT Batch only using check number for first payment in batch?

    yeah, on our version of GP, we would need to set those customers to One payment per Invoice.

    Ultimately, we need to move to a more recent version to actually fix the issue.

  • smith68574 Profile Picture
    smith68574 20 on at
    RE: EFT Batch only using check number for first payment in batch?

     Did you have a fix on this issue? Facing same issue but no response from anyone and could not find this topic troubleshooting in google. www.conduentconnect.org/

  • Suggested answer
    Mike Bresnan Profile Picture
    Mike Bresnan 65 on at
    RE: EFT Batch only using check number for first payment in batch?

    Yep, we are not even on 2018 R2 so that makes sense...

    ok i think we will try and go with Almas' response until we upgrade in the near future. Thanks!!

  • Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: EFT Batch only using check number for first payment in batch?

    Hey Mike,

    I believe you are actually running into a Product Issue.

    Product Issue 89966 Select Checks Remittance uses check number and EFT number for first vendor and switches to EFT number incorrectly.

    This is fixed in GP 2018 R2. If you are on a prior version than this, then this is likely the issue.

    I hope this helps!

    Thank you!

    Brandon | Microsoft Support Engineer.

  • Almas Mahfooz Profile Picture
    Almas Mahfooz 11,003 User Group Leader on at
    RE: EFT Batch only using check number for first payment in batch?

    You need to mark One payment per invoice option to have check numbers instead of EFT numbers.

    per-vendor.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans