in this section you can find a nice post by NAV Team blog about “cached web services calls”:
In a service-oriented deployment, web services are used to extend NAV’s functionality and reach. Depending on how volatile this data is and the corresponding usage scheme, it is expected to be up-to-date within a pre-defined period of time (e.g. once a day).
When NAV is integrated with external services, then the user scenarios become dependent on the data and functions offered by such services. Eventually, there are different approaches through which the external data can be retrieved, stored and used.
Dynamic: either exposed by the external service itself or by a separate catalog that NAV can query.
Advantage: data is always up-to-date
Disadvantage: it requires constant connection to the data source.
Static: hard-coded in the database for the user to benefit from.
Advantage: data is promptly available when needed.
Disadvantage: if data changes at some point, it will require a maintenance effort, which exposes the business process to a risk of failure.
Cached: offered through an external service and gets pulled according to a pre-defined refresh rate or manually.
Advantage: data is ‘up-to-date’ within the rules acceptable by the business process, without extra load on the network resources or the external service.
Disadvantage: if data changes while the auto-refresh did not happen yet, the user may not have access to the latest data; however, the user can manually force a refresh of the data, if asked to do so.
When to Use It
Offer data in lookups that were cached from an external service.
Satya Nadella Announces Microsoft Dynamics 365 at WPC 2016.
Microsoft Dynamics 365
Designed to help change the nature of digital work within organizations of all sizes, Microsoft Dynamics 365 empowers business users with built-in insights and intelligence within the business applications they’re working in – applications like field service, sales, finance, and operations.
“As a result, Microsoft Dynamics 365:
– Introduces a disruptive and customer centric business model to build what you want and buy just the capabilities you need, while ensuring all roles have access to all the data they need to be successful in their jobs
– Helps organizations move from monolithic application suites to purpose-built, SaaS applications with intelligence built-in
– Integrates Microsoft Office 365”
Some have asked me (both on Dynamics Community and Mibuso) how to use in NAV Word Layout reports property to hide the value 0 or other values in fields under conditions.
Sample of question: “I have made a report in NAV 2016 using Word and XML. Everything is very well, but I have one problem. When “quantity” is added to the report, writes NAV “0” in all cells with no information. In the attached picture saying “with error” you can see That the “quantity” cell with no information is filled with “0”.”
Some functions can be used with C / AL With these sample functions you can simulate what is done by the visibility property of the RDLC report or by VBNET Functions included in the report (Public Functions on CODE section of reports).
Num2Str (IdecValue: Decimal) OtxtValue: Text  IF IdecValue <> 0 THEN BEGIN OtxtValue: = FORMAT (IdecValue, 0, ‘<Precision, 2: 2> <Standard Format, 0>’);
Num2Str2 (IdecValue: Decimal) OtxtValue: Text  OtxtValue:=FORMAT(IdecValue,0,'<Precision,2:2><Standard Format,0>’);
Int2Str (inValue: Integer) OtxtValue: Text  IF inValue <> 0 THEN BEGIN OtxtValue: = FORMAT (inValue); END; .. etc etc.
A Visual SQL Query Designer – Code Project (SQL From NAV Part III)
If some of your customers asks you to gain access to SQL data directly from NAV (as other systems with integrated query editors..) can use this nice tool to run SQL queries (or others T-SQL statements…).
This tools recalls some typical features of SQL Studio Management studio like Visual SQL Query Designer; currently is available in 2 releases (VB.NET and C #), i tested the C# solution that works well.
Tool is under “CPOL Licence”
“Source Code can be modified to create derivative works”, … you can modify the solution’s source to create derivates. For example you can create a class for NAV .NET integration or create an addin for RTC Client, the tool also can be used directly by calling him from Wshell in NAV (.EXE); you can however also pilot the numbers of records extracted etc. etc. .. nice tool anyway.
“This article describes the implementation of a QueryDesignerDialog class that allows users to create SQL queries based on a given OLEDB connection string.