Nov 17

This post is a follow up to some of my previous posts about the Send to Word/Excel features of Dynamics NAV. As you know, it uses a stylesheet (xslt file), that is being read into memory and the codeunit 403 inserts values into the document.

This is definitely one of the cool demo features, when presenting NAV. At this point you dont realize that the Cronus logo is hardcoded into the stylesheets, but think it is just using the logo in the Company Information setup.

My previous post gave you some steps on how to change this. But this can be pretty cumbersome to say it at least. So when having to do it for the I dont know what time again, i decided to create a function that could automatically insert the picture from the Company Information.

Continue reading »

Tagged with:
Oct 06

Yesterdays post on assigning MenuSuite Menu’s programatically got a lot of hits, and i have been getting a couple of emails about how to create the data for the blob field. In this post I will show how to build the BLOB generator i Dynamics NAV.

The BLOB content is reverse engineered on Mayank’s Extreme Engineering blog.

Continue reading »

Tagged with:
Oct 02

After switching blogging software, due to a server crash i never really got the old posts reposted from the original blog. I have had a lot of requests for one particular post: Dynamics NAV and the ROT table. I started finding the old backup of the database, to restore the post and realized it is almost 3 years old. Cant believe how fast times goes by. But after reading the very interesting post from Waldo about their new tool ReVision i came to think of this old post. (unfortunately i will not be at Directions in San Diego myself, even though i just live a couple of hours from there! But i hope to get some updates from people seeing the tool demonstrated!).

Basically what the post was about was the features of Rolling Object Table, a feature that allows Windows programs to publish “interfaces” to some of it internal features – i dont know it this is the correct description of it though :). Dynamics NAV is exposing some methods to read/write objects through the client, as well as querying forms and getting other data from the client. Since my original post, there has been quite a few additional blogs featuring the technology. We (see kudos section at the bottom) were playing around with the .NET Reflector tool, and used it on one of Celenia Version Controls dll’s. I had the same features as used in the Developers Toolkit for importing/exporting objects from the running client.

Continue reading »

Tagged with:
Sep 28

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.

Continue reading »

Tagged with:
Jul 14

Microsoft just released the latest version of the object permission spreadsheet. Compared to what i have seen before i think this is a brand new edition with more features in it.

“The purpose of this report is to provide information on what ojbects are included within the modules for Microsoft Dynamics NAV” as follows:

  • Search for individual objects and review the modules that include those objects
  • Search for all objects included within specific modules
  • Description of RIMDX

Continue reading »

Tagged with:
Jul 12

Microsoft Office Integration from Dynamics NAV uses stylesheets to transfer data to Excel and Word. If you are on a v5 database or higher this is standard functionality. If you have upgraded your executables, you will notice the new buttons in the toolbar, but nothing happens when you click them. In order to get them working you need to import some new objects, and add a couple of new functions to codeunit 1. The objects are:

  • Form 690: Manage Style Sheets
  • Form 691: Send-to Programs
  • Form 692: Import Style Sheet
  • Form 693: Program Selections
  • Form 694: Style Sheets
  • Codeunit 403: Application Launch Management

Most of this blog entry is really nothing hot of the press, but i found a nice little trick for getting the records inserted into the tables automatically.

Continue reading »

Tagged with:
Jun 01

I was quoting an upgrade proposal for a client that had a lot of custom reports. Trying to identify which ones were actively being used today, the client did not have a definitive answer. So we needed an strategy to identify the reports that was being used. And at the same time we would like to know who used them, and how often – that way we could make a more qualified decision about the reports to upgrade.

Of course every report could be modified so it wrote to a report usage table (but that would require you to modify every report in the system). Fortunately there is an easier way to handle this. In codeunit 1 Application Management, the function FindPrinter():

Continue reading »

Tagged with:
preload preload preload
pornpants.com pornofri.com kilporn.com