Style Sheet Tool for Microsoft Dynamics NAV2013

The Style Sheet Tool for Microsoft Dynamics NAV2013 is available in Mibuso Downloads Section.
http://mibuso.com/dlinfo.asp?FileID=1543

The Style Sheet Tool for Microsoft Dynamics NAV2013 enhances the Style Sheet feature in Microsoft Dynamics NAV 2013 by allowing you to easily and without programming knowledge create and modify style sheets in Microsoft Office Word.

Changes to Style Sheet tool for NAV 2013.

1.Multi-multiline support is added, so it is now possible to add several multiline records to the style sheet. Note though that records can not be indented, but added sequentially.

2.Setup page is modified to add Open/Save/Send options.

3.In NAV 2009, codeunit 50000 was released for automatic integration of the Style Sheet functionality with pages. Pages were then exported in xml format and modified by running codeunit 50000, to add style sheet actions.

This no longer works for NAV2013, as export /import of objects in xml format is no longer an option. Hence, adding Style Sheet Action (button) to each page must be done manually.

Follow the example below when adding the style sheet action to a page:

i. Add the action to the action designer (under appropriate group) with following properties:

Expanded Type SubType Name Caption
0 Action <Action680> Style Sheets

ii. OnAction trigger should contain following line:

StyleSheetDataMgt.LoadStylesheetDataRTC(GETPOSITION,CURRENTKEY,PAGE::"");

where StyleSheetDataMgt is a variable of type codeunit, 682 (Style Sheet Data Management). 

Fixed No. of Lines in NAV 2013 RTC Reports

The Objectives of this video are:

 1.      Review a typical NAV 2013 reports preview.

 2.      Modify the report to show fixed No. of lines

 3.      Run the report to review the changes.

Please note that I have used Report 205 = Order Confirmation report in this demo.

The functions created in Visual Studio are

public Shared DocumentNo as Object
public Shared FixedLenth as integer
public Shared prevOutputNo as integer

Public Function SetDocLength(NewData as boolean,Group as object,Outputno as integer )
  If (NOT NewData) AND (prevOutputNo = OutputNo) AND (DocumentNo = Group) Then
      FixedLenth = FixedLenth + 1
  ELSE
      FixedLenth = 0
  End If
 DocumentNo = Group
 prevOutputNo = OutputNo
End Function

Public Function GetDocLength( ) As Integer
  Return FixedLenth
End Function

Expression Added in Invisible text box is

=Code.SetDocLength((Iif(Fields!Type_SalesLine.Value = " ", true, false)),Fields!No_SalesHeader.Value,Fields!OutputNo.Value)


You can also watch video at

Post by Mohana - Dynamics NAV.

HTML Tags in Microsoft Dynamics NAV2013 Reports

This video will show you how to use HTML tags in Microsoft Dynamics NAV2013 reports which will reduce lot of time in customizing each report.

The file that you are trying to create cannot be created error in NAV2013

I was trying to create .bat file using C/AL code in NAV2013.

I got below error message when I ran the code in NAV2013 RTC

Microsoft Dynamics NAV
---------------------------

The file that you are trying to create cannot be created. The destination file has an extension that may be blocked. Contact your system administrator.
---------------------------
OK
---------------------------

I was able to create the file using NAV2009R2 Classic client but not able to create in NAV2013 RTC.

I posted my problem in Microsoft Dynamics Community.

Thanks to Roberto Stefanetti who helped me in solving my problem.


There is a parameter in Custom Settings File called ClientServicesProhibitedFileTypes which will not allow you to create files with extensions you mentioned here.

We cannot create files with below extensions using RTC now.

"ade;adp;app;asp;bat;bas;chm;cmd;com;cpl;csh;exe;fxp;gadget;hlp;hta;inf;ins;isp;its;js;jse;ksh;lnk;mad;maf;mag;mam;maq;mar;mas;mat;mau;mav;maw;mda;mdb;mde;mdt;mdw;mdz;msc;msi;msp;mst;ops;pcd;pif;prf;prg;pst;reg;scf;scr;sct;shb;shs;url;vb;vbe;vbs;vsmacros;vss;vst;vsw;ws;wsc;wsf;wsh"

I removed bat value from this property and restarted the service.

Now I am able to Create .bat file using NAV2013 RTC.

