Posted inDynamics NAV & BC Tips & tricks

Using ADO on RTC in NAV

On one of my recent projects I had to build a solution to update a NAV table with quantity on hand by location. Writing a processing report to maintain update and maintain the table would have taken less than an hour. But for this project performance…
Posted inDynamics NAV & BC Tips & tricks

Encrypting Data in NAV using SQL with ADO

A lot of Dynamics NAV databases carry sensitive information that by law in some countries need to be encrypted. For example credit card number or social security number. There are many solutions available. The following solution utilizes SQL Server 2005 and SQL Server 2008 provided encryption…