A number of issues previously reported when running with Dynamics NAV 5.0 and using send-to Excel functionality, are now corrected. These issues include (among others): decimals exported as text, Item/Customer numbers exported as decimals, dates exported as decimals.
To implement correction, update with 5.0 SP1, update 1 (KB 956161, build 27191), use default style sheets included in SP1, and make the following change to default style sheet NavisionExportToExcel.xslt:
Open the style sheet file in notepad, default file is NavisionFormToExcel, placed in Stylesheet folder of the Client folder.
Browse to the following line :
<
xsl:when test=“@subtype != ‘number’“>
and replace the line with
<
xsl:when test=“@datatype != ‘Decimal’“>
Then locate the following line :
<
xsl:when test=“@subtype = ‘number’“>
and replace the line with
<
xsl:when test=“@datatype = ‘Decimal’“>
Jasminka Vukovic (jvukovic)
Microsoft Dynamics NO
Microsoft Customer Service and Support (CSS) EMEA