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 :
Then locate the following line :
and replace the line with
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.