Nav developer: Dynamics NAV 5.0 SP1 and export to Excel

[Blog bot]

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:whentest="@subtype != 'number'">


and replace the line with


<xsl:whentest="@datatype != 'Decimal'">





Then locate the following line :


<xsl:whentest="@subtype = 'number'">


and replace the line with


<xsl:whentest="@datatype = 'Decimal'">





Jasminka Vukovic


Microsoft Dynamics NO



Microsoft Customer Service and Support (CSS) EMEA


These postings are provided "AS IS" with no warranties and confer no rights. You assume all risk for your use.












Читать дальше