Finance | Project Operations, Human Resources, ...

EFT Prenote missing funding account

(0) Share

Report

Posted on by TD2012

943

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

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

Cheryl Waswick on at

Like (0)

Report

RE: EFT Prenote missing funding account

Hello TD,

For the funding account, you will have to look at the bank file specifications and see what line/position they want the funding account in. GP does not have any funding capability. If this is a static value, you can hard-code it into the file as a constant. If it changes per checkbook or vendor or invoice, then you can hard-code it onto a field that you can pull into the EFT file format. For example, if it changes per vendor, then put it on any field in the EFT Bank window for your vendor that you are not using, and map that field to the line/position in the file format. Or if it changes per invoice, type it in the Reference line on the invoice and map that field to the line/position on file, but typically invoice information is only in the 'addenda' line. But if it's an 'if/then' field, GP won't be able to do it. GP will pull whatever field you have mapped to in the file format, so the value has to already be there to be able to pull it and put it on the file, if this is a required field on your format.

GP will generate one file for each file format ID, or for each time you process the prenotes. You processed the prenote file twice, one for each file format you set up, therefore you will get 2 files, one for each time you processed. If you want only one file, then you need to pull all vendors/customers into the same file and process them together at the same time.

GP will lump them all into one big batch in the file, and you will have only one batch header ID in the file. This is fine, as the bank usually doesn't know the difference and is acceptable.

Hope that helps,

Thanks

Cheryl Waswick

Microsoft Support

Was this reply helpful? Yes No
TD2012 943 on at

Like (0)

Report

RE: EFT Prenote missing funding account

Thank you!

Was this reply helpful? Yes No
TD2012 943 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?

Was this reply helpful? Yes No
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

Was this reply helpful? Yes No
TD2012 943 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.

Was this reply helpful? Yes No
TD2012 943 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?

Was this reply helpful? Yes No
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

Was this reply helpful? Yes No
TD2012 943 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

Was this reply helpful? Yes No
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.

Was this reply helpful? Yes No
TD2012 943 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

Was this reply helpful? Yes No