This morning i was reading the blog post from Arend-Jan Kaufmann regarding opening Classic databases with the correct executable version. You can see his blog post here:
Suggestion for Available Databases Form in Dynamics NAV
It reminded me of a tool i basically use on a daily basis, as well as many other people in my company. It is an extended version of the Navision Starter v1.2 orignally created by Sergey Gazizyanov back in 2006. I have added support for the latest version, as well as shell integration for native databases (*.fdb), so you just double click on the FDB file.
The launcher will determine the database version from both SQL and native databases, and choose the right client executable to open the database with. It also can do automated login with database login, by using a default password like sa/sa.
See here for a quick overview…
Continue reading »
One of the most difficult errors in NAV to troubleshoot is: “The transaction cannot be completed because it will cause inconsistencies in the G/L Entry table”. In a standard, unmodified database it is usually related to tax/rounding issues. And in customized databases, it can be all sorts of issues.
Here is another useful tool made by Rashed Amini aka. ara3n, i often use, when i have to “retrofit” objects from a newer version of NAV into an older version. Im sure you have tried this plenty of times, importing a 2009 object into a version 5 database – causing a crashed client. This is due to some of the new properties/triggers in the 2009 client that did not exist in previous version. Luckily the FOB files are backwards compatible, but for the tables, xmlports and reports it causes problems. Forms, Dataports and Codeunits works just fine.
In this series of posts “What is in your Dynamics NAV toolbelt”, i will highlight some of the tools i find very usefull in my daily work, and couldn’t live without. There are probably great alternatives to them out there, so please share your experiences with me.
Recent Comments