News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... Cannot convert the lit...

Customer experience | Sales, Customer Insights,...

Unanswered

Cannot convert the literal to the expected type 'Edm.Decimal through OData

(1) Share

Report

Report

Posted on by TD-24050853-0

9

Hi everyone,

Can you help me with the issue where I can't put an amount more than 10 million with decimals in the Unit Price field through OData?

Error message I receive from the OData : Cannot convert the literal '13657080.28' to the expected type 'Edm.Decimal

If I send the same amount without decimals it is working, but once I add decimals for an amount greater than 10 million it fails.

If it put it manually in the front-end it's working fine.

13657080.28 -> Not working

13657080 -> Working

65708.02 -> working

Thank you in advance.

Talha

All responses Img

All responses (2)

Answers Img

Answers (0)

Vasilena Bacheva 19 on at

Like (0)

Report

Cannot convert the literal to the expected type 'Edm.Decimal through OData

Hi Talha,

Did you resolve this issue? I'm facing the same one and would appreciate if you can share a relevant solution.

Thanks
Guido Preite 54,077 Moderator on at

Like (0)

Report

Cannot convert the literal to the expected type 'Edm.Decimal through OData

did you check the range for that field? first thing I will check if the value you want to insert is outside the range

Also if you can write the exact OData query you are trying to run it will be useful

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard

#1

André Arnaud de Cal... 294,095 Super User 2025 Season 1

#2

Martin Dráb 232,866 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans