Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / EFT file with CSV form...
Microsoft Dynamics GP (Archived)

EFT file with CSV format with multiple lines and vendor invoice numbers

(0) ShareShare
ReportReport
Posted on by GuruDofGP 240

I've looked in the forum and community trying to find the answer to this question, but can't seem to find it.  I am setting up the EFT file to send to the bank in Dynamics GP2015 R2.  The file needs to be a csv, and initially, the file was creating as a csv format.  I've tried resetting the path where the other csv's are to recreate them again in this format, but it's not offered as an option.  It only creates the standard txt comma separated value txt file.

I need to be able to create the file as a csv file format again, not txt.  It needs to include multiple lines for each individual invoice being paid to each vendor with the corresponding individual payments, and the invoice numbers need to populate in the file.  Currently, the invoice numbers are not populating in to the file at all.

Please let me know if this is possible?  Thank you in advance for your assistance!

Diane

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: EFT file with CSV format with multiple lines and vendor invoice numbers

    Would Reports->Purchasing->Posting Journals and choosing Checks Journal be sufficient?

    or Reports->Financial->Checkbook->Checkbook Register work?

  • GuruDofGP Profile Picture
    GuruDofGP 240 on at
    RE: EFT file with CSV format with multiple lines and vendor invoice numbers

    That I had suggested as the solution for the reporting.

  • GuruDofGP Profile Picture
    GuruDofGP 240 on at
    RE: EFT file with CSV format with multiple lines and vendor invoice numbers

    Since I've not received a response for this question, I'm guessing that the SmartList format is the only way I can get a report for each EFT generated with each invoice paid for by each vendor.

  • GuruDofGP Profile Picture
    GuruDofGP 240 on at
    RE: EFT file with CSV format with multiple lines and vendor invoice numbers

    The more I'm thinking about the required bank's parameters with the csv file, it may be easier just to create a PM SmartList to export, save as a csv with the multiple lines and individual payments, that will include the individual invoice numbers column to populate each line/row in it as the export file to send to the bank.  Unless the EFT file that can be generated by GP will accomplish.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,399 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans