Dynamics NAV 5.0 SP1 and export to Excel

Dynamics NAV 5.0 SP1 and export to Excel

  • Comments 0

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

Leave a Comment
  • Please add 8 and 3 and type the answer here:
  • Post