Import from excel using RTC

adyturn
adyturn Member Posts: 11
edited 2011-07-18 in NAV Three Tier
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 ](*,)

Comments

  • rhpnt
    rhpnt Member Posts: 688
    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
    adyturn Member Posts: 11
    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
    redhotmustang Member Posts: 91
    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.
    Redcodestudio: Web Development, FLASH & Webdesign (and a little NAV, in the future)

Categories