Import from excel using RTC

adyturn

Hope someone can put me out of my misery.
i am import an excel sheet into a G/L journal.
i am using the standard excel buffer table and functions to read the sheet.
the problem is, i can import into the Document No. field fine, but when importing into the Account No., it decides to insert a decimal character.
the two fields are both formated as text in excel.

Document No. - 1234
Account No. - 2340

any ideas ](*,)

rhpnt

An integer can become a decimal number only by explicit or implicit conversion. So, if you didn't do it explicitly (at least you don't remember) then it is done implicitly (destination field format, variable type, coding,...). Check your code again.

adyturn

there is no difference in code when importing the two fields.
it is using standard functionality.
if I check the Excel Buffer table, then it has already converted it.

redhotmustang

I experienced the same problem. I had to get the value from the excel buffer table and then copy the string until the decimal separator.