Decimals in text value

ECEC Member Posts: 56
Hi All.

Help needed.

I'm importing some text values through a dataport. But when it's imported two decimals are added to the value. Eg. text value 10000 (the last to digits are decimals), that is the correct value should be 100,00 but Navision insert the value as 10000 and then ads the ,00 (the value now being 10000,00, instead of the correct 100,00).

Anyone know how to solve this issue?

/EC

Answers

  • krikikriki Member, Moderator Posts: 9,118
    In the "OnAfterImportRecord"-trigger, divide the value by 100.
    "The Decimal" := "The Decimal" / 100;
    
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • ECEC Member Posts: 56
    Yeah, my solution too. I just thought there were som built-in mechanism for handling this.

    Thanks anyway.

    /EC
Sign In or Register to comment.