Skip to Content
Aug 27, 2020 at 02:02 PM

DTW - Unable to upload all products in Item Master


We are trying to upload items in SAP B1 through DTW, few items are giving the following errors:

CServiceData::SetPropertyValueString failed; Value too long in property 'SerialNum' of 'Item'65171

Invalid item name '24' in Enum 'BoYesNoEnum'. The valid names are: 'tNO'-'N', 'tYES'-'Y'65171

We have checked with the DTW template file, we haven't added anything in "SerialNum" field nor in any of the other similar "Serial" Based column in the template excel file.

If we removed the entire "SerialNum" column, we get error for some other columns next to it. Removing the columns keeps on repeating the same pattern.

Even tested by removing & hiding all the columns from the excel which has no details, than it shows error in active fields with values.

Kindly guide us with the appropriate solution.