75
Hello!
Does anyone know if GP supports multiple addenda records for one ACH payment. The use case is if a payment to a vendor is paying multiple invoices, we'd like to be able to show each invoice number on a separate addenda line. Does GP2018 support that?
Thanks!
Hello GPManiac,
Yes, of course GP supports multiple addenda records in the NACHA formats so PPD and CCD formats would be able to do this. (However, the IAT format does not.) If you mark the 'Detail line addenda' checkbox, then one remittance line will print for each invoice that makes up the payment for the PPD/CCD formats. So if 3 invoices make up the payment, then 3 addenda lines will print below it, if 12 invoices make up the payment then 12 lines print,etc... However, remember to map the fields for the Addenda line, where KB 2956922 comes in handy to show you to pull the 'Apply to document number' from the PM Apply to History file. You can only get to the fields on the invoice that are in the 'apply' table to the payment (apply amount, date, discount), so you would not be able to pull other fields on the invoice such as the invoice description, PO#, original doc amount (if credit memo's applied), etc.
See Questions 4, 19 and 20 in KB 945955. http://support.microsoft.com/help/945955
I hope that helps.
Thanks
Cheryl Waswick
Microsoft Dynamics GP support
I asked this exact question back in January and the response from Microsoft was that it cannot be done.
However, I did come across this.
I was under the impression that the Detail Line Addenda Check Box(below) was added to support my scenario exactly. So, the scenario is:
I'm paying a Vendor via EFT for 3 Invoices in 1 EFT payment. My expectation is that GP would create 3 Addenda records for that payment when I Generate the EFT file. Is anyone out there currently doing this?
Thanks!~
If I remember correctly, the problem was trying to have one payment applied to multiple invoices. It would also list the first one.
Hi Richard! Thanks for the reply. Let me take a step back. I think you can easily add the invoice # if it's a one to one relationship between the payment and the invoice. That can be done fairly simply through the GP application front end without a customization right?
This would require a customization.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,532
Super User 2024 Season 2
#2
Martin Dráb
228,501
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (