Special Characters

These special characters are supported for all journal-character fields for the online interface and batch import: !@#$%^&*()_-=+\|[]{}:;/?.><',".

During the import process, each special character is replaced with a three-digit encoded character, which can potentially increase field length by three times. For example, importing a business unit value of US&IN is converted to US%26IN during the encoding process, and the field length is increased from five to seven. The encoded value is decoded before insertion into target tables. Due to the encoding process, the spreadsheet import file layout field length should be increased.

After a ChartField is configured, you should replace the length of the corresponding field in the GL_EXCL_BATC file layouts to three times the size of the character’s original length. For example, if the length of ChartField1 is 12, then the ChartField1 length in the file layout should be 36 (12 x 3).

Note:

Files generated from JRNL1.xls or JRN1.xlsm, and JRN1_WS.xlsm must only be used with the corresponding process: GL_EXCL_BATC.