Hello,
I have an Integration that imports a GP Intercompany entry from a .csv file. There is a field called DISTREF which, logically enough, is mapped to the Distribution Reference field. The field consists of the first 10 characters of a vendor name, followed by a tilde (~), followed by up to 19 characters of other descriptive information.
The problem I am having is that the character following the tilde is not making it into the journal entry. So, for example, if DISTREF in the .csv file is "USAIRWAY~Airfare to Seattle", when I look at the entry after it has been integrated into GP it reads "USAIRWAY~irfare to Seattle". The "A" of "Airfare" is missing. I suspect it has to do with how IM is interpreting the tilde.
I can get the data changed to use a different character, but I was hoping someone could enlighten me as to other potential problem characters. I don't want to use an asterisk (*) because it seems that a lot of vendor names use this character (this is credit card data, in case you were wondering). Some other characters I'm considering are ">", ";", "+", and "/". Would appreciate any advice as to whether any of these characters are problematic. I'd rather not do this by trial and error, because it takes too long to get this kind of change done, unfortunately. Thanks much!
