Dynamics NAV 5.0 SP1 and export to Excel

  • Article

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

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.