-
Windows Script Host Object Model Folders and Files
For once I am not resolving a problem, but posting one. I need to scan a subdirectory for files and subdirectories. In general virtual table "File" works, but now the directory-structure is so deep that the filter on field "Path" generates an error (value in the filter .... is too long for the field type). So I am trying…
-
Autobackup from Navision Client (not NAS)
If you need to create an backup (*.fbk) from the Navision client automaticly, for example at 10:00pm you can use following form / the functions in this form. Note, that this is an example for working with WSH. OBJECT Form 59003 Checklist Make Navision Backup{ OBJECT-PROPERTIES { Date=12.10.07; Time=16:46:29; Modified=Yes;…
-
Misleading error message in NAV 5
Just to confuse you, Microsoft have fouled up an error message in NAV 5. If you try to post a sales document with a posting date outside your permitted range, it tells you that: “Posting Date must be completely preinvoiced before you can ship or invoice.” Which is a bit misleading to say the least. The posting date check…
-
Access NAV Server Through Multiple Different Domains
Accessing NAV Server Through Multiple Different Domains tends to be wery frustrating! Have you ever encountered situation where You needed to connect NAV RTC client from one domain to NAV Server which is on other domain? Well, I did. And I must say that this is kind'a BIG problem with international companies who have…
-
Create Charts in Nav Reports using excel library
most of the solutions available online for charting in Nav has been using 3rd party dlls. but the solution is much simpler and can be achieved using good old C/AL code and Excel Automation Classes. Heres how its done http://extremeengineers.net/dynamics-na ... ports.html
-
Versioning Made Easier
Hi Experts, I was supposed to add my companies name at the end of the Version list of 2000 objects. I thought it will be a great pain for me to do so, and will be wasting my time. So i thought to make a report that would update the version of the objects just by a click. So here i go: 1. I initiated with a New Processing…
-
Use Open Office instead of Microsoft Office
You just need to change some registry keys to do this. Add the following keys and values in the registry: Key: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\winword.exe] Value name : (Default) Value data: C:\Program Files\Open Office\program\swriter.exe (use the correct path!) Key:…
-
Creating dotnet objects with events
Hello, I create a simple .NET class to simulate phone calls. I would use this class as an dotnet variable to catch some events from it. But it is impossible to create dotnet variable with events. So I decided to build the dll with registering for COM interop, also made the assembly COM-visible. I am now enable to declare…
-
How to remve Namspaces from xml documents for xmlports
Hello. Here is an example on how to remove namespaces, instead of the approach MS has recommended. Here is xml example. <?xml version="1.0" encoding="UTF-16" standalone="no" ?> - <Mytest xmlns="http://www.w3.org/HTML/1998/html"> <String>tada</String> </Mytest> In above example I want to remove…
-
Formatting Numbers in RTC
Inspired by Belias, that suggested me a trick to cut hour from Date Field in RTC (put a "d" in the format property of the textbox that contains that field), I started to wonder if there was a way to format Number Fields in RTC without copying the "Format Field" created by the system in Format property. by chance I put a…
-
keepWithNext trick
Hi... I had this problem and I saw that others have had it too. Basically, when creating a report, you want to avoid a page break between certain sections. But the KeepWithNext property does not help you. Specifically, it will not keep a "Header" section with a "Body" section, even for the same data item. So what I did was…
-
What means of upload,import?
Hi Expert, Who can be explain their properties at NAV 2009 License Information Form? Upload - ? (When we use this) Import - ? Other File-> Alter Database-> Integration -> Save license in database.(When we use this?) I not clear what is their difference? Best Regards, Yukon
-
Block Multiple Session logins into database
For this I have used Login Stored Procedure.. The login stored procedure is run immediately after the user has logged on to SQL Server and opened a database and before Microsoft Dynamics NAV carries out any tasks including executing any C/AL triggers. The user must have successfully logged on to the server and have access…
-
Passing a Temporary Record to/from a Dataport?
Hello Everyone, I was wondering if you can pass a temporary table to a dataport for export. I have tried it by including the following line in a codeunit that contain a function that populates the temp table with the desired records; but I get an error message when it tried to execute telling me that the dataport does not…
-
Restoring an SQL Database on an other Server or other domain
Often i hearing from customer or other programmers, they wonder why they can't connect to the restored database on new server. Only the database creater / restorer can connect. Reason: The database creater is the dbowner. But whats with the other users. So, the problem is, in the backup is also the user identification…
-
File Export in RTC with “Common Dialog Management”
I hope you have observed that a new window will be opened with options Open, Save and Cancel while exporting a file in RTC. If you want to export the file as in Classic Client like with common Dialogue Management, follow the below steps..…
-
Office XML on your 2.x 3.x or 4.x database
You can use this cool functionality if you perform a technical upgrade of your database. This means only using the new runtime (fin.exe and server.exe) on your old business logic. These are the steps to take after the runtimeupgrade Implement Office XML in a Technical Upgrade Codeunit 1 Copy the 3 functions from a 5.0…
-
Customized captions at run-time without changing Codeunit 1
If you want to use customized captions on a field, mostly you change Codeunit 1 to do it. I found a way to use customized captions without changing Codeunit 1. In the CaptionClass Property you have to put '1,5,,' + txtMyCaption. Or you can also put a function that returns the string. Some explanation: The first parameter…
-
Description field on Database Server
Hi, Is it possible to add content to the description field of the Database Server for Microsoft Dynamics NAV Classic (Windows service)? It is currently blank. BR Emerik
-
Open File from Navision -> user can select the Applicatio
Hy, when you have saved an file into an Blob (or you have saved the file on your HDD) and you will open it, you can use hyperlink. But hyperlink doesn't support all fileextensions and it will only open the regist. application or this fileextension (for exapmle Notepad for *.TXT) but when you need to open the file with an…
-
Remove Departments menu from RTC Navigation Pane
In Microsoft Dynamics NAV 2009 R2 and in Microsoft Dynamics NAV 2009 SP1 with build 31671 and later Remove Departments menu from Navigation Pane feature has been added. http://mibuso.com/blogs/mohana/2011/02/25/remove-departments-menu-from-rtc-navigation-pane/
-
Monthly Purchase Invoices in Chart
One of the new features of RTC is Charts in reports . If you want to see the monthly total purchase invoices amount in charts, here is what i have done.. http://mibuso.com/blogs/mohana
-
How to create recordlink or notify by C/AL-Code
If you want to create a notify message which is shown on the start page of a role center you can use the following example. It is importent to set the lenght of the text in a CHAR variable in front of the text. Define the following variables in the locals of the function: OutStream DataType OutStream Text DataType Text 250…
-
Disable the personalization capability in RTC
As Nav2009 R2 has been released, I read somewhere that we are now able to disable the personalization capability for users in the RTC. I found that great, because sometimes you will have users who shouldn't be able to see all columns such as prices or unit cost, and you also don't want them to add columns after they have…
-
Sql scripts for ledger tables checking
Hi all, let me share some useful sql scripts, it really helps me in my daily routine. 1. GL Consistency check. The script shows a list of posted documents, which are not balancedselect [Document No_], [Posting Date],sum(Amount) as Amount, sum([Additional-Currency Amount]) as [Additional-Currency Amount]from [Company$G_L…
-
Running List pages from report hyperlinks
hi, i've just made this blog post, and i think it's useful to put it in evidence. http://mibuso.com/blogs/belias/2011/01/10/hyperlist-how-to-run-filtered-list-pages-from-report-hyperlinks/
-
Watermark on any Navision Report
Normally, everyone whould think that its impossible to use Watermarks on Navision reports, however.... i thought i would share this with everyone. If you need to insert a watermark on any report without messing with PCL or PS code on your printer, here is what i have done. Oh and watermark is a variable.... so you can make…
-
Item Cost Calculation
NAV 5.0 SP1 This post will be probably interesting for those who uses method "FIFO", "LIFO" or Average and there are lots with enough remaining quantity in this case there is no sense to use "Adjust Cost - Item Entries" report You'll need to insert into codeunit 22 (function "InsertValueEntry") a following section of code:…
-
Limiting option string
Dear All, I need to limit an option field of 5 options to just two option in a particular form. Is it possible?
-
Writing line before and after the dataport exports lines
Hello all, Say that you want to export purchase lines to a text file but want to write purchase before all of the lines and end_purchase after all of the lines. Then you can do something like the following code:OBJECT Dataport 50000 Export Purch. to PORTAL{ OBJECT-PROPERTIES { Date=25.11.10; Time=16:52:20; Modified=Yes;…