Finance | Project Operations, Human Resources, ...

REMITTANCE in EFT ACH file

(0) Share

Report

Posted on by Richard Wheeler

75,852 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)

Sort by

Suggested answer

Lisa at AonC.com 1,062 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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