Skip to main content

Posts

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

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/