You’re offline. This is a read only version of the page.
Announcements
we are on the way to implement QR Bill to our company. Now with all our bank account it works besides one, the biggest one.
We have tried to import the cam.054 file but the time and date format is not correct due to the examples of microsoft. the bank will not change the date and time format for us.
here is the actual screenshot who broad up the error. We tried to manually change the "ToDtTm" Field and after this it worked. Do you guys have a possible solution to implement such a function into Dynamics Finance without having a separate tool in place who changes the XML Files?
Thank you for your help and I am looking forward to hear from you.
Hi Carl D,
Please create a new thread about your issue so it can be followed better.
HI there,
I have the same issue and have followed up on this solution as we are also trying to import a camt054 File to implement QR BIlling and it seems that the formula is working when running the test in the designer but when importing it does not. Any Idea what we could be mssing?
kr
Carl
You can also take advantage of following Microsoft post regarding functions in the Date and time category in ER Config:
Hi Dominic_23,
As soon as node <CreDtTm> have correct datetime format you can import the Camt054C file.
You can also create a derived version of ISO20022 Cam054
and then click on "Designer" and add a transformation formula that when a date time format is 24:00:00, it replaces it to 23:59:59
Then set the status for this config to Completed and add this config to your customer payment method:
Then, try to import the payment file. I have just tested and it works fine:
I hope it helps you.
Hi Alireza,
It's from our Main Bank Account (UBS) which sends us the Camt.054 Files with the time of 24:00:00 set. I requested to change it according to the standards of Microsoft but they won't change it.
This is why I am looking now for a "out of the Box" approach to change the time from 24:00:00 to 23:59:59 inside of Dynamics without customizing a lot. Do you have an Idea of how this could be accomplished?
Hi Dominic,
I can just repro the issue if I use 24:00:00 in the time for Date time nodes. Do you usually get Camt054C with 24:00:00 as date time?
When i use other alternatives (e.g. 08:00:00 , 20:00:00) it works fine.
Hi Alireza,
I tried to follow your guideance but still there is this error which leads to the date and time format :-(
If I change the XML CAMT.054 File and change the 24:00:00 to 23:59:59 it works but it does not accept 24:00:00 but the bank also does not want to change this format for us.
Hi Dominic_23,
There is nothing with date format here, if you use the provided format in your Camt054 file. Please check that if you use correct setup on your GER config and Customer payment method.
GER Config - I have tested with version 85.27 in standard and the provided date format and it works fine.
Check if Payment model mapping to destination ISO20022 has "Default"
Customer method of payment. Check if bank account number that exists in the file is the same that you have it on your method of payment.
The provided error message is not clear enough. Please check the setup in D35FO and the Camt054 file and try to import the file again.
#1
André Arnaud de Cal...
294,081
Super User 2025 Season 1
#2
Martin Dráb
232,860
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
