Finance | Project Operations, Human Resources, ...

EFT Prenote missing funding account

(0) Share

Report

Posted on by TD2012

935

I am setting up EFT for a client. I have done the EFT setup, checkbook EFT setup and set up EFT banking information for the vendors. We are using both CCD and PPD. I created the prenote, although I first chose PPD, then CCD, it picked up both types in each file.

This is the response from the bank:

I’m not seeing a funding account in that file.

Also, that should be a comingled file, not two separate files. So there should be two separate batches in that file, one for CCD & one for PPD

We are only testing with two vendors, one CCD and one PPD and it picked them both up. Not sure if there should be two 'batches' or if they should all just be in the same file.

Thanks for any help. I have been over the setup and I cannot find anything, I have read all I could find about the setup.

Categories:

Microsoft Dynamics GP

All responses (11)

Answers (0)

Cheryl Waswick on at

Like (0)

Report

RE: EFT Prenote missing funding account

A dynamics EFT deposit happens when you generate an EFT file for Accounts Receivable., where you are collecting the funds.
TD2012 935 on at

Like (0)

Report

RE: EFT Prenote missing funding account

Thank you. I still can't find where the 'Dynamics EFT Deposit' comes from. I have looked at every line.

Anyone that knows where that comes from it would be appreciated.

Thank you

td
Cheryl Waswick on at

Like (0)

Report

RE: EFT Prenote missing funding account

You can expand the line on the EFT file format, to see what table/field it is pulling from. All company information is typically from the 'checkbook EFT bank maintenance' window:

Go to Cards | Financial | Checkbook, select your checkbook ID and click on the EFT BANK button at the bottom. The Bank Account number' and BANK Company name' and TAX REGISTRATION' are all fields in this window utilized on EFT. Since it's company information and doesn't typically change, coding it as a constant value in the EFT file format works too. It just pulls it from this tab on each checkbook, in case the information does vary per checkbook so you can use the same file format on multiple checkbooks.
TD2012 935 on at

Like (0)

Report

RE: EFT Prenote missing funding account

Thank you. I just put the TIN in as a constant, figured that was the easiest. I also figured out it pulls the bank account number from the bank ID (or something, not the one actually called bank account).

Do you by chance know where it's getting the name? It says 'Dynamics EFT'. I'd like to change that but I couldn't tell where it was coming from.

Thank you so much for your help.

td
Cheryl Waswick on at

Like (0)

Report

RE: EFT Prenote missing funding account

Both formats have the company bank account in field 11 in the file header line. The tax registration field is not mapped since it is not a required field in this format. You will have to add that yourself. You can try pulling it from the PM Vendor master file' table. Be sure to test it to make sure it works. If not, put it in a different field on the vendor and pull it from there.

Cheryl

Microsoft Dynamics GP support
TD2012 935 on at

Like (0)

Report

RE: EFT Prenote missing funding account

I guess I don't understand why the CCD/PPD formats don't include the company bank account or tax registration number. I have to add those myself?
TD2012 935 on at

Like (0)

Report

RE: EFT Prenote missing funding account

Thank you for your help. This is what the bank says it should look like-this if for an actual batch, I presume the prenote should be the same only it's 623 instead of 622, etc.:

101 record – Company header – needs EIN or our routing number

520 – CCD batch header (currently missing EIN, need added)

627 Company account info, total they are paying in CCD

622 – corporate account paying

622 – corporate account paying

820 – total of CCD batch

520 –ppd batch header

627 – Company account info, total they are paying in PPD

622 – person they are paying

622 – person they are paying

820 – total of PPD Batch

9 – total of batches

The prenote I ran does not include the 627 lines, nor does it create a separate batch header for CCD and PPD. There is only one header and it includes both types, even though I marked to run the prenote to only include PPD. I'm at at a loss. I have followed everything in every set of instructions I've read. I don't understand why it isn't at least including the 627 line?

Any ideas on what I could be missing?

Again, thank you for any help.
Suggested answer

Cheryl Waswick on at

Like (0)

Report

RE: EFT Prenote missing funding account

Hello TD2012,

That doesn't make any sense that 'there isn't a specific placement for the bank account number', yet they are wondering why it is not in the file. Normally they give you a specification document on where they want it placed (line, position) so that their software can read it. But put it somewhere in the header line or detail line, but they should be telling you where, as I wouldn't know the bank's requirements. You will have to work with them on that.

it also sounds like they want the first 3 digits of the Detail line to be '623' If you used one of the CCD or PPD default formats in GP,, this would be correct on an actual file for the Detail line. The '6' is hard-coded as a constant in the first position of the detail line. And if you are doing a 'prenote' file and the vendor has a 'checking' account set up, then a '623' will print. If you do an 'actual' eft file for a vendor with a checking account type, a '622' will print. The system will print the appropriate codes based on whether you are doing a prenote file or an actual file, and if the vendor has a checking account or a savings account. So I wouldn't worry about this field, as the system will do the right code for the actual EFT file sent. Perhaps you tested an 'actual' file in a test company and sent that to the bank as a prenote. The bank should be able to give you a list of these codes. But they change accordingly, and GP will do it right, so I wouldn't worry about this on your test files.

If you need a unique field of 'Woodse' or 'Rodney' in the batch header record (line that starts with 5), then you will need to generate two separate files. GP handles everything as one big batch, so you can only have one of these per file. The '5' should be hard-coded as a constant for the first digit in the batch header line, and the next two digits of 20 are mapped to pull from the 'Service Class Code' from your checkbook EFT maintenance window. So you need to go to the checkbook/EFT bank and enter the '20' there, or just edit the file to have a 'constant' of 20 too if you wish.

I hope this information helps.

Cheryl

Microsoft Support
TD2012 935 on at

Like (0)

Report

RE: EFT Prenote missing funding account

Here is the bank's response:

There isn’t a specific placement for the bank account number, but I’m just wondering why it isn’t in the file you sent. The first 3 digits of the line would be 623.

The CCD File should just have Woodse and the PPD File would have just Rodney. If you wanted to put them both in the same file there would be two lines with 520 in the beginning.

Why isn't my batch including these leading digits?
TD2012 935 on at

Like (0)

Report

RE: EFT Prenote missing funding account

Thank you!

EFT Prenote missing funding account

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Top 10 leaders for November!

Tips for Writing Effective Suggested Answers

Leaderboard

Featured topics

Product updates

EFT Prenote missing funding account

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Top 10 leaders for November!

Tips for Writing Effective Suggested Answers

Subscribe to

Leaderboard

Featured topics

Product updates