web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

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

(0) ShareShare
ReportReport
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:
I have the same question (0)
  • Almas Mahfooz Profile Picture
    11,009 User Group Leader on at

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

    per-vendor.png

  • Hokuminaria Profile Picture
    2,950 on at

    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.

  • Suggested answer
    Mike Bresnan Profile Picture
    65 on at

    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!!

  • smith68574 Profile Picture
    20 on at

     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/

  • Mike Bresnan Profile Picture
    65 on at

    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.

  • Mike Bresnan Profile Picture
    65 on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 451 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 428 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans