Electronic reporting import xml with empty amount node

(1) Share

Report

Posted on by CU31070722-0

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>

but it is not mandatory

I have the same question (0)

All responses (5)

Answers (1)

Hana Xue Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,
You can check the following link about number and currency formats:
Format a number or currency field - Microsoft Support
Best Regards,
Hana

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,839 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Kevin Xia Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

CU31070722-0 2 on at

Like (0)

Report
Copy link

Link copied!

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))

Was this reply helpful? Yes No
Verified answer

Alireza Eshaghzadeh 14,839 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No

Join the conversation

Community site session details

Electronic reporting import xml with empty amount node

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Congratulations to our 2025 Community Spotlights

Congratulations to the December Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Electronic reporting import xml with empty amount node

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Congratulations to our 2025 Community Spotlights

Congratulations to the December Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates