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 :
Microsoft Dynamics GP (Archived)

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

(0) ShareShare
ReportReport
Posted on by 248

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

I have the same question (0)
  • GuruDofGP Profile Picture
    248 on at

    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.

  • GuruDofGP Profile Picture
    248 on at

    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
    248 on at

    That I had suggested as the solution for the reporting.

  • Richard Wheeler Profile Picture
    75,848 Moderator on at

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

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

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 > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Liquid error: parsing "/globalsearch/?q=Intel(r" - Not enough )'s.