EFT XML Format Hierarchy greater than 7 fails to generate and XML Tag length limitations

(0) Share

Report

Posted on by Community Member

Greeting everyone, Currently configuring a receivables EFT format in XML format. I am having the following 2 issues and hope to get your recommendations. XML Tag Length -------------- The XML file requires the XML Tag with a tag length of 17 characters however GP2010 SP4 only provides 15 characters. How would you recommend a workaround for this limitation? My thought is to simply edit the XML file before forwarding to the bank. However an automated solution would obviously be preferred. XML Hierarchy Greater Than 8 ---------------------------- The XML format requires that one of the XML tags be set to Hierarchy = 8. However when I try to generate the file it fails to generate successfully. The error notes and out of sequence error. GP does not release the XML file and I have to close GP. Then when I review the resulting XML file I find it stops at the XML element set to hierarchy 8. Testing this out, if I change it back to 7 it generates as expected. Of course the resulting XML file is not correctly formatted. Look forward to your ideas and recommendations. Regards, Michael Smith Senior Business Analyst Peer1 Hosting

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Suggested answer

soma 24,410 on at

Like (0)

Report

This is difficult to resolve your issue without seeing your EFT XML file format setup in GP. Better contact your GP partner to look into this issue.

Hope this helps!!!

Was this reply helpful? Yes No
Haydee Mirador 120 on at

Like (0)

Report

Hello,

I know this an old post already but trying to look for something that can help me. I'm also working on configuring SEPA file that requires more than 15 characters XML Tag length.

Were you able to solve your issue?

I would appreciate if you can share your solution.

Thanks,

Haydee

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Hi, I ended up using a text tool to modify and adjust the tags as well as the XML node limitation.

Hope this is helpful.

M. Smith

Was this reply helpful? Yes No
Haydee Mirador 120 on at

Like (0)

Report

Did you experience an issue on the grouping? My payment information shows multiple times. Say, I have 2 credit transfer transaction - payment information also shows twice. It should be like below:

<PmtInf> beginning of batch (includes the debtor details)

<CdtTrfTxInf> beginning of trx 1

</CdtTrfTxInf> end of trx 1

<CdtTrfTxInf> beginning of trx 2

</CdtTrfTxInf> end of trx 2

</PmtInf> endof batch

Haydee

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

No I did not have that issue. My issue with the tag length and the nodes would not go beyond 7 levels.

Was this reply helpful? Yes No
Haydee Mirador 120 on at

Like (0)

Report

Would you mind to share your file format? We are using GP2015 RTM.

I would appreciate it very much.

Haydee

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Please send me your email address and I will send you the exported format and the reformat tools I use. You can send me a private message thru the forum but I find I cant attach a file using the private messaging so include your email address in your message and I will send it there. Michael Smith

Was this reply helpful? Yes No
Haydee Mirador 120 on at

Like (0)

Report

Thanks Michael. Please send it to hmirador@tmlcorp.com.

Haydee

Was this reply helpful? Yes No
coquisalsa 2,725 on at

Like (0)

Report

Hi Michael,

I came across exactly with the same problem you had when I was creating an EFT File Format for pain.008.001.02, I was expecting that these limitations were going to be overcome with GP 18.2, but unfortunately not. Editing the XML file before forwarding to the bank is a solution but it is not ideal.

Can you tell me which XML schema you did create? pain.001.001.03?

What text tool are you using to update the exported XML file?

Thanks,

Jorge

Was this reply helpful? Yes No