Finance | Project Operations, Human Resources, ...

EFT CCD + and PPD +

(0) Share

Report

Posted on by BoGLG

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!

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Cheryl Waswick on at

Like (0)

Report

RE: EFT CCD + and PPD +

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

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (1)

Report

RE: EFT CCD + and PPD +

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.

https://support.microsoft.com/en-us/topic/kb-2956922-custom-data-fields-for-electronic-funds-transfer-eft-formats-in-microsoft-dynamics-gp-2640e1c2-d3aa-9298-432c-e53326d9d709

Was this reply helpful? Yes No
BoGLG 75 on at

Like (0)

Report

RE: EFT CCD + and PPD +

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

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: EFT CCD + and PPD +

If I remember correctly, the problem was trying to have one payment applied to multiple invoices. It would also list the first one.

Was this reply helpful? Yes No
BoGLG 75 on at

Like (0)

Report

RE: EFT CCD + and PPD +

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?

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: EFT CCD + and PPD +

This would require a customization.

Was this reply helpful? Yes No