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.