NAV/CRM Connector If function

yukon

Hi Team,

I wrote the "if statement" in nav/crm connector map. My problem is data updated with blank when condition is "true". I don't want to update the CRM value if condition is true. How may i do it? :-k

Here is code NAV/CRM Connector Mapping

=If(EqualTo(Address, ""), "", Address)

My Logic

If (Address = "")
    Stay CRM Address     (now update with blank)
ELSE
    Update with NAV value

Regards,
Yukon

Stark

Hi Yukon,
Not sure if you can do that in Connector mapping.
What I would do:
- Create new field in CRM "NAV Address"
- Use straight mapping "NAV Address"= Address
- Create in CRM workflow to modify "Address" when "NAV Address" is changed and new value not blank.

Cheers,
Konstantin

yukon

Hi Konstantin,

Thanks for your reply and idea. I changed the code

   =If(EqualTo(Description, ""), DefaultValue(), Description)    (Item Cate. Sycn - Customization)

above code is working on connector (FP 5 - B1.5.228.1 1/28/2011). But this testing is between NAV-R2 and CRM4.0.
So i changed Customer mapping but i have no lucky

   =If(EqualTo(Address, ""), DefaultValue(), Address)    Connector V2.0442.2 (NAV-R2 - CRM2011)

Humm! Why don't work on latest version? ](*,) ](*,) ](*,) ...

Regards,
Yukon

Stark

Not really sure but as far as I know, DefaultValue() always return value just default for particular type of data.

cheers,
Konstantin