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


“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

“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”:


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.


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

Design Patterns Wiki

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


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


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

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


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

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