Announcements
I tested in GP2010 + SP3 and GP2013. The addenda records is using the table PM30300, PM_Apply_to_Hist. User Defined EFT format file generate twice the invoices that I am paying.
*This post is locked for comments
1. Which file are you using
2. Do you have the "Generate Auto Settlement for Each Detail Checked off?
3. Did you do a comparison of the file to what your bank is expecting.
Hello Susan.
I am using .txt file.
The format is that the bank is expecting, except for the invoice duplicate per each payment.
Yes, I tested Generate Auto Settlement for Each Detail Checked off, and it produce only the payment records without the invoice detail.
And I tested Generate Auto Settlement for Each Detail Checked on and it produce each invoice twice per each payment record.
For example, my first payment (detail record) is applying to 3 invoices (addenda record). The generated EFT file, has the payment in line number 1, and the first invoice in lines number 2 and 3. The second invoice in lines 4 and 5, and the third invoice in lines 6 and 7.
The same error I have if I use the detail record with adjust record, and if I use addenda record and adjust record.
Please, do you have any other suggestion for me?
Thank you in advanced
i am facing the same issue here, did you figure this out?
OK More details about my case i am on GP2015 R2.
i get the duplication in a different manner, i get all invoices listed then all the invoices listed again, per payment that is.
i am using addenda only, all fields are from PM Apply To History File.
i tried flat file and XML both with the same result. i made sure that i got only the details i wanted on this EFT format by directly checking table CM00104 from SQL side.
next i might do, i might start a SQL profile while generating those EFT and see what SP get called and check that
OK, more information.
after many many tries and posting and generating i got this to work, and though i shall share.
so for some reason when you do EFT and mark Electronic on Manual Payment you can generate EFT file out of it and i was using that, and for some other reason these duplicate the addenda lines in a user defined EFT format.
once i used computer check batches, print checks and generate the EFT, the file is perfect and addenda lines are not duplicated
!!! Why, i have no idea :)
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Dan Liebl 2
Shravan Attelli 1
