Finance | Project Operations, Human Resources, ...

Change payroll ACH file format

(1) Share

Report

Posted on by James McCullough

379

Hey Everyone:

I have a client dealing with JP Morgan Chase and they want to use the ACH export. I'm Canadian, they're American, so my knowledge of the intricacies of the payroll module aren't /great/, but I know enough to know to ask people who know better. One of the /features/ of JP Morgan Chase is this:

(The highlight is theirs, but the red box is mine.)

Their system won't accept a /200/ file. But that's all the payroll system produces as far as I can see. Where do I set that to make it a 220? Can it even be done? Surely my client isn't the first Dynamics GP user that's a JP Morgan Chase client...

Any help would be appreciated!

-J

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

David Musgrave MVP ... 14,093 Most Valuable Professional on at

Like (0)

Report

Using GP Power Tools - Developer Tools module, it should be possible to either manipulate the data as the file is created or to read and rewrite the file after it is created to resolve this issue.

GPPT Portal: https://WinthropDC.com/GPPT

If we can create this fix, we could publish it on the samples page for other GP customers to use.

Regards

David

Was this reply helpful? Yes No
Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

Hi James,

I have setup this format few months back, I may have the format still in my dev GP. Need to check.

Was this reply helpful? Yes No
Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

As per the details, this must be set for either credits or debit transaction batch.

Go to checkbook Maintenance window, select your checkbook and then press EFT Bank button, EFT maintenance window will open and there you can find Service class code field, change the value and then test your file.

Was this reply helpful? Yes No