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
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
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
In part 1 of this series, I described the problem of the tax numbers in Croatia being changed. In part 2, I described how to export data that you need from NAV and use that data to request new tax numbers from customers, vendors sand contacts. In this post, I will describe how to update…Read more
In my previous post, I described the problem of the tax numbers in Croatia being changed. In this post, I will describe the first steps to solve the problem. In part 3, I will describe what to do when you receive the new tax numbers. The business process from customer perspective looks like this: Export…Read more
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
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
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
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
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
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
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