Export Payments to file -SEPA

(0) Share

Report

Posted on by Community Member

Hi everyone,

I created an xml file for paying some vendors invoices. When I try to import this file using the home banking, I get this message : "" is not a valid value.Valid values are NORM and HIGH . It's an error linked to the PRIORITY, where I can set these value ( NORM or HIGH )in Nav for the priority??

Many thanks

*This post is locked for comments

I have the same question (0)

All responses (14)

Answers (2)

Suggested answer

Rabin 2,976 on at

Like (0)

Report

Hi Ale,

Can you upload a screenshot of the situation.
If you know and are authorized to Debug in Dynamics NAV then you can always check the breakpoint in debugger.

-----------------

Was this reply helpful? Yes No
Verified answer

Alexander Ermakov 28,096 on at

Like (1)

Report

This actually means that you are exporting the .XML file with empty (NULL) value for Instruction Priority tag, whereas the importing routine expects that it would contain NORM or HIGH values in this tag. It is strange as the option field in NAV contains just these two values and does not assume blank value. Perhaps, the Instruction Priority tag had not been exported at all.

Can you open the file and check <InstrPrty> tag, what is there? Also, what localization are you using?

Was this reply helpful? Yes No
Verified answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Payment Export Data table 1226 which is used to export the data to a file has a field called SEPA Instruction Priority Text which should have one of the above values and this field value depends on the other option field in the same table i.e on SEPA Instruction Priority, that value should have been set. Please check if you have any records in that table with empty SEPA Instruction Priority.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Alexander, I'm using the Dutch localization . I opened the file and there were no values for <InstrPrty>. We compared the code of the same Code Unit ( Italian -Dutch) and in the dutch localization appartently was missing a line of code. We fixed the bug and now the xml file has the correct value NORM. However I'm waiting now the answer of our Dutch custumer that will import the file in his home banking. Thank you

Was this reply helpful? Yes No
RubenB 10 on at

Like (0)

Report

Hi, I'm also using the Dutch localization and in BC the same issue remains. Can you please tell me what the missing line of code is? Thanks in advance

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

VALIDATE(“SEPA Instruction Priority “,“SEPA Instruction Priority “: : NORMAL);

Was this reply helpful? Yes No
Bas vA 20 on at

Like (0)

Report

Issue still exists in cloud version (Platform 14.0.29530.33541 + Application 32618 (NL Dynamics NAV 14.0) ). I've created feedback for MS at experience.dynamics.com/.../idea. Please upvote there!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Bas,

Settting one of our companies up in BC and testing payment file generation.

Get the same error.

Looks like your request got declined. Did you get a solution in the end?

BR, Rob

Was this reply helpful? Yes No
Bas vA 20 on at

Like (0)

Report

Yes, we wrote a PowerShell script to automate editing the exported file. It's a nasty workaround that requires saving the file to disk first, running the PowerShell and only then uploading it to the bank. If you would like, I can provide you with the script.

Was this reply helpful? Yes No
RubenB 10 on at

Like (0)

Report

Is this the bug where the payment priority is left blank? We’ve made a fix for this. I can look it up this morning. This is a bug in NL localization only.

Was this reply helpful? Yes No