web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Electronic reporting i...
Finance | Project Operations, Human Resources, ...
Answered

Electronic reporting import xml with empty amount node

(1) ShareShare
ReportReport
Posted on by CU31070722-0 2
Hi 
I need to import an xml with electronic reporting,
but it looks like it cant handel empty.
Error: parsing error in the format component 'File/XXXX/CrossRateUSD/CrossRateUSD': Input string was not in a correct format..
 
<Currency>
    <Unit>1</Unit>
    <Isim>ABD DOLARI</Isim>
    <CurrencyName>US DOLLAR</CurrencyName>
    <exch>33.12244</exch>
    <CrossRateUSD/>
    <CrossRateOther/>
</Currency>
but it is not mandatory
 
 
I have the same question (0)
  • Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    Hi,
    You can check the following link about number and currency formats:
    Format a number or currency field - Microsoft Support
    Best Regards,
    Hana
  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 14,839 Super User 2026 Season 1 on at
    Hi Dick,
    You can create a string node and then if it is required, use NUMBERFORMAT formular to have the numeric format that you want.
     
  • Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Hi,
    There have been discussions about similar issues on the forums before, and you can refer to this old thread: https://community.dynamics.com/forums/thread/details/?threadid=9befa387-8b6e-ee11-8df0-6045bdeb8873. Do you have anything in Visibility expression?
    Best regards,
    Kevin
  • Suggested answer
    CU31070722-0 Profile Picture
    CU31070722-0 2 on at
    it took me to match time, i changed the field to string and on the mapping i used this
    if( @.CrossRateUSD.CrossRateUSD = "", value("0"),VALUE (@.CrossRateUSD.CrossRateUSD))
     
  • Verified answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 14,839 Super User 2026 Season 1 on at
    Is the issue is resolved?
    It is correct to you String type for CrossRateUSD.
    Ref to the used formular, you use the value of @.CrossRateUSD.CrossRateUSD if it is not empty.
    As it is mentioned, you can change the format of node by transformation field:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 527 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 473

#3
Adis Profile Picture

Adis 284 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans