Hi Experts...
I created Number Series for Purchase Order.
The No on the Purchase order shows me like 0000000000000001
I want to format this No. and want to show like 1.
Is there any property by setting this its converts..
Thanks in Advance..
And Wishing you a Very Happy New Year..
Thankx...
JAYESH PATEL
0
Comments
"I want to show Like"........ Show Where? in a report on the form?
How about converting it to text & removing all the leading zero's.
-for a report
I guess your prepared to make a lot of PO's
0000000000000001 to 9999999999999999
15 zeros brings you into the Quadrillion zone
http://www.BiloBeauty.com
http://www.autismspeaks.org
It is possible to conver ?
from 00000000001 to 1 ??
Take a look at the EVALUATE function. It's what you're looking for.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
Trivia note: Even if you enter a new po every second it will take you 31,645,570 years to use up all your po numbers.
Give or take
http://www.BiloBeauty.com
http://www.autismspeaks.org
newstr := delchr('010101010101','=','0');
....not really good....
you must delete only useless zeroes...you have to read the code char by char (from left to right obviously) deleting zeroes until you find a character <> '0'...
at this point if you want to mantain the same fieldtype is easier to evaluate and reformat the code....
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog
and it will be better... ;-)
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
"Never memorize what you can easily find in a book".....Or Mibuso
My Blog