This is by design.
If you wish to clear a value, send a single character string to the field.
In a map transform prior to the Customer connector, have a formula such as....
IIf(%Address2 = "", " ", %Address2)
IIf(%Address2 = "", " ", %Address2)
Perfect. This does exactly what I want it to do. Thank you.
Great fast help
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
We have a transform that updates customer records from another database. If Address line 2 becomes null in the other database, Iman/Sage does not see this as a change and therefore does not update the customer record accordingly. This causes issues since the address information from the customer appears to be overwriting the information on the order. Unless I am missing something in the transform to force the information from the sales order.