It has been a while since I published a new version of this table. A number of new updates were published … which I added on my list (remember you can see the additions in italic).
Enjoy the list .. and the weekend!
Decimal seperator on the numerical keyboard does not work
In the RTC it is not possible to filter on the "Blank" option in a Option typed field
Error message when you active the option MaintainSQLIndex or MaintainSIFTIndex in Microsoft Dynamics NAV 2009: "Cannot drop the index 'CRONUS International Ltd_$Cust_ Ledger Entry.$6'"
The xRec and Rec variables unexpectedly contain the same values in Microsoft Dynamics NAV 2009
Error message when you click "Post and Print" in the Bank Account Reconciliation dialog box to print a reconciliation in Microsoft Dynamics NAV 2009: "The Bank Acc. Reconciliation does not exist"
The "ISTEMPORARY" property of a RecordRef variable becomes incorrect in certain cases in Microsoft Dynamics NAV 2009
NAV 2009 SP1
This link for Customers.
Translation of Report to DBCS fails with RDL included in report Objects
Fast forward-only cursor causing performance problem with build 29512 and later
Some interesting version-specific links:
Executives & Sales
Developers & Consultants
C/Front hangs while generating a lot of temp files
Selecting printer tray doesn't work
Locking error when printing a report with code in a form
Local variable in debugger
NAV Shows unexpected results when filtering, and may crash
Certain jobs can run slower after upgrading the client
NAV can crash in certain situations: E.g. error 1247 in module 19. No official KB URL available yet. though.
Cumulative Platform Update Rollup
NAV crashes when you try to open some forms
Error sending a document from Commerce Gateway to a server with BizTalk
Restore backup: Company Name 'xx' does not exist
All SIFT views of a table are rebuilt when changing the table
Changes in Production Schedule are not saved - Native only
XMLPort.EXPORT cannot handle DBCS Characters.
Permissions too restrictive when calculating flowfields with security filters (recordlevel security)
RunModal error screen when deleting record links in certain
Save report to html can save the wrong space characters.
Lookup list in report request forms do not open.
XML Ports do not import data that comes after a white space
Client crashes when using a global FieldRef variable
Error message when you restore a customer database on Microsoft Dynamics NAV 4.0 Service Pack 3 (SP3) Native backup to the Native option for Microsoft Dynamics NAV 5.0 SP1 Client: "Internal Error 1355 in Module 19"
The XML port returns an additional error message when you execute an XMLPort import in Microsoft Dynamics NAV 5.0 Service Pack 1: "The XML Parser setup fails"
The xRec and Rec are the same and the change log does not detect any changes when a record is changed from a sub form in Microsoft Dynamics NAV 5.0
You require a new platform feature to provide the functionality to limit the general visibility for users in Microsoft Dynamics NAV 5.0 Sp1
The Microsoft Dynamics NAV client crashes when you lose the connection to Microsoft SQL Server in Microsoft Dynamics NAV 5.0 Service Pack 1
Some temporary files are not deleted as expected when the Microsoft Dynamics NAV 5.0 application service stops
Menu items or menu groups that are sent to shortcuts disappear from the original menu in Microsoft Dynamics NAV 2009 or Microsoft Dynamics NAV 5.0
The card form does not show the detailed information for the record in a list form in Microsoft Dynamics NAV 5.0
Slow performance when you apply a filter to a form that is based on a large table in Microsoft Dynamics NAV 4.0 Service Pack 3 and Microsoft Dynamics NAV 5.0 Service Pack 1
The Microsoft Dynamics NAV client crashes when you reopen a company that contains certain customizations in Microsoft Dynamic NAV 5.0 Service Pack 1
Error when opening 4.x db in 5.x: "You do not have permission to modify the [Tablename] Table"
All object info is unexpectedly updated after upgrade db to 5.0 (SQL Server)
Error when renaming record: "you cannot rename a record because the new value is ''"
C/FRONT API stops responding when creating connection
"Two fields below must be the same type " or "No. xxxx is not defined in the contact profile answer table"
Locks are not released as expected
Crash when processing messages from MSMQ
Slow performance when running reports after client upgrade 4 to 5
several issues when you set a filter in a list form
NAV displays an incorrect character when using a DBCS character in a field
The XML port adds unwanted characters when you export data in a double-byte character set (DBCS) environment in Microsoft Dynamics NAV 5.0
The characters that indicate an empty HTML cells are incorrect displayed as " " in Microsoft Dynamics NAV 5.0
You experience slow performance when you restore some companies into a Microsoft SQL Server database in Microsoft Dynamics NAV 5.0
Microsoft Dynamics NAV 5.0 becomes unresponsive when you perform a search process in a list-type form
Error message when you perform the Copylinks function by using a recordref-type variable in Microsoft Dynamics NAV 5.0: "Type conversion is not possible because one of the operators contains an invalid type. Record := Recordref"
The xRec and Rec are the same and the change log does not detect any changes when a record is changed from a sub form in Microsoft Dynamics NAV 5.0Error message when you change the properties of a key in the Cust. Ledger Entry table (21) in Microsoft Dynamics NAV 5.0: "3701,"42S02",[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the index 'CRONUS International Ltd_$Cust_ Ledger Entry.$6'"
The Microsoft Dynamics NAV 5.0 client crashes if you receive an error message when you try to close a form
Some printers are not displayed in Microsoft Dynamics NAV 5.0
The Microsoft Dynamics NAV 5.0 client crashes when you use the Error function in the OnCloseForm trigger
The fast forward-only pointer replaces the dynamic pointer when you run the Microsoft SQL Server Option for Microsoft Dynamics NAV 5.0
Microsoft Dynamics NAV 5.0 crashes when you open too many dialog boxes
included in 4.0SP3!*
Update 2 – NODBC
F4 Delete function behaves inconsistently when pressing CTRL+A to select all records
NAV crashes when saving an object with large amount of text constants
NAS stops responding to events when a lock timeout occurs
NAV ignores specified printer tray selection when printing a file from second page or later
Slow performance when browsing a list in a form
Dynamics NAV client stops respoding when NAV calcs a SIFT
Error message when you open a company in NAV 4.0: "Property exceeds the buffer size"
Several issues when filtering an list form
NAV crashes on citrix if captions contain an ampersand
Inconsistent behavior when you search for the "RecordRef" data type records in different Windows operating systems and Microsoft Dynamics NAV versions
Error when printing a report: 'FORM NAME' cannot close because the system is currently working
Error when lock time-out occurs: "Function sequence error"
The characters that indicates an empty HTML cells are incorrect displayed as " " in Microsoft Dynamics NAV 4.0 Service Pack 3 (SP3)
Memory is not released when you open a new company in Microsoft Dynamics NAV 4.0
Error message when you open a table in the Design mode in Microsoft Dynamics NAV 4.0: "Error 2 in module 5"
The BLOB data type cannot be performed on the RecordRefs object in Microsoft Dynamics NAV 4.0
The last Outstream.Writetext statement is not considered by the string.LEN function or the string.TRUNC function in Microsoft Dynamics NAV 4.0
To be released yet. See Mark's blog.
Update 4 – NODBC
Update 2 – NODBC
Error message when you paste selected records from a form to a table that has the property "PasteIsValid=No" in Microsoft Navision: "You are not allowed to paste in this table"
You are prompted to convert the database every time that you open a database in a client installation of Microsoft Navision 4.0 Service Pack 1
Other interesting links:
I think about everyone knows about the big challenge in Europe … or at least in the European Union. Regarding NAV, I mean … Europe has got a lot of big challenges … but I won't (and wouldn't be able to) go into that .
Regarding NAV, a lot is about to change about the VAT legislation. To explain how Microsoft Dynamics NAV is dealing with these changes, Microsoft has released a whitepaper. There are the different links:
For all you partners that have customers in the EU, I advice you to read it carefully. For all customers … same advice :-).
All of you that worked with the form transformation tool, have experienced that … you have to click your mouse A LOT. Not only click a lot, but also, think a lot. You have to:
A LOT of clicks and thinkabouts … which takes time.
Imagine that you could do this all in far less mouse clicks … and with far less thinking! Well, the new commands in NAV 2009 SP1 "IMPORTOBJECTS" and "EXPORTOBJECTS" might help us with that. Actually, I expected the NAV team to use these objects to expand the TIF Editor with a much easier form transformation functionality … like you don't have to export and import the objects yourself anymore. But that unfortunately was not the case. That's why my colleague Stany and me started working on it ourselves … and succeeded! . I would not be a community guy if I wouldn't share this with you!
We simply created a new button on form177000 "Transformation Forms", where we call a new funtion:
fct_IfactoTransform() //Check if setup exits lrec_TIFFSetup.GET(); lrec_TIFFSetup.TESTFIELD("TIF path Import"); lrec_TIFFSetup.TESTFIELD("TIF path Export"); //Only work with the selected objects TransformObject.COPY(Rec); CurrForm.SETSELECTIONFILTER(Rec); //Text004 = You have selected %1 objects to export. Do you want to overwrite existing transformation input files? IF CONFIRM(Text004,FALSE,COUNT) THEN BEGIN bln_SkipMessage := TRUE; //Skip message in function ExportTransformationAll() ExportTransformationAll; lrec_TransformObject.COPY(Rec); IF lrec_TransformObject.FINDSET THEN BEGIN REPEAT lrec_Object.GET(lrec_TransformObject.Type,'',lrec_TransformObject.ID); lrec_Object.MARK(TRUE); UNTIL lrec_TransformObject.NEXT = 0; END; lrec_Object.MARKEDONLY(TRUE); COPY(TransformObject);
EXPORTOBJECTS(lrec_TIFFSetup."TIF path Import" + '\' + ltxc_Export,lrec_Object,1); IF EXISTS(lrec_TIFFSetup."TIF path Import" + '\' + ltxc_Import) THEN ERASE(lrec_TIFFSetup."TIF path Import" + '\' + ltxc_Import); //Run the Tool lint_WshMode := 0; lbln_WSWait := TRUE; CREATE(laut_WSScript); laut_WSScript.CurrentDirectory(lrec_TIFFSetup."TIF path Import"); laut_WSScript.Run(ltxc_TIFFTool, lint_WshMode, lbln_WSWait) ; CLEAR(laut_WSScript);
//Wait for pages.xml being created before continuing. //Wait 15 seconds at most. lbln_Stop := FALSE; lint_Counter := 0; REPEAT SLEEP(1000); lint_Counter += 1; lbln_Stop := EXISTS(lrec_TIFFSetup."TIF path Import" + '\' + ltxc_Import); IF lint_Counter > 15 THEN lbln_Stop := TRUE; UNTIL lbln_Stop;
IF EXISTS(lrec_TIFFSetup."TIF path Import" + '\' + ltxc_Import) THEN IMPORTOBJECTS(lrec_TIFFSetup."TIF path Import" + '\' + ltxc_Import,1) ELSE ERROR(ltxc_NoTransformation);
These local variables were created:
'Windows Script Host Object Model'.WshShell
And these local text constants:
No Transformed Forms!
Transformation Complete.\Do not forget to compile the page(s)!
If you can read code like in the movie "The Matrix", you probably don't need any explanation. But for the others, may be a few things I'd like to explain:
NoExported := ExportTransformation('TransformPages',FALSE); ExportTransformation('IgnorePages',FALSE); ExportTransformation('MovePages',FALSE); ExportTransformation('DeleteElements',FALSE); ExportTransformation('MoveElements',FALSE);
//Added code IF bln_SkipMessage THEN BEGIN bln_SkipMessage := FALSE; EXIT; END; //Added Code (STOP)
I'm sure you're able to write better or less code. I actually don't care about that. I just wanted to give you an interesting and working peace of functionality which is going to save a lot of time and frustrations.
The resulting functionality could be something like this. Select a few records in form 177000 "Transformation Forms" and push your new button "Transform":
The system starts working, and after a few seconds, you get the message:
We didn't succeed to include the compiling step … . If you do succeed, don't hesitate to mail me the solution .
For your convenience, I've put the new version of form 177000 on mibuso. You can download it here. Make sure you set up the tool correctly and … enjoy!
Yesterday, I attended a workshop about "What's New in NAV 2009 SP1" in the Netherlands. The workshop was hosted by my good friend Mark Brummel … and yet again, quite a success. During this session I came across quite the same items I already mentioned in my previous posts, so I won't repeat them again. But I WAS surprised to notice a few things …
First of all the lack of knowledge regarding everything about the new reporting possibilities. It was clear to me that people avoid the RDLC-layout-capabilities. It seems that, since NAV 2009 allows to print reports in the old way (starting the old report in the classic client), people don't find the necessity to put the work into that anymore.
I can understand that the Belgian people don't have this knowledge yet since the Belgian version isn't released yet. But the Dutch version has been released for almost a year now .. and still … people are avoiding it, don't have the knowledge. Only one guy (hey Mischa :-)) seemed to have gained some knowledge about it. Strange, if you ask me … .
In my opinion, there is business (hole in the market, like they say in dutch :) ) for people that want to "pick it up". Just like "SQL Server Performance Tuning", this seems to be a branch that not too many NAV Partners want to gain knowledge of. That's why it might be an interesting business focus? I believe in the new reporting capabilities … and I will make sure that my developers will get the proper training to get the most out of it… . In fact, we have our first training next week. If you want to do train yourself as well .. here is a good starting point.
On the other hand, I noticed many positive things. People have been working with de transformation tool A LOT. There were really specialists regarding Form Transformation. A few things I learned were:
There was a lot of interest in the Client Extensibility. What is it? Well, it's possible now to create your own controls, or use custom controls in the Role Tailored Client. Christian Abeln is godfather of "Client Extensibility", and you can read a lot about it on his blog. Also Freddy has been working with it, and created a nice tool (the component helper) to make it even more simple. We spent about an hour talking about examples, brainstorming, … . Interesting! In my opinion, it's going to take some mind switch to get the most out of it … but try to imagine the opportunities. I like to describe it like this … the only limitation is going to be the creativity of the consultants :-).
Last thing I would like to draw your attention to are the testing codeunits. I knew they existed, but I didn't know how they worked. Mark showed a simple example that made it clear to me. Simple said: you'll be able to create test scripts to test your code. In these new types of codeunits, you'll be able to suppress confirms (by automagically click "yes" ) and stuff. Actually, the example that Mark showed, was created by Kamil Sacek (Kine from Mibuso) and you can find it here.
To conclude with, I would like to share with you some "did you knows" that I got from the course. Did you know:
It was a great session. Definitely worth the 5-hour drive . Good job, Mark!