mibuso.com
Home› NAV Three Tier
Options

Import from excel using RTC

adyturnadyturn 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

  • Options
    rhpntrhpnt 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.
  • Options
    adyturnadyturn 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.
  • Options
    redhotmustangredhotmustang 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)
Sign In or Register to comment.