EFT File Format Maintenance Export/Import file

(0) Share

Report

Posted on by KSa

Hello,

Just wondering if anyone can direct me to information or resources on how to interpret the Export/Import file produced through the EFT File Format Maintenance window. I would like to know what the fields represent and available options. My understanding is that some tasks can only be achieved by manually editing the export before it is imported to another company.

I have searched for hours on Google and MS Customer Source and haven't found Any info / resources regarding how to 'read'/ interpret this file.

Thanks in Advance, Ken

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (6)

Answers (0)

Community Member on at

Like (0)

Report

<WRONG INFO>

Was this reply helpful? Yes No
KSa 5 on at

Like (0)

Report

Thanks Michael, I appreciate the quick response.

I think I understand what you are describing above as setting up the EFT file format. My interface looks different from yours (I am on GP 2016), however this looks like the fields in your EFT File Maintenance Window? I am comfortable setting the fields here, per our Bank's file definition. However, when I Export / Import the file to a text file (see screenshot below), many of the fields correspond to the File Maintenance window, but there are several other fields which appear to be 'system' fields not directly accessible in the File Maintenance window. (ie. the first Row, and first 2 Columns) . I am wondering if there is a resource to decipher these fields. For example I am aware that the number '4' directly after 'TestBank' heading is a flag that can be changed to allow different file behavior / features (not the most accurate description), and I would like to understand these fields.

Sorry if this is a very obscure request...

Thx in advance
K

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Shooot, i got the two mixed up, eft is not safepay. I been working on both lately. Apologize on that. If you have SQL, check <COMPANY DB>..CM00104 table

First column is EFT Line Type, Next is SQNCLINE - Sequence line. Dont change either. I believe that line is updated when an object is changed., ie in recurring batch, sequence line increase after the batch is run posted.

Heres is my production eft file

Was this reply helpful? Yes No
KSa 5 on at

Like (0)

Report

Thanks Michael, that's the file I was looking at, and thank you for the explanation of the fields. We were having issues getting one of the fields to display a Constant value in one of GP's provided Bank formats. Microsoft support ended up giving us direction to change the field at Cell(2,2) in the file (this cell contains a '7' in your file). Apparently this is the field that represents 'EFT Format Type'. They suggested changing to '12' (user defined format) and then importing to GP which did overcome the issue we were originally experiencing; however, it created other issues with the file so I have abandoned that format and using a secondary format supported by our bank.

I am a bit new at this so what I was really wondering was how you would know to identify that field as the 'EFT Format Type' field, etc. As I searched for probably about 3 hrs on Google and on MS Customer Source, Knowledge base, and Community but could find virtually no reference to this info. So I am wondering how and where to find resources / training docs for this type of info?

I have been given responsibility for maintaining (and enhancing) our GP implementation. I am pretty tech savvy and I have all the standard GP manuals, but still feels like I am lacking info on some of the detailed / under the hood info? Any suggestions for resources or best avenue for obtaining deeper knowledge of GP would be greatly appreciated.

Thanks in advance,

K

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Sorry I was sick and did not get on as much. So it looks like format type is what your bank uses.

Format type : IN EFT File format Maintenance - US - NACHA - PPD = 7

US - NACHA - PPD+ = 8

I did a quick test CA RBC Royal Bank is Type 5, I assume it goes down the list starting at 1 as None, 2 as CA - Bank of Montreal (CONFIRMED)

Each format type has different record types and format.. hope that helps. Did you get a manual from your bank on what format they use ?

Was this reply helpful? Yes No
KSa 5 on at

Like (0)

Report

Thanks Michael, that makes sense :) Yes Bank did give us a format template.

Was this reply helpful? Yes No