Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Rebecka McKinney]

Does anyone know where to select the Transaction Code for EFT File format?

Our settings are:
Series: Purchasing
Format Type: US – NACHA – PPD
File Type: Flat File
Format Class: Business Account
Detail Line Addenda is checked.

I created the line and then Mapped To Data Field.
But no matter what I select, I cannot find a Transaction code. Is it called something else?

Thanks,

——————————
Rebecka McKinney
IntelliPoint Technologies
Barboursville WV
——————————

[Steve Burney]

?Hi Rebecka,
This is hard one to find and see if the information below helps you.
Look in Financial – Cards – EFT File Format.

Here are the steps that I found from Help information instead of typing it in my words.
Choose your EFT Format ID.

Delimit Fields option

Mark this option to assign a field delimiter, rather than identifying the fields by the start and end positions in the EFT file line. This option is available when Flat File is selected as the file type. Then, select the field delimiter you’ll use: Comma, Tab, Space, or Other. Enter a character to use when using Other as the delimiter. When you mark this option, you also have the option to select a text qualifier

Field	Length	Description	Justify	Value
1	1	Record Type	Right	8
2	2	Transaction Code	Right	06
3	9	Payee Transit Routing Number	Right	123456780
4	17	Payee Bank Account Number	Left	1009876543
5	10	Payment Amount	Right	$450.00
6	22	Payee Name	Left	Blue Yonder Airlines
7	1	Addenda Record Indicator	Right	1

I hope this helps.
Steve

——————————
Steve Burney
GP Administrator
Nissan Trading Corporation Americas
Franklin, TN United States
s_burney@nitco-us.com
615-821-6792
Twitter @SteveBurney
——————————
——————————————-

[Sandy Righi]

?In my EFT file format, the second field on the detail line is called “Transaction Code” It is defined as the “EFT Account Type” from the “Address Electronic Funds Transfer Master” table. Below is a screen shot. The vendor EFT setup includes a field labeled “Account Type”. Hope this helps!

——————————
Sandy Righi
Senior Programmer Analyst
Howard Hanna
Mayfield Heights OH
——————————
——————————————-