Forum Discussion

rsacco's avatar
rsacco
New Contributor
3 years ago

Special Character/ number of characters impeding upload of subledger for a single item in a data set

We have come across an issue where a subledger has been loaded but is not picking up a singular item/line in the subledger. The item contains a number of commas and special characters in one of the t...
Data Sources
Workflow
TonyToniTone's avatar
TonyToniTone
Contributor II
3 years ago

A couple of things:

1.  Have you reviewed the Import Processing Log to see what Log Code was assigned to the line item not being picked up?  

2.  As Nidhi mentioned, remove special characters.  There is a snippet for this.  The StringHelper has other functions that may be useful in your case outside of this below function.  Give them a look.  

'Removes characters not valid for an XF name property
Return args.Value = StringHelper.RemoveInvalidNameCharacters(args.Value, False)