Setting Up NACHA file format for ACH Payments in Business Central using Data Exchange Definition

(0) Share

Report

Posted on by Revan Jaunt

375

Hello Everyone,

I would like to know how to define the below NACHA file format for ACH Payments using Data Exchange Definition in Business Central.

Format:

How to setup this format and which code unit should be assigned for it?

Kindly support.

Thanks & Regards,

Jaunt

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

Pick one of the standard EFT data exchange definitions and begin to edit from there.

If you have already started a new definition copy the codeunit units, tables, etc from one of the provided definitions.

Was this reply helpful? Yes No
Revan Jaunt 375 on at

Like (0)

Report

Hi Again,

I have created an EFT file using default definition available on CRONUS USA company. I have few queries on that.

1. How to bring space in first row between priority code (Blue color box) and Immediate Destination (Orange color box).

2. For last 5 rows, I am seeing continuous '9's. Is it normal? If not how to restrict it?

Kindly share your thoughts.

Thanks in Advance.

Jaunt.

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

1. try right justify for the routing number

2. this is normal for US ACH files, I suggest not changing.

Was this reply helpful? Yes No
Revan Jaunt 375 on at

Like (0)

Report

Hi Kim,

Thank you for your guidance.

As per your suggestion, I tried justification option to create a gap between routing number. But it's not creating a space.

My desired result should look like below.

Kindly let me know whether any other way to achieve it.

Thanks in advance.

Jaunt.

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

Check the box for Text Pad Character Required, see if that helps.

Was this reply helpful? Yes No
Revan Jaunt 375 on at

Like (0)

Report

Hi Kim

Thank you for your help.

I will check and get back to you.

Thanks,

Jaunt

Was this reply helpful? Yes No
Revan Jaunt 375 on at

Like (0)

Report

Hi Kim

Good morning.

Text Pad looks suitable but I would like to know which character to be used to create space.

Kindly share your thoughts on this.

Thanks,

Jaunt

Was this reply helpful? Yes No
dwolf 8 on at

Like (0)

Report

Hi Jaunt,

Just put a space in pad character field. If you highlight the box you will see it is holding the space you entered if it looks like this

Was this reply helpful? Yes No