Most of us know that you can use the CHANGECOMPANY function in NAV to change the target company for a query in NAV to allow us to perform C.R.U.D. operations against a table in another NAV Company. While that can be pretty handy for reading data, it has several difficiencies when we want to perform an INSERT, MODIFY or DELETE. The biggest difference is that any Triggers that get triggered actually get run against the Company where the code is being executed from and not against the target company. With the advent of the NAV Web Services we have a new alternative.

Occassionally some of the NAV Metadata gets damaged and you may want to rebuild/recompile all of the NAV Objects as a first step in troubleshooting this issue. The problem is that there are a few system objects that you can't get to through the object designer. So how can you recompile them as well? Well there is a trick that should do it, as I will explain below in the following Step-by-Step instructions.

Excel 2010 added a new functionality called Slicers which is a very smart tool to be used for quick ad hoc reporting in combination with NAV. Slicers can be used as filters for the data you want to be displayed in your table and/or chart. Combined with Excel Pivot tables and charts, this slicer functionality enables you to present the data in a very efficient and user friendly manner.

For one reason or another it may occasionally be necessary to "Delete/Rename" the NAV User Configuration File for a user that is experiencing a problem with NAV. The File Name, Path and what the Configuration file actually stores depends on the client (Classic or RTC) that the user is using.

The NAV Web Services provide a customizable API for external programs to use to get data from or write data to NAV using all of the available business logic and in an industry standard format. NAV Web Services can also be used to trigger functionality within NAV to be run.

What does the NAV Change Log functionality do? This is a tool that allows you to track changes that have been made in the database and to help you monitor activity that is taking place in a particular area. You don't want to use this tool; however, for monitoring every table in the database that would cause too much overhead in the system.

Document approval is a Microsoft Dynamic NAV feature used to manage the workflow of documents within a company.

Have you ever wished that NAV could integrate with (talk to) another system or data source to retrieve or update information. Well there are a number of ways built-in to NAV for doing just that.

Item Charges are used to record the costs for example for distributing, handling or transport of items. Item charges can be used for e.g. insurance, freight cost or custom duties.

The item charges will be added to the direct unit cost of the item purchased or sold, thus will affect the cost of goods sold and profit calculation.

Wouldn't it be nice if you could share your data between Microsoft Dynamics NAV and Microsoft Dynamics CRM? We the truth is you can and there are a lot of options for doing so. The newest kid on the block is Microsoft's own solution, the recently released CRM Connector for NAV. I am going to break down several of the options for integrating below.

Development work in a live system - although it is not normally fatal to the developer, unless he is working on a missile guidance system, it can be for the database environment that he is working in.  I will never forget a developer's t-shirt that said, "Three Dead, One Wounded, Mod Gone Awry"....

I have been working with NAV for quite a while....

ABS recommends that you backup your entire database when performing a Classic NAV Database.  This will ensure that all data relating to the database including Application Objects, Data Common to all Companies, and Company data will be contained in the backup file.

I recently attended a NAV conference which included 2 seminars with Cloud computing.....

Dynamics NAV provides a system to track data changes by the user in the database. To setup change log you will need to be knowledgeable of the Object Designer and the Tables and Fields within those tables that you wish to track.  It is suggested that you use the Change Log especially for Setup tables where data integrity is key since a change in some of these tables can affect how the system works.

When using NAV role tailored client, the profiles need to be setup to match the users and positions within the company. But there will always be users that need 2 or maybe even more profiles because their position requires access to multiple areas. How to solve this issue?

The Adjust Cost routine applies any cost changes from inbound transactions to the succeeding transactions within the NAV Database.  However, there is sometimes confusion as to how the Posting Date related to the adjustment is determined.

When developing within Microsoft Dynamics NAV, the default property values of objects may not act as anticipated.

Many a business owner has a backup system, but what he might not be aware of is that his backup hasn't worked in the last 3 months....

Trying to identify the setup that produced a certain posting in NAV can be difficult in some cases. Most postings result from multiple posting groups and depend on different setups. The attached document tries to explain some of these posting groups and setup.