You’re offline. This is a read only version of the page.
580
Hi all,
I have a sync problem between a Nav boolean field and the CRM. I use the fonction
If(condition,trueValue,falseValue) in the connector mapping.
I get a validation Error: Assignment of Int32 to Bolean may result in an either a loss of precision or an OverflowException at runtime.
Assigning a string value to a non-string value may result in a formatExcwption at runtime if the string is not a compatible format.
This is what I use: =if(Assembly BOM, 1, 0). I tried it with "True" "False" and I get the same errors.
*This post is locked for comments
Instead of True/False try using Yes/No
I used the Contains (Text, texttofind) : Boolean function, but that also did not work.
Exemple: =Contains(ShowOnWeb, "true")
Hi Fritz,
It looks like the issue is of field type. You can verify the field datatype in the webservice and as well map that nav field to some text field in CRM and see what data is coming from NAV.
I've tried it with other field other than Assembly BOM, and I get the same error.
I have a Two option box in my CRM. My field in Nav is a bloean.
I put in the connector the following statement:
=if(EqualTo(License, "No"),0,1)
I then get a Validation error: Assigment of an Int32 to Boolean may result in loss of precision or an overflowexeption.
If you are using Assembly BOM from item card, then please remember it is not a normal field it is a flowfield and so you have to CALCFIELDS on navision to get the value.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (