-
How to Re-apply a Language Pack when deploying the Outlook..
How to Re-apply a Language Pack when deploying the Outlook Integration Update for Microsoft Dynamics NAV 5.0 The language module file helps you to save the existing text messages and captions, and propagate them to the Outlook Integration Update objects. How to apply the language module file to the C/AL objects provided…
-
Google Custom Navision Search Engine
Hi All, I have created a custom search engine which searches Navision Sites. http://www.google.com/coop/cse?cx=01462 ... ln7zuzbgnw I currently have 5 sites. If there are any other Navision sites that you want listed, just reply to this thread and I will add it to the custom Search Engine. The sites currently searched are:…
-
Using Partitioned Tables in Nav
Partitioned tables/indexes is a new and exiting feature in SQL 2005 that is not used in Nav. Using partitioned tables in Nav can increase performance when working with BIG tables such as transaction history tables. With a partitioned table, you can define that all history from 2006 and back (inklusive) should be stored on…
-
TIP: Using a 3.70 client while programming a 3.60 database
Hi, (This was already posted on the wrong forum; this should be the right place.) I'm using the 3.70 for programming course of the great new features. But here is the problem. When programming in a 3.60 database, which will be used in combination with 3.60 clients, problems will occur if you compile objects (with your 3.70…
-
About simple parsing a text file with objects
Hi All, Below you can find some C/AL code for fast parsing text file with NAV objects. OBJECT Table 50000 C/AL Code{ OBJECT-PROPERTIES { Date=28-11-07; Time=09:47:38; Modified=Yes; Version List=Research; } PROPERTIES { } FIELDS { { 1 ; ;Line No. ;Integer } { 2 ; ;Line Text ;Text250 } { 3 ; ;Nesting ;Integer } { 4 ; ;Line…
-
Shortcut key menusuit
Does anybody know the Shortcut key to go to the menusuit (navigation pane)? When you are in the menusuit you can use e.g. CTRL 1 to go to Financial Management and run an object. But when you want to return from the object back to Financial Mgt in the menusuit, CTRL 1 doesn't work.
-
Job Queue blog example
Hello. Saw this great blog, that is a great example on how modify Navision to queue any processes that cause locking. http://blogs.msdn.com/microsoft_dynamic ... v-5-0.aspx
-
How to retrieve network path from mapped drive path
Hello, using the CommonDialog control, I allow a user to select a file. Then I place that path and filename into a field of a table. Once the path is stored in the table, other users should be able to click a button on the form and open the designated file. The problem is that the path may be a mapped drive path and other…
-
Viewing Temp tables on Forms
Everybody has already stumbled against the problem of viewing temp tables in forms used for viewing, not for adding or deleting(however this is possible too). -First you set the sourcetable to the same ID as the temp table. -on OpenForm or wherever(like push on button) fill the temp table.(PUT A RESET AFTER FILLING IT!!)…
-
copy fieldfilters from 1 table to another
This topic I create as a remark to my post http://www.mibuso.com/forum/viewtopic.php?p=106339#106339. I wanted to copy filters field by field from one table to another table. So I thought to use recordreference and field reference to do it so to avoid 1 line of code per field to be copied. These are the globals I need. All…
-
Store multiple company logo in one company
Originally discussed on this post: http://www.mibuso.com/forum/viewtopic.php?t=22153 Basically, on the company setup, create a new record and use the standard Navision form to upload you into the BLOB field. This will eliminate any need for modification (other than the reports)! :D
-
Date field not under 1753 in Native
Source: My Blog. Thanks to Kine's comment, I was able to create a somewhat workable solution. It's quite simple. Just add following code at the beginning of the MakeDateText-function in Codeunit 1: //*** Waldo BEGINIF EVALUATE(Date,DateText) THEN BEGIN IF Date < 01011753D THEN BEGIN DateText := ''; MESSAGE('Your Error…
-
Copy from Navision to Excel
Hi, I am looking for a Tips to disable copy from customer, vendor and item list. This data are very confident and I don't want to allow users to copy in excel file. I try to create a Menu with Ctrl+C but windows functions are still active. Your idea are welcome. Thanks.
-
Get full domain userid
How to get full domain name and login ? If the login information is DOMAIN\john, the USERID field only return the value of "john" instead of full login information "DOMAIN\john". I need this function because I created a user authorization table which consist of windows login user (the customer use windows authentication),…
-
Debugger: Ctrl+F2
If you hit Ctrl+F2 in debugging mode, you can see that the line of code that is running is marked by a little blue square. What does it mean? I'm sure it's useful for something, but I don't find nothing on the Help... :-k
-
How to edit the Windows installer package (.MSI)
FYI - One of components supplied with the Windows SDK is "Ocra" - which allows the editing of the package (Has to be installed after SDK is loaded) URL to SDK installtion is below - http://www.microsoft.com/downloads/deta ... QhJQ%3d%3d
-
Stupid Trick
It's not very useful, but only to let you know (if you do not already know it)... If you copy a text constant (the whole line) and you paste it in the c/al globals (variables tab), it will be pasted instead in the text constants tab.
-
Copying Error and Message Box
Hello Saw this in North American Monthly news. It's a great tip. Whenever you get an Error. Just Press Ctrl + C, and Navision copies the error to clipboard. You can then paste it notepad or an email and send the error. There a lot of times where you get errors in navision and then you have to find the record that is not…
-
Standard text lookup from any text field
This is a standard functionality feature - "Standard Text" lookup from any text field, that has no lookup defined. In any text field ("Description" on journal lines, "Name" on Customer, etc.), even in variable definition form, enter '?' (question mark) and hit "Enter" or just leave the field to make it validate. Lookup…
-
Refreshing a subform
We have a field in a form, and this form has a subform. We want some fields in the subform to change their values when a field in the form is changed. How can we get this without having to click in the subform? Thanks
-
Navision Client freezes when maximum input field is exceeded
I had the problem with several windows installations and Navision Financial Client 2.60 that the client freezes (hangs) when the maximum length of an input field is exceeded by the user. Normally, the client should just beep and do nothing. On my systems, the client freezed and could be unlocked only after waiting for some…
-
Lookup Forms with FlowFields disabled
once i had a problem with slow lookup of Item Ledger Entries. After some analysis it became clear that the flow fields based on "Value Entry" table data were to be blamed. so in the form 38 "Item Ledger Entries" i check for lookup mode and if it is lookup mode i make flow fields invisible. Another alternative would be to…
-
More Navision Training Videos (Part2)
Since the first post was locked I started a new one (Part1) http://www.mibuso.com/forum/viewtopic.php?t=11360 (Part2) http://www.navisiontraining.net/Student.htm If you scroll down Study Guides Only March 1, 2007 - (1 PM Eastern) - Cash Flow Projections April 1, 2007 - (1 PM Eastern) - How to handle "Customer Deposits" May…
-
Delete object in Import Worksheet
Does anyone know how to create a "killer object" with size 0 and to use that object to delete objects in database with import worksheet? Thanks gma
-
Understanding boolean values
I'm posting this because I'm a bit of tiring looking at code written like: IF Amount>0 THEN BEGIN CurrReport.SHOWOUTPUT(TRUE);END ELSE BEGIN CurrReport.SHOWOUTPUT(FALSE);END; As any expression that contains comparision operators returns a boolean value and a boolean value is what SHOWOUTPUT wants, it's a lot cleaner,…
-
Connection to external Databases via ODBC / ADO
Connect external databases (Access, ODBC-Databases etc) via ADODB. Hope this is useful for the community. Other Databases should work with just a different connection string Example for ADO-Access on external ODBC-DatabaseADOConn Automation 'Microsoft ActiveX Data Objects 2.7 Library'.ConnectionADOrs Automation 'Microsoft…
-
Making NAV use a certain index on SQL Server
You can read this on my blog as well: http://dynamicsuser.net/blogs/waldo/archive/2007/08/21/making-nav-use-a-certain-index-on-sql-server.aspx I'm ashamed that I did not know about this feature until for a few weeks ago. Why? Because it has been in the bible for a long time (fyi, "the bible" is "The Application Designer's…
-
Problem To get the IP of the system through coding
Can we get the IP of the system through Coding... Plase anybody help.... ](*,) ](*,) ](*,)
-
NAV 4.0, Localized Excel and property Formula
Because in NAV is a small bug which don't allow write to property Formula of Cell US expression then it's big problem write transparent international application with localized Excel. I found a small trick how to get subfolders for any folder though NAV don't know FOR EACH - Windows Script Host Object Model Folders and…
-
How to Address Return Variable/Value
Hello, Just a simple one, when you call a function from a point in your code and provide it with the variables it needs, assuming the function is asked to return a value/variable how do you address this in the code that it returns to. Cheers :roll: