NAV text field is seen as a number in Jet Essentials

In NAV 2009 we are using the following format for purchase- and sales orders: 12.XXXX (purchase orders) and 33.XXXX (and sometimes: 33.XXXX-Y. F. ex.: 33.1234-1) for sales orders. XXXX and Y being numbers from 0-9.
When including the No. field to a table, using the Table Builder, it is automatilcally interpreted as a number by Excel which leads to orders ending on a 0 to be truncated (33.1230 becomes 33.123)

Using =NP("Formaat";[[#Deze rij];[No.]];"##.##########") will create a correct text in an additional collumn in all cases but those where ending zeroes have been truncated and are thus missing. (Unfortunately commands in Jet are translated to Dutch!)

Is there a way to ensure that NAV text fields which could be interpreted as numbers, stays text when included by Jet Essentials?

Thanks in advance

Jan Schledermann

Jet Reports Historic Posts November 01, 2013 15:42 Official comment

Hi Jan,

I think you need to use 0 instead of # in your format string in order for it to include all the digits you want. Does something like this work?

=NP("Formaat";[[#Deze rij];[No.]];"##.0000000000")

Regards,
Hughes

Jet Reports Historic Posts November 04, 2013 13:13

Hi Hughes,

Thanks a lot.

That did the trick: =NP("Formaat";[[#Deze rij];[No.]];"##.0000")

:D

Greetings
Jan

NAV text field is seen as a number in Jet Essentials

2 comments