Friday, October 19, 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.


so i guess its one of the cool feature that every customer of every partner wanted. So lets use it with customer database.

Here is how the customer ledger entry page look like.


You can see lines in Red Color based on condition.

Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/

Wednesday, October 17, 2012

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
http://saurav-nav.blogspot.com/

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


Wednesday, October 10, 2012

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 =Fields!Value_Entry__Item_No__.Value.
10) Select the Action and select Go to URL.

11)Open the expression and change the existing code to this.
 ="DynamicsNAV:////runpage?page=30&mode=edit&bookmark="+FORMAT(Fields!Item_Rec_Ref_Val.Value)
12) The windows should look like this.



Execute the report.

once you click the item number it will open item card in edit mode (as command in hyperlink).


All this is possible will all version of NAVISION Role Tailored Client Reports.

Regards,
Saurav Dhyani

Tuesday, October 9, 2012

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 will set the property TopNumberofRows to 10.




Then the query will show the Top 10 Records from the database as shown below.


So we are done with query. Now lets go to role tailored client and start creating chart using this query object.

As you can see that the chart accept only two data source table & query.

I started creating a chart. Below are the field values that i set -

1) ID - Test.
2) Name - Item By Sales - Last 10 Days
3) Source Type - Query.
4) Source ID - 50001.
6) Filters - Posting Date = w-10D..w (as i want to show the top sales in last 10 days)
7) Required Measure - Sum_Sales_Amount_Actual (SUM (aggregation), Graph type (Column) and Caption sales Amount).
8)Y axis Caption - sales amount.
9)X Axis Item No or Item Description.

Here is the image of how the chart in chart builder look like.


Now i will add this chart to role center page and lets see what we get in output.

Here is the output...


The whole process is also available in below video.



Regards,
Saurav Dhyani

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 Online.



Download Zetadocs For NAV 2013 From Partner Source.

Regards,
Saurav Dhyani
http://saurav-nav.blogspot.in/

Monday, October 8, 2012

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
http://saurav-nav.blogspot.com/

Wednesday, October 3, 2012

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
http://saurav-nav.blogspot.com/