Skip to main content

Notifications

Microsoft Dynamics CRM forum
Unanswered

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

Posted on by 2
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
  • Guido Preite Profile Picture
    Guido Preite 54,005 Super User on at
    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

Quick Links

Upcoming TechTalk: Copilot Capabilities…

Review the Copilot features that are currently available in Dynamics 365 Finance…

Demystifying Copilot: Service Edition with Sundar Raghavan

Sundar answers more questions about Copilot for Service...

Dynamics 365 Business Central vs Finance and SCM

Take a look at the key differences between Business Central and…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,414 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,394 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Featured topics

Product updates

Dynamics 365 release plans