Back

Fixed Assets Class ID Description is not updating

Published: Nov 08, 2012
Post Author Written by David Youngquist

Running a map that creates Fixed Asset Class IDs.  The map is updating the Class ID, but is not updating the Class ID Description.


The Microsoft eConnect documentation has the parameter name spelled incorrectly. All their documentation lists the parameter name as ASSETCLASSIDDESCR. The actual name should be ASSETCLASSIDDESC. Run the following script in SQL server management studio.

update SmartConnect..Field set TechnicalName='ASSETCLASSIDDESC' where Node='taCreateAssetClassID' and DisplayName='Asset Class Description'

This will update the field to the correct value and allow the SmartConnect map to import the description.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.