-
Opening a Folder - Common Dialog (Simple Solution)
I searched the forum for a solution to open a folder from a path in a database field. There was a couple of answer's saying it was not possible or messy. If anyone is interested here is a workaround, using a field called "Document folder". txt: CommonDialogMgmt.OpenFile(Name,"Document Folder"+'.',1,'',0); Excel:…
-
WSHShell.Run versus WSHShell.Exec
Everybody dreads the "You are about to run the following executable for the first time" message you get when using the SHELL command. The workarounds listed below seem to be the most popular. Each workaround consists of a function with the following variables: Parameters:_commandLine Text 1024_runModally Boolean Return…
-
How to prevent unexpected client version update
We often use different versions of Nav for different projects. That's why we always use this trigger to prevent unexpected version update:gocreate trigger [dbo].[tr_ndo_property] on [dbo].[$ndo$dbproperty]for updateasdeclare @new_identifiers varchar(2000)declare @old_identifiers varchar(2000)declare @new_database_version…
-
RecRef and Form.runmodal(ID,record)
If you select, modify or insert many Record in different tables per RecRef and you will see the result in the "original" form (like 21 for Customer), you can use this codeexample to run the original Form without creating a Record variable (like 18 for customer). But you must know the formid that you will run.…
-
SQL Script to create login in NAV 2013
We've all been there at one time or another. After restoring a customer database to your server, you find yourself unable to login with your user account. In previous versions of NAV, you could simply insert a record containing a SQL Server user id into the User and Member Of tables. Not quite as simple in NAV 2013, since…
-
Hot Keys in Navision 2013
Hi, 1. When you are on a RTC Page, you may key "F10" to activate the "Hot Keys". The pages will be displayed with the hot keys like in other MS Office applications (Word, Excel etc.). 2. Sameway, if the action ribbon is to be collapsed (from a page) and also to hide the "Fact Box", after opening the Page, user can key in…
-
Import JPG on Fly & Show In Navision
It's been discussed how to save your Item pictures on an outside drive and show them in Nav on the fly as BMP. This way you Database doesn't grow out of control when you have to import 10000 pics into BLOB fields. You can also have JPG pics on an outside drive and show them in Nav. To Test use Form 346 item Picture…
-
E-mail classic reports as PDF, Dynamics NAV
There are severals post about this topic, her is another solution. It uses Bullzip and standard mail codeunit in NAV. If your customer is running a classic Dynamics NAV installation and wants to add some mail functionality, for example mail purchase order to vendor. In this example I will create a mail functionality and…
-
Microsoft Dynamics NAV - InsertHTTP() - Function
Requirement: Add ‘http://’ in the beginning of the String, if it is not entered by the user. To be used in the OnValidate() of a field. http://msdynamicnavblog.blogspot.com/2013/01/microsoft-dynamics-nav-inserthttp.html
-
Get XML from Internet and use in NAV2013 (NAV2009) XML DOM
There are plenty of information sources on the Internet that provide us with usable data, for example exchange rate, RSS-feeds, package tracking, post code validation etc.. The Scandinavian logistic company Bring (http://www.bring.no) has a public API to access the postal codes for some countries. The api instruction could…
-
Change Client company in Dynamics NAV Classic with C/AL
If the database has multiply companies the user sometimes has to change company. There are a funtion in NAV CHANGECOMPANY but that does only give us access to read or write in the other company, my function will switch the client company. There are no functions i C/AL to change company so we have to use windows script…
-
My EShip came with a MAILOCX - lets try it!
Our EShip came with an email OCX. It can be used in the system to send mails if you don't want to use CU397 (for whatever reason) the useable fields: For example I tried it on a button on the item card that quickly creates an email of the item details and attaches a picture. OnPush()User.GET(USERID);CALCFIELDS(Picture);IF…
-
Comments & OnLookup
i just noticed that even if there are only comments in the onlookup trigger of a field in a table, the table relation used to look up the table (for example) won't be considered when looking up that field. In other words, in order to not use the onlookup trigger, it is not sufficient to comment out your code, you MUST…
-
The request failed with HTTP status 401: Unauthorize
Hi Quick tip that may help... NAV 2009 R2 - 3-tier setup getting the following error when accessing the NAV Web Services: System.InvalidOperationException: General Error http://abc-svr-nav1:7047/DynamicsNAV/WS/Services ---> System.Net.WebException: There was an error downloading…
-
Use the SourceTableTemporary property.
The SourceTableTemporary is a new property introduced in 5.0 giving all kinds of new capabilities of showing data that is not even in the database. Instead of showing real data from the database, the form is running on an empty table when starting up, so you will have to populate it with data. Step 1. Create a normal form…
-
How to generate random code with limited range
Hi Nav Masters I have a problems, i need to generate 8 digit Code which each digit is random code consist of : number 2 to 9 (without 0 and 1) or A to Z or a to z Can we do this? How to do it in navision c/al code? Thanks in advance,
-
Create a balloontip using powershell
Here is an example of using a balloontip to notify the user of something, not important enough to send the user an e-mail, and to avoid an annoying messagebox which have to be clicked away. In fact, it's only useful in combination with a timer running on every client, to track some changes in certain tables, but i'm not…
-
Upgrade from 3.01 to 2009 Caption Class
Hi all I am having trouble getting the CaptionClass working and I'm think this is because the core objects haven't been updated from the original 2.01 version. I've updated codeunit 1 to include these Caption functions but I cannot get a value returned other than blank and the debugger doesn't drop into any of these…
-
Disable Copy on List Forms
Hello, I have had a few customers ask to disable the copy on list forms, and even after showing them how print screen, a cell phone camera, or even printing reports can give the users the information anyways. Well it usually doesn't matter, they still want this feature to make it more difficult to do, a "Help keep the…
-
Hidden Characters (Carriage Return and Line Feed)
I've recently seen a rash of situations where people are putting hidden characters into fields in NAV. Specifically, they are getting Carriage Returns and Line Feeds into things like Invoice Numbers, Addresses, Names, etc... We do a lot of extracting of data for analytical purposes, alot of which goes to flat files for…
-
Upgrading classic report to 2013
Hello When Upgrading classic report to 2013: if the report has a picture box in the footer section, you get the following error. remove the picture box and then upgrade it. then manually add the picture box.
-
Selectstr error: Same string in different case
Unfortunately the SELECTSTR (String) function is not case sensitive. In a special case i had to do it with this custom function:pString is the comma separated stringpnumber is the sub string to selecti = Integerlstrings = Integerltemptxt = Textlstrings := STRLEN(DELCHR(pString,'=',DELCHR(pString,'=',',')))+1;CASE pNumber…
-
New Actions Menu On Lines Fasttab in NAV 2013
Now in NAV 2013 you can access Lines Actions Menu from Top of Lines Fasttab. No need to click on Actions button or press Alt + F10. It's one of good feature in NAV 2013. Please See the below Image.
-
Search/replace a boolean field
I've found this by accident while renaming,renumbering fields You can't search and replace on a Checkbox > Export the form with the checkbox to .txt > Edit the .txt and change ;CheckBox; to ;TextBox; > Import the .txt and compile and now you have a Yes/No field and .. search/replace works ps. I have seen this done without…
-
Security Auditing - How to Enumerate User Access
Hi All, I find this site very helpful so I thought I'd give back to the community. I wanted to write a script that would allow me to see which users had update permissions on any given table. I'm using Windows Security in NAV 6. The code below is not all original work. The section that creates the user table was found on…
-
Send messages from subform to parent form
You can send message from subform to parent form using XMLDocument and events. When you call XMLDoc.LoadXML it fires OnreadyStateChanged event, so: 1. Declare "'Microsoft XML, v3.0'.DOMDocument" automation variable with events in parent form, and without events in subform 2. Create variable in OnOpen trigger in parent…
-
New YouTube clip - Debug NAV 2009 RTC
Not too long ago I had to help a customer debug their RTC, and decided to make a YouTube clip out of it for future use. Figured it would be appreciated here too. This is not new information (Click here for the MSDN online walkthroughs), but I always like to learn visually. Here's the link, enjoy :mrgreen:
-
Semi-automatic Date Picker on every Date field - in 3 steps
I know I know .. Probably all of you already implemented it, but for those who didn't … here's how :) Probably everybody knows the functionality when putting a question mark ('?') into a text field, that the standard text functionality pops up? Well, I've got an easy-to-create variant of this for dates. What do you have to…
-
Tips&Tricks: Excel Automation
I notice that in this forum (and not only ther) the same questions and problems concerning Excel automation are being asked over and over again. So let me share some of my experience with you: --- DECLARATION --- Name DataType Subtype Length xlWorkbooks Automation 'Microsoft Excel 9.0 Object Library'.Workbooks…
-
Jet Reports Express for Microsoft Dynamics NAV
The powerful new functionality of Jet Reports Express for Microsoft Dynamics NAV enables you to get the most out of your data. From within the familiar and comfortable Excel environment you can easily create your own ad-hoc reports and analysies to identify issues and quickly capitalize on new opportunities. Jet Reports…