Microsoft Dynamics 365 Blog

Swiss LSV Collection Authentication Report 

2 min read

The Lastschrift Verfahren (LSV)—or direct debit—electronic payment method now includes IBAN. As a result, the debit authorization document has changed. Swiss versions of Microsoft Dynamics NAV 5.0 SP1 and Microsoft Dynamics NAV 2009 R2 both contain a report, 3010836 LSV Collection Authorization, that handles this, but the report does not include the new IBAN number…Read more

0 Comments

Style Sheet Tool Extended 

6 min read

For those that have not used this before, the Style Sheet Tool is a free code sample used as an addition to standard Dynamics NAV application, for enhancing send-to Word functionality on Dynamics NAV by allowing simple and user-friendly style sheet customization. After lots of feedback form partners, I have added an extra dimension to this…Read more

0 Comments

Export of Pictures using Send-To MS Word/Excel functionality 

2 min read

With release of update 2 for NAV 5.0 SP1, the client now supports exporting picture box using style sheets (send-to Word/Excel) functionality. Both Client and style sheets have been modified to align with this change. If you don’t normally have picture fields on the form you’re exporting, you would add the field through codeunit 403, where additional data…Read more

0 Comments

How would I use RIM and Style Sheet Tool to handle change of Tax Number (OiB) in Croatia (Part 1 of 3) 

2 min read

Here’s the problem… Tax number for all companies is being changed in Croatia. This means a lot of hassle collecting new tax numbers from your customers, vendors and contact to ensure seamless opereation when it becomes mandatory to use. Specially, tax reporting for December needs to be done using old tax number and you need…Read more

0 Comments

Style Sheet Tool 2.0 now available 

<1 min read

A new version of the Style Sheet Tool for Microsoft Dynamics NAV is now available. This will also support Microsoft Dynamics NAV 2009 and our upcoming SP1 release. Please find it here: CustomerSource: https://mbs.microsoft.com/customersource/downloads/servicepacks/NAVStyleSheetTool PartnerSource: https://mbs.microsoft.com/partnersource/deployment/resources/supplements/NAVStyleSheetTool Thanks to Robert Miller for making this happen /Claus…Read more

0 Comments

Dynamics NAV, customizing style sheets for export to MS Excel 

1 min read

A while a go we posted a blog decribing how to make some basic customizations to style sheets used for export to Excel. http://blogs.msdn.com/nav/archive/2009/02/18/customizing-style-sheets-for-ms-excel.aspx This is an update to that blog. You can download updated sample objects from the link below In addition to changes described there (customizing font styles, conditional formatting and adding totals), this will…Read more

0 Comments

Customizing style sheets for MS Excel 

6 min read

As of version 5.0, Dynamics NAV introduced the option to export forms to MS Office (Word or Excel). Data presented on the form are exported in an xml, formatted using style sheets then sent to Word/Excel/Other programs A Style Sheet tool for Dynamics NAV has later been released to help partners create custom style sheets for…Read more

0 Comments

Dynamics NAV 2009 and MS Office Integration, send-to Excel and Word 

1 min read

This blog describes changes in office integration feature, send-to Excel and Word, when using RTC client in NAV 2009.  Send-to menu option on RTC client is typically located in menu, under Actions – Send to option. Shortcuts for this functionality is added, but unlike version 5.0, only send -to Word and Excel options are available. To export any…Read more

0 Comments

Dynamics NAV and export to Excel: Export dates as true excel dates 

4 min read

When running Send-to Excel functionality and exporting data to MS Excel using style sheets, all data exported form NAV is formatted as either numbers or strings. That also includes dates, that are exported as strings and not formatted as true dates in excel. As of update 1 for NAV 5.0 SP1, data.xml generated when running export to excel…Read more

0 Comments

Dynamics NAV 5.0 SP1 and export to Excel 

1 min read

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…Read more

0 Comments