Skip to main content


Showing posts from October, 2012

Conditional Colouring in NAV 2013 Pages

Hi all, As we were facing problem in Role Tailored client till NAV 2009 R2 about the colors. Customer wanted conditional coloring of rows based on some condition but was not possible in Role Tailored Client. With NAV 2013 Microsoft have come up with a level of Conditional coloring  yeah still have some limitations. The number of colors that are supported are fixed. Let's see how is it there - I was just checking pages in NAV 2013 and seen this. If you remember a property of Field in Page i.e StyleExpr which used to have value True or False is now have been changed and can take variables as value. Just have a look in Page Customer Ledger Entries, Field - "Document No." . Below is the property for the field. So the property have value StyleTxt which sets onAftergetrecord() and get value from function setstyle as shown below. Then i navigate to Table 21 Cust. Ledger Entry for the function definition and below is the code written in the function

Error 47-1 During Export Objects as Text

Hi all, Sometime we face an error message while exporting objects as Text file, but when we try to export as .fob it works fine. Today i require to compare some object so i needed them in text file, when i tried to export as text i get below listed error. There are errors in the text conversation (text no. 165-205 does not exist in the .stx file). Internal error: 47-1 Reason of Error - The reason of the error is due to objects version conflict. The objects which i was trying to export as text file are of higher version and were in the older version of database. In my case the objects were from NAV 2009 SP1 and were in NAV 5 SP1. Resolution of Error - 1) Export the objects into .fob format. 2) Create a new temporary database in new version. 3) Import the exported objects into new created database. 4) export objects into text file. Regards, Saurav Dhyani

Run XMLPORT in Navision Before NAV 2013

Hi all, For Running a XML PORT in Navision Before NAV 2013, we can do that via a codeunit. Below is the sample of execution of Xml Port via a codeunit. Variables in Codeunit Name                                 DataType _Filev                                 File _DatafileOutstream                 OutStream Selection                                 Integer _DatafileInstream                 InStream

Hyper Link to a Page from a Report.

Hi all, As we see in last post how to expand-collapse in Navision RTC report . In the same report we will now try to add Hyperlink to the item Number. So that on clicking on the item number in the report, the item card will get open in edit mode. Let's see how to do it. Taking Report 1001 (Inventory Valuation) Report for Demo. 1) Open Microsoft Dynamics NAV Developer Environment. 2) Design Report 1001. 3) In C/AL Global add a new variable.      a) Name - ItemRecRef, Datatype - RecordRef. 4) Now i will add code in the data item to get item. 5) Goto Pre-data of Item and write following line of code.       a) ItemRecRef.OPEN(27); 6) Goto OnAfterGetRecord of Value Entry add following line of code.       a) ItemRecRef.SETPOSITION(Item.GETPOSITION); 7) Add a column in Report Desing for Item Table.       a) DataSource - FORMAT(ItemRecRef.RECORDID,0,10), Name - Item_Rec_Ref_Val 8) Now open the Report Layout in Visual Studio. 9) Goto TextBox Properties of =F

NAV 2013 Query

Hi all, Let's try to create a new query (new object released with NAV 2013) and use that query in a chart. For example suppose i want to display the Top 10 item by sales in a period say last 10 days. I will open the developer environment of NAV 2013 and start creating a query. As i require Top 10 items my data items will be Value Entry and Item . From these tables i will require Item Sales Amount (Actual) and Item Description to display on the chart. Below is the screen shot of how my query look like. As i require Total of Sales Amount Actual i added the method type as Totals and Method as SUM  and i grouped the Query by Item No. For Filtering based on date i used posting date from Value entry table . Let's try to run the query and see the output. As you can see in the output of the query above that it returns the First 1000 Rows which is not required in my case. So let's go back to query and go to query properties  Here as shown below i w

Zetadocs Express For NAV 2013

Hi all, Zetadocs Express has been updated for use with the Microsoft Dynamics NAV 2013 Windows client. Zetadocs Express for Microsoft Dynamics NAV is available for the following NAV Databases:   AU-NZ, NA, DK, FR, DE, IN, IE, IT, NL, ES, GB, W1, AT*, BE*, FI, NO*, PT*, SE, CH* Zetadocs for NAV 2013 include following Features - Document Drag & Drop -  This action automatically uploads the document to Microsoft SharePoint Online and links it to the Microsoft Dynamics NAV Record. Choice of Client -   Users can store, view and access documents from the Microsoft Dynamics NAV RoleTailored Client or from Microsoft SharePoint Online . Basic Document Approval -   Allows the approval status of documents to be seen within Microsoft Dynamics NAV. Approving managers are prompted by email, as with any Microsoft SharePoint workflow* Save & Send PDF -   Enables users to email a report as a PDF attachment, filing a copy of the report automatically in Microsoft SharePoint Onlin

Expand - Collapse Feature in NAV RTC Reports

Hi all, This feature is there from NAV 2009, sorry i am late but still most of us don't know about this feature. Below is the demonstration of how to do it in NAV 2013. I have taken a standard report "Inventory Valuation"  for the Demo Purpose. Below is the standard report output - Now i went to Microsoft Dynamics NAV 2013 Development Environment, and designed the report. Opened the layout of the report. Now i selected the body part of the report and went to group properties. I just changed some properties in the Visibility tab of the group, as shown below. And here is the output of the report after i saved and executed it again. So it was nice and easy to do expand and collapse in RTC Report. Regards, Saurav Dhyani

NAV 2013 First Error with License

Hi all, After installing NAV 2013 RTC client doesn't get connected and throws the below error message. Your program license does not permit you to run this version of the Microsoft Dynamics NAV Development Environment.  Contact your system administrator to upgrade your license.  Reason For Error I got this error because i have my old developer license (Developer License For NAV 2009 R2) uploaded on SQL Server. The license does not support NAV 2013. Resolution There   are two ways to resolve the error - 1) For temporary solution import demo License file on the SQL Server that as shipped with NAV 2013 DVD. 2) For Permanent Soultion download the latest license file from Microsoft VOICE and upload that on SQL Server. Regards, Saurav Dhyani