Jan 25

In my search for some information about getting Item Tracking via ADCS to work with MRP/MPS in Dynamics NAV i noticed, that when i searched for specific terms of functions in NAV objects a website kept popping up in the Google search results.

For some reason i had not really seen it before, must have missed a blog post about it :). It is basically a web based object model of Dynamics NAV. I know you can use other tools like Developers Toolkit to provide the same functionality, but having it online and available without any setups is pretty cool.

Continue reading »

Tagged with:
Nov 21

Stijn Bossuyt has made a great function/codeunit for generating barcodes within Dynamics NAV without the need for any third party add-ons. You can find more information about it on this MIBUSO blog.

Barcode as defined on Wikipedia: “A barcode is an optical machine-readable representation of data, which shows certain data on certain products. Originally, barcodes represented data in the widths (lines) and the spacings of parallel lines, and may be referred to as linear or 1D (1 dimensional) barcodes or symbologies. They also come in patterns of squares, dots, hexagons and other geometric patterns within images termed 2D (2 dimensional) matrix codes or symbologies. Although 2D systems use symbols other than bars, they are generally referred to as barcodes as well. Barcodes can be read by optical scanners called barcode readers, or scanned from an image by special software.”

Lets go over a quick guide on how to use it.

Continue reading »

Tagged with:
Oct 25

Last week while being onsite at a customers site, we suddenly needed the ability to compare 2 records to see if any changes were done to the data. We were using the Archive functionality for Purchase Headers, and due to some needed modifications (in the release function) we ended up storing a lot of versions of the same Purchase Header, even though no changes were actually made. With hundreds of Purchase lines and thousands of document dimensions, the Purchase Header/Line/Dimension Archive tables were suddenly almost 50% of the total database size!

So we needed to compare 2 records during runtime, to see if they are identical before actually doing the archiving. This brings us to the subject of this post, were i will go into the details of how we did this in Dynamics NAV.

Continue reading »

Tagged with:
Oct 21

Using the built-in string functions in Dynamics NAV usually gives you all the string manipulation options you need. But a common request is replacing a special char with a new string value. This example came from the previous post on SMTP Mail functionality in Pre Dynamics NAV 5 versions. Mads from Denmark, ran into an issue with HTML encoding when using national chars like: æøåÆØÅ. For some reason the HTML emails worked fine at my local computer, here with US locale settings, but changing the values to their HTML encoded equivalent might be a good idea to get better compatability.

Below you will find the simple function for doing this.

Continue reading »

Tagged with:
Oct 07

Cronus was known as the leader and the youngest of the first generation of Titans to most people, but in the Dynamics NAV community it is known as the the demonstration company name for Dynamics NAV. It comes with its own CRONUS license, that allows you to testdrive the system. Most people think it only allows you to use it to evaluate the application features in Dynamics NAV, but it actually also allows you to test parts of the development environment.

Not a lot, but it gives you access to inserting fields on an existing table, adding them to a existing form. As well as creating new forms and reports. What objects does it give access to?

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 05

The other day i was reading Mayank’s new blog Extreme Engineering Network. Especially his post about assigning menu suites automatically was pretty neat. Well it could be, as it basically just gave you the information on _how_ you could do it. Looking at a lot of hex-editor information, i decided to give it a spin!

Assigning Menu Suites to users is a painful job for any adminstrator, as you have to go into design of the menu suite, and then for each Menu you have to uncheck the box for users that should not have access. And setting up a new user, gives access to everything by default, so you have to go into each menu to unassign – lots of work!

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:
Sep 22

Yet another…! As a regular Dynamics NAV blog reader i am sure you have seen this before, in various flavors, but here is a simple yet powerful splash screen. The main purpose of this splash screen, has been to easily identify development, test and live database configurations, and also show information about the current object version in the database.

Download the object from the download section, and see this quick tutorial on how to check for various parameters used in the splash screen, such as:

  • Compare current database name with live database name, to identify live database
  • Show custom version tag
  • Show warning for modified objects

Continue reading »

Tagged with:
Sep 16

Since Dynamics NAV version 5, when RIM was introduced there has been the functionality for Data Migration and Master Data Templates. I have never really used the Migration tool, as it just seemed to be too limited, compared to what you can accomplish with standard dataports. During my last go-live the customer was using the Master Data Templates, which is a nice little tool – still with a lot of limitations.

The usages I have seen of the tool has primarily been around the common master data tables, such as Customer, Vendor and Items. Often there are some confusion around templates used for Customers, as there are “Data Templates” (generic templates) and “Customer Templates” (customer specific templates used from Contacts / Relationship Management).

Lets get into some details, (in the classic client): Continue reading »

Tagged with:
Jul 30

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.

NAVObjectViewer by Gerd Hübner is one of simplest and most useful tools for a NAV Developer, when you have to dig into a database with modifications, that often are undocumented or you just get a brief explanation of what a previous mod is doing. It is a great alternative to using the Developers Toolkit, as it does not require any setups and other dependencies. Just a quick and easy way to find objects with a nice search interface. And yes, it also has REGEX search capabilities.

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:
Jun 29

Just a quick post here serving as shortcut for implementing Microsoft Navision Mail.SmtpMessage in older databases. All it requires is these objects:

Tagged with:
Jun 10

Over the years of working with NAV, users have always asked for ways to store their frequently used filters for reports and forms – eg. month end reports (A/R, A/P, Trial Balances), that often needs to be reported in multiple views.
Most often the users have come up with a system of storing the filterstrings in Notes in eg. Microsoft Outlook or similar. This is not a productive way, and leaves a lot of options for errors when copying the wrong filter, especially when filtering on multiple fields.

Continue reading »

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