Browse by Tags

  • Blog Post: Swiss LSV Collection Authentication Report

    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...
  • Blog Post: Style Sheet Tool Extended

    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...
  • Blog Post: Export of Pictures using Send-To MS Word/Excel functionality

    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...
  • Blog Post: How would I use RIM and Style Sheet Tool to handle change of Tax Number (OiB) in Croatia (Part 3 of 3)

    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 the data with...
  • Blog Post: How would I use RIM and Style Sheet Tool to handle change of Tax Number (OiB) in Croatia (Part 2 of 3)

    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: ...
  • Blog Post: How would I use RIM and Style Sheet Tool to handle change of Tax Number (OiB) in Croatia (Part 1 of 3)

    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...
  • Blog Post: Style Sheet Tool 2.0 now available

    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...
  • Blog Post: Dynamics NAV, customizing style sheets for export to MS Excel

    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...
  • Blog Post: Customizing style sheets for MS Excel

    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...
  • Blog Post: Dynamics NAV 2009 and MS Office Integration, send-to Excel and Word

    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...
  • Blog Post: Dynamics NAV and export to Excel: Export dates as true excel dates

    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...
  • Blog Post: Dynamics NAV 5.0 SP1 and export to Excel

    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...
  • Blog Post: Dynamics NAV 5.0 and Style Sheet issues, decimals exported as text

    When using Send-to Excel option from NAV, decimals are exported as texts if Digit grouping symbol (Control Panel - Regional and Language Options) is a ' ' (whitespace). NAV uses ANSI 160 code character for space, which is not a space in ascii code table (normally used by windows applications). Consequently...
  • Blog Post: Dynamics NAV 5.0 and Style Sheet issues, issue with '/' character in customer(vendor) name

    When running forms like Customer (Vendor) Ledger Entries and Apply Customer(Vendor) Ledger Entries, and selecting: send-to Excel, the following error occurs if customer (vendor) name contains character '/': Problems came up in the following areas during load: Workbook setting .... To correct...
  • Blog Post: Dynamics NAV 5.0 and style sheet issues, tab captions with local characters

    Form tab captions that contain country specific characters (for example, Å in Swedish) will be displayed differently in MS Word/Excel, when using local language version of MS Office. For example, if running Nav 5.0 SE version and Customer card the first tab on the card (General) will be displayed as...
  • Blog Post: Dynamics NAV 5.0 and Style Sheet issues

    This post is starting of a summary of style sheet issues reported in Dynamics NAV 5.0 when using send-to Excel/Word functionality, and attempt to provide workaround suggestions for as many of these issues as possible. Most issues are related to regional settings and use of decimal separator and or...
Page 1 of 1 (16 items)