Ever want to, for example, change a Dynamics GP address field to blank using eOne SmartConnect? If you try to set it to blank, you’ll find it comes back unchanged (at least up through GP version 2010).

eOneLogo

The trick was published by David Musgrave, talking about the eConnect layer that underlies SmartConnect, in this blog post. David is one of the superstars in the Dynamics GP world.

Instead of setting the field to blank, set it to
[xml]
<![CDATA[ ]]>
[/xml]

For example, in the data source, use something like

[sql]
SELECT CASE WHEN StreetAddress=” THEN ‘<![CDATA[ ]]>’ ELSE StreetAddress END AS GPAddress
[/sql]

Hope this helps someone! Dave’s post is not easy to find when searching on SmartConnect; maybe this will be easier for someone to find.

Leave a Reply

Your email address will not be published. Required fields are marked *

 characters available