EFT Text File case sensitive

(0) Share

Report

Posted on by Community Member

We are working with a client who is banking with BMO and they are stating that their bank is asking for their company name to be upper and lower case in the GP generated text file. I am guessing that is part of the programming of the file creation since we tried by using a constant in that field, with upper and lower case and it still came out all caps. Any suggestions on how to get this to be upper and lower case for the client?

Dawn

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

26P2ER 1,775 on at

Like (1)

Report

Hi DMS20644

Do you mean go from HOMER SIMPSON LLC to Homer Simpson LLC?

From Financial|Cards|Check Book Maintenance - Open the checkbook in question

click on EFT bank -

locate the "Bank Company Name" as shown in the picture below

Type over the Bank Company Name to read Homer Simpson LLC instead of the company in ALL CAPS.

After this change is made in GP, all future EFT files will show the company name in Camel case.

Give this a whirl and keep us posted.

Best

Was this reply helpful? Yes No
Tymay 297 on at

Like (0)

Report

Hi,

Understand that this post had been posted quite a while ago but we are also facing the same problem but on other text fields. The bank wanted the type of payment to be entered as Domestic Payment (MY) with the exact capitalization. But when we generate the EFT file, it keeps changing the word to all CAPS > DOMESTIC PAYMENT (MY). How can we resolve this?

Really hope to get some advice.

Thank you in advance,

YMay

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

If GP capitalizes the text you will need a customization to read the EFT file after it is created to remove the capitalization. We have run into things like this where some banks have oddball requirements.

Was this reply helpful? Yes No
Tymay 297 on at

Like (0)

Report

Hi Richard,

Thanks for your feedback. Noted on the limitation. We resorted to creating a powershell command to perform such change.

Ymay

Was this reply helpful? Yes No