Let NAV BEEP! (with .NET Interop “SystemSounds Class”)



beep

“It is known that in Role Tailored Based environment BEEP C/AL function is not supported”  https://msdn.microsoft.com/en-us/library/dd301405.aspx?f=255&MSPPError=-2147217396

… nice old post (but actual) with linked sample from NAV TEAM about utilization of .NET Interop (in this case with “SystemSounds Class from System.Media”) to simulate the obsolete BEEP Function)  https://msdn.microsoft.com/en-us/library/ms143809.aspx

Source: Let NAV BEEP! (with .NET Interop and Microsoft Dynamics NAV 2009 R2) – Dynamics NAV Team Blog

Advertisements

“Cached Web Service Calls” – Microsoft Dynamics NAV Community


Cached web services calls

in this section you can find a nice post by NAV Team blog about “cached web services calls”:

Abstract

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

Description

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.

Diagram

Source with samples: Cached Web Service Calls – Microsoft Dynamics NAV Community

Design Patterns Wiki

Read the “wiki page” on the Microsoft Dynamics Community!

https://community.dynamics.com/nav/w/designpatterns

Dynamics 365 and more: What you need to know


Dynamics 365 and more: What you need to know

Nice page with a lot of information about Microsoft Dynamics Business & Cloud: “What you need to know”.

http://www.gacollective.com/Dynamics/Dynamics_Business_and_Cloud_News_August_2016.html

About Microsoft Dynamics 365

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”

Latest video about Microsoft Dynamics Business Solutions
https://www.youtube.com/user/msdyncomm/featured

“ALL” Social Links

Facebook http://www.facebook.com/msftdynamics
Linkedin https://www.linkedin.com/company/microsoft-dynamics
Twitter https://twitter.com/msftdynamics
Youtube https://www.youtube.com/user/msdyncomm/playlists

Dynamics Profile: New Dynamics NAV MVP Roberto Stefanetti Eager to Share More Broadly – MSDynamicsWorld.com


Award-winning blogger Stefanetti says MVP status will help him to share even more intelligence about Dynamics NAV.

Source: Dynamics Profile: New Dynamics NAV MVP Roberto Stefanetti Eager to Share More Broadly – MSDynamicsWorld.com

Word Layout reports data control by C/AL


word layout

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

Question ref. http://forum.mibuso.com/discussion/67111/nav-2016-word-report-is-generating-extra-0
Answer
No, only in C / SIDE in this case (simple common solution), the use in this way (no logic in Word, all in C (SIDE) .. but .. i think That you can create functions in Word (macro) ,in word template. you can modify XML an add also Javascript support… an so on..”

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

Examples

Num2Str (IdecValue: Decimal) OtxtValue: Text [100]
IF IdecValue <> 0 THEN BEGIN
OtxtValue: = FORMAT (IdecValue, 0, ‘<Precision, 2: 2> <Standard Format, 0>’);
E
ND;

Num2Str2 (IdecValue: Decimal) OtxtValue: Text [100]
OtxtValue:=FORMAT(IdecValue,0,'<Precision,2:2><Standard Format,0>’);

Int2Str (inValue: Integer) OtxtValue: Text [100]
IF inValue <> 0 THEN BEGIN
OtxtValue: = FORMAT (inValue);
END;
..
etc etc.

NAV 2017 Roadmap


NAV 2017 Roadmap

Some nice “public pictures” from event “WPC 2016”

https://resources.wpc.microsoft.com/session-resources.html#

 

 

 

 

 

..you can download official Microsoft videos and ppt slides from here:

https://resources.wpc.microsoft.com/session-resources.html#

nice post by Saurav Dhyani about event topics here:

http://saurav-nav.blogspot.it/2016/08/microsoft-dynamics-nav-2017-demo-wpc.html

you are welcome !

NAV TechDays 2016, Sessions @02-08-2016


Roberto Stefanetti NAV Blog

NAV TechDays 2016 , 17 & 18 november 2016 , Antwerp (Belgium)

Sessions @ 02-08-2016 

https://www.navtechdays.com/2016/sessions

My Favorite Sessions

-Design Patterns in NAV ‘Madeira’

-Building extensions for NAV

-How to build your solution for PaaS

-Best Practices in developing Microsoft Dynamics NAV 2017 Extensions

-Building cool experiences with O365, Outlook, PowerBI and morePre-conference sessions (15-16)

-PowerShell – Black Belt

-C# for C/AL Developers

-Troubleshooting Essentials for SQL Server and Dynamics NAV

-Power-BI – Advanced

-Extending the Data Exchange Framework

Register Page

https://www.navtechdays.com/2016/register

Speakers

https://www.navtechdays.com/2016/speakers

Sourceregister | NAV TechDays 2016

View original post

A Visual SQL Query Designer – Code project (SQL From NAV Part III)


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.

Tool features

“This article describes the implementation of a QueryDesignerDialog class that allows users to create SQL queries based on a given OLEDB connection string.

query1

query2

query3

Code Download

Source http://www.codeproject.com/Articles/43171/A-Visual-SQL-Query-Designer