Table Information including Index information (Usage, Blocks and Reads) – Again

This is only the same query which is already here:
Table Information including Index information (Usage, Blocks and Reads)
But I noticed that the query somehow got mal-formed to a point where it could not run. So here is a cleaned-up version.
In summar…

WS on a multilanguage environment

After collecting Partner’s and Customer’s feedback about the changes introduced on build 32558 regarding Web Services (remember), DEV team has decided to introduce a way of avoiding them if desired.
 In order to do so a new feature has been introd…

How calendars are considered when calculating lead times

Lead time calculation is the calculation that takes place to calculate “Expected Receipt Date” from the “Order Date” or the other way around. Similarly, sales have the calculation to calculate “Planned Delivery Date” from “Shipment Date” or the other w…

New Report Design Guidelines

[This post has been updated for accuracy since the first publication.]
For NAV RDLC reports, we have drafted Report Design Guidelines.
I see report developers as artists because they start with a blank piece of paper, just like an artist. As artis…

QR Codes for Microsoft Dynamics NAV

QR codes (abbreviated from Quick Response code) are appearing in many different places today, and they are found to be quick and efficient when it comes to working with mobile phones and other devices which can read them. QR Code is a multipurpose inst…

Simulation of Average Cost Calculation

When using Average Costing method it’s sometimes difficult to interpret the assigned costs of an outbound entry. 
In the scenario below there is process description for simulating the average cost calculation. This is often used when investi…

Costing Error Detection and Data Correction White Paper for Microsoft Dynamics NAV

A new Costing Error and Data Correction white paper and a Costing Error Detection report have been released on PartnerSource and CustomerSource.
The Costing Error Detection and Data Correction white paper discusses common inventory costing issues and h…

Jet Reports Express for Microsoft Dynamics NAV Now Available for Swedish and Norwegian Languages

As of December 28, 2011, Jet Reports Express for Microsoft Dynamics NAV has been updated to include Swedish and Norwegian languages. This easy to use and very popular Microsoft Excel add-in for ad-hoc reporting is available as a download on C…

Post – Apply – From Item Entry Application Across Locations

The following blog post is to provide guidance for users of the Inventory costing functionality within Microsoft Dynamics NAV. The specific article is designed for providing guidance that you are able to use Appl. – from Item Entry to create an I…

Managing network files in RTC

In Dynamics NAV 2009 in RTC client if you are accessing files located on network machines, these files can be accessed when each service is running on single machine, when SQL and NST are on same machine (2 tier) or each service is running on separate….