Finance | Project Operations, Human Resources, ...

REMITTANCE in EFT ACH file

(0) Share

Report

Posted on by Richard Wheeler

75,850 Moderator

Is there a way to get check remittance information into the ACH file? My client is working Paymode-X and we are trying to get as much information as possible into the ACH file. We will then create a customization to add sums and counts.

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Lisa at AonC.com 963 Super User 2025 Season 2 on at

Like (0)

Report

Are you looking for the Addenda record (Type 7) of the ACH File? You should be able to format it in GP's ACH file (for example with Format type: US - NACHA-CCD+) the bank you are submitting to has to be willing to accept/validate it if you are going to submit it.

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

Like (0)

Report

We need to have each payment record followed by the invoices to which it was applied. Something like this:

P_Payment

R-Remittance

C-Control

P|CHK|PayerName.Payables|123|1000.50|7654|NW Forest Supplies|123 Broadway|New York|NY|10019

R|123|INV501|20190522|100.00|110.00|-10.00|#ACC3212|Payment for Office Supplies|PO789

R|123|INV608|20190513|800.00|800.00|0|||

R|123|INV712|20190524|100.50|100.50|0||| P|ACH|PayerName.Payables|124|55.00|7600|Dynamic Data LLC||||

R|124|INV551|20190525|55.00|55.00|0|||

P|CRD|PayerName.Payables|456|1000.50|7654|Company Widgets|||| R|456|INV501|20191008|100.00|110.00|-10.00|#ACC3212|Payment for widgets|PO789|||

R|456|INV608|20191013|800.00|800.00|0|||

R|456|INV712|20191024|100.50|100.50|0|||

C|2056.00|3|7

Was this reply helpful? Yes No
Mike Bufano 1,484 on at

Like (0)

Report

Your lines with 'R' would be the addenda record

You should be able to create that record

Was this reply helpful? Yes No
Suggested answer

Cheryl Waswick on at

Like (1)

Report

Hi Richard,

As Lisa and Mike have indicated, you can map the 'Addenda' line in the EFT file to get the invoice information. You can only get to the invoice information from the PM Apply to History table, so not all information for invoices is available. As many addenda lines will print out for each invoice that makes up the check. This KB should help you map the fields for invoices:

support.microsoft.com/.../2956922

There should also be sums and counts available as Calculations in the trailer lines that you can check out. GP can sum and count AFTER the lines are listed, but not before.

Thanks,

Cheryl Waswick

Microsoft Dynamics GP Support

Was this reply helpful? Yes No