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.

Have you ever found that the column you are looking for doesn't appear under Choose Columns in the Role-Tailored Client. This problem has been around throughout all of the 2009 releases of Microsoft Dynamics NAV.  Here is how to fix it.

I am starting a list of Windows Server and Active Directory commands that are useful for troubleshooting NAV Web Services, etc.  I will keep adding to this list as I discover new ones.

Does it feel like your reports are slowing down?  We it is possible that they are.  It is a common symptom of Index Fragmentation.  Here is a query that you can run to find out how badly your Idexes have become Fragmented over time.

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.

I have been working with Navision for quite some time, so I have become somewhat biased as to why I chose Navision, over working with other types of software from a career standpoint. Therefore, I would be interested in any feedback that other Navision users could provide as to why they switched or why they are glad they switched to Navision over other systems.....

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

Today’s fast-paced business environment demands instant access to customers and vendors. Microsoft is providing built-in integration with Microsoft Dynamics CRM and NAV.

Pay control schedules are an excellent reporting tool for payroll. However the reports generated with NAV's payroll schedules show the employee's Social Security No. For privacy and security, management reports should not have Social Security numbers.

In this first BLOG we'll walk you through the process of removing the Social Security No. from the payroll schedule report.

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