when using nav 3.7, DecimalPlaces for field "quantity" is correct (ex: 10).
then after upgrade to nav 4 sp3, i do not change the property of report (same property with previous nav).
why field "quantity" in report change to format 10.00?
if i change the property to 0:0, then i must change DecimalPlaces property of all report (1 by 1 field).
is it have default setting in nav?
can someone tell me..
thanks
For Unit Amount and Amount fileds there exists a setup but not for Quantity fields.
The fields are called "Amount Decimal Places" and "Unit-Amount Decimal Places".
For local currency go to G/L Setup.
For foreign currencies got to the currency table.
Please note that this does also affect the way numbers are displayed on screen.
This format is setup on a field in the "Auto Format Type" and "Auto Format Expression" Properties. In CU1 exists a function AutoFormatTranslate which handles this.
A quantity field usually has decimal places 0:5 (sometimes 0:6) setup on the table.
Just a wild guess:
Which build of NAV4.03 are you using? Maybe there exists a build which displays the decimal places incorrect?! Try to use the last available build (29821 as far as i know).
Comments
Try 0:2 for a minimum of 0 and a maximum of 2 (or 3, 4,5). If you don't want decimal places than change the property to 0:0
then after upgrade to nav 4 sp3, i do not change the property of report (same property with previous nav).
why field "quantity" in report change to format 10.00?
if i change the property to 0:0, then i must change DecimalPlaces property of all report (1 by 1 field).
is it have default setting in nav?
can someone tell me..
thanks
any one can help me to solve it?
is there any general setup for currency all report in navision 4?
The fields are called "Amount Decimal Places" and "Unit-Amount Decimal Places".
For local currency go to G/L Setup.
For foreign currencies got to the currency table.
Please note that this does also affect the way numbers are displayed on screen.
This format is setup on a field in the "Auto Format Type" and "Auto Format Expression" Properties. In CU1 exists a function AutoFormatTranslate which handles this.
A quantity field usually has decimal places 0:5 (sometimes 0:6) setup on the table.
Just a wild guess:
Which build of NAV4.03 are you using? Maybe there exists a build which displays the decimal places incorrect?! Try to use the last available build (29821 as far as i know).
FD Consulting