How to include Dimensions in Conf. Package Table Fields while using Rapid Start Services in NAV2013

You must have seen my blog video "How to Import and Post Opening Balances along with Dimensions in NAV2013 using Rapid Start Services" here.
http://mohana-dynamicsnav.blogspot.in/2013/04/how-to-import-and-post-opening-balances.html

You can see the Dimensions in Conf. Package tables fields but you cant see Dimensions as fields in Newly created package.

How to add the Dimensions in newly created package table fields?

Microsoft awards top-performing partners at Microsoft Worldwide Partner Conference

GAC Business Solutions named number one provider of Microsoft Dynamics NAV in Netherlands.

At the World Partner Conference, Microsoft voted GAC as number one provider of Microsoft Dynamics NAV in Netherlands. This makes the software club Oirschot to five percent of the world's top suppliers of business software based on Microsoft Dynamics NAV. GAC is also admitted to the 2013 President's Club for Microsoft Dynamics.

This shows once again that the GAC 'Growing Together' strategy works. Part of admission to the President's Club is to achieve growth through new customers to attract and help existing customers grow with the deployment of innovative solutions.

"We are proud that we are also counted in 2013 to the President's Club for Microsoft" says Erik van Driel, Director of GAC Business Solutions. "Our growth-oriented approach works, partners appreciate the focus on industry solutions and Microsoft puts us in the top five percent of top performing suppliers Dynamics NAV in the world. A result of the enthusiastic and dedicated efforts of the GAC staff. "

2013 President's Club
To be admitted to the 2013 President's Club for Microsoft Dynamics is an enterprise software company in possession of a Silver or Gold ERP Competency certification. Microsoft then look at the sales realized in which a breakdown is made between new business and sales to existing customers. These factors, some key business milestones, a consistently high level of customer satisfaction and an active role in the development of new technologies Microsoft is a ranking in partners. On the global top five percent of that ranking is membership of the President's Club awarded.

GAC shows with membership granted to a steady partner, who can boast high customer satisfaction and ensures high quality, technically advanced implementations of industry-specific enterprise software. That gives excellent growth opportunities for partners in the sectors manufacturing, wholesale, business services and healthcare.

Congratulations to our All 2013 Microsoft Dynamics President's Club and Inner Circle Members

a select group of Microsoft Dynamics partners were named to the Microsoft Dynamics Inner Circle and the Microsoft Dynamics President's Club. The Microsoft Dynamics Inner Circle represents an elite group of the most strategic Microsoft Dynamics partners from around the globe, with sales achievements that rank them in the highest echelon of the Microsoft Dynamics global network of partners. These partners are recognized for their exceptional overall company performance in delivering valuable solutions to Microsoft Dynamics customers. Microsoft Dynamics President's Club honors high-performing Microsoft Dynamics partners with a commitment to customers reflected in their business success and growth.

A list of the Microsoft WPC 2013 and Regional Partner award winners and finalists is available online at http://www.microsoft.com/en-us/news/download/presskits/partnernetwork/docs/DynamicsPartnerAwards.pdf

A list of the 2013 Microsoft Dynamics Inner Circle award winners is available online at http://www.microsoft.com/en-us/news/download/presskits/partnernetwork/docs/DynamicsInnerCircle.pdf

A list of the 2013 Microsoft Dynamics President's Club award winners can be found online at http://www.microsoft.com/en-us/news/download/presskits/partnernetwork/docs/DynamicsPresidentsClub.pdf

Service Tax – Reverse Charge for Microsoft Dynamics NAV 2013 - India

According to Notification No 15/2012-ST dated 17.03.2012, the proposed Reverse Charge Mechanism is made applicable from the 1st of July 2012, when Section 66B of the Finance Act, 1994 (Charge of Service Tax on and after Finance Act, 2012 - Exemption to small service providers) came into force.

Depending on the scenario, service tax must be paid by the service provider or the service receiver. As a result, when a reverse charge is made, this impacts the service tax liability of both provider and receiver. 

Please read the white paper that is included in this release to identify which areas of the Microsoft Dynamics NAV application logic those are impacted.

You can download the update here

https://mbs.microsoft.com/partnersource/support/selfsupport/taxupdates/msdnav2013reversecharge.htm