Waldo's Blog
Microsoft Dynamics NAV

Platform updates overview - 3.70.B - NAV2009 SP1 (UPDATED 3)

waldo — Wed, 10 Mar 2010 17:24:00 GMT

As you can see, I updated the list dramatically thanks to the Platform-updates-page on partnersource (thanks wito :-) ), where Microsoft started to publish the same list as I am doing for quite a while now. I did this to have a complete the list for you to search in.

Furthermore, there is a NEW cumulative platform update for version 5.0 Sp1, like you could have read on Partnersource and blogs (like this one). After downloading it from the Product Download Page (I downloaded the BE version), I noticed the update was a 833Mb zipped file ?!? This is no normal "update", this smells like a Service Pack. What's in a name...

In fact, it's a whole new DVD! (Therefor, the 833Mb... ). BUT .. as you can see as well, it doesn't contain ALL hotfixes. So don't forget to download the latest hotfix as well. It's starting to be complicated, isn't it? It isn't, really. Just download the new DVD, install, download the latest hotfix, replace the files. Just like before.

Call for feedback...

To conclude, I would like your opinion. What should I do? This list is available on partnersource and customersource in its full glory. Sure, it doesn't include all in one page, and it doesn't include the "easy"/"handy"/"useful" links to other parts on partnersource. But on the other hand, the main subject is there... .

So, do you think I should continue my work, publish this list regularly, or has it become useless? Any honest feedback is appreciated. Don't get me wrong ... I love doing this, and I already got good feedback on the result, but it has to be useful.

Thanks for your feedback and enjoy the list!

Version	Update	Build No.	KB number	Info
NAV2009		27808		RTM
	Update 0.1	27980	960268	The numeric decimal separator does not work as expected when you use non-US regional settings in the Microsoft Dynamics NAV 2009 Roletailored client
	Update 0.2	28177	961772	The blank option disappear in the option list of option typed fields when you try to filter values on a report in Microsoft Dynamics NAV 2009
	Update 0.3	28463	962012	Error message when you design reports in Microsoft Dynamics NAV 2009: "The RDLC file is not a well-formed XML document"
	Update 0.4	28622	961430	The filter values are not populated automatically into the page fields as expected in the Microsoft Dynamics NAV 2009 RTC client
	Update 0.5	28713	968196	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'"
	Update 0.6	28766	968650	The CurrPage.CLOSE method does not work as expected in the Role Tailored Client (RTC) in Microsoft Dynamics NAV 2009
	Update 0.7	28772	968466	The shortcut that you create in the non-English classic client is lost in the Role Tailored Client (RTC) in Microsoft Dynamics NAV 2009
	Update 0.8	28795	968189	Error message when you try to start the Role Taylored Client (RTC) with a three tiers configuration in Microsoft Dynamics NAV 2009: "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'"
	Update 0.9	28795	968649	The XML port throws two errors when there is a data validation error during XMLPort import in Microsoft Dynamics NAV 2009
	Update 0.10	28815	968277	The "OnLookUp" trigger does not work as expected on a page in Microsoft Dynamics NAV 2009
	Update 0.11	28829	968411	The value of xRec is different between a form and a page when an OnLookup trigger is coded on the form and the page in Microsoft Dynamics NAV 2009
	Update 0.12	28889	969447	The OnNewRecord trigger of a page is performed two times when you create a new record in the Role Tailored Client (RTC) in Microsoft Dynamics NAV 2009
	Update 0.13	28981	969448	Error message when you open a report in the Microsoft Dynamics NAV Role Tailored Client that does not have a report definition layout in Microsoft Dynamics NAV 2009: "Microsoft Dynamics NAV Classic client is opened from an untrustworthy component"
	Update 0.14	28981	969649	Microsoft Dynamics NAV crashes if you run the code to receive a stream in the Role Tailored Client (RTC) in Microsoft Dynamics NAV 2009
	Update 0.15	29070	970473	A report is not sent to a specified printer when you print the report from the Role Tailored Client (RTC) in Microsoft Dynamics NAV 2009
	Update 0.16	29082	970762	The Microsoft Dynamics NAV 2009 Classic client crashes when you export the Approval Request Entries form (662) to Excel 2007 on a computer that is running Windows Vista
	Update 0.17	29096	970712	The xRec and Rec variables unexpectedly contain the same values in Microsoft Dynamics NAV 2009
	Update 0.18	29140	970545	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
	Update 0.19	29140	971124	You can access pages even if you do not have permissions in Microsoft Dynamics NAV 2009
	Update 0.20	29140	971173	A new instance of the Microsoft Dynamics NAV 2009 client is started when you use a fully qualified hyperlink that links to the Microsoft Dynamics NAV 2009 database
	Update 0.21	29140	971230	Error message when you run a page on the Microsoft Dynamics NAV Role Tailored Client (RTC) based on a custom table in Microsoft Dynamics NAV 2009: "Destination buffer is too small, destination buffer size: 65536, source size: 65675"
	Update 0.22	29202	970079	Error message when you post an application that has multiple documents which are applied in the Microsoft Dynamics NAV 2009 Role Tailored Client (RTC): "The application was successfully posted though no entries have been applied"
	Update 0.23	29210	971174	Error message when you use the Hyperlink statement to open a file in the Role Tailored Client in Microsoft Dynamics NAV 2009: "File not found"
	Update 0.24	29210	971701	You receive an error message in the RoleTailored client (RTC) in Microsoft Dynamics NAV 2009: "Overflow under conversion of System.Int32 value 256 to System.Byte"
	Update 0.25	29210	971738	Error message when you run a report for a company whose name has an ampersand character in the RoleTailored client in Microsoft Dynamics NAV 2009: "Company Name '[Company_name]' does not exist"
	Update 0.26	29267	972059	Error message when you run a customized report in the Role Tailored Client (RTC) in Microsoft Dynamics NAV 2009: "The input line is too long"
	Update 0.27	29285	971989	You cannot connect to a Web service when you connect a Web site by using the Microsoft Dynamics NAV 2009 Web service interface in a non-Microsoft development software environment
	Update 0.28	29285	972372	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"
	Update 0.29	29285	972465	Error message when you run a page that is based on a table by using the RoleTailored Client (RTC) in Microsoft Dynamics NAV 2009: "The in the [table name] table must be enabled"
	Update 0.30	29285	972660	Error message when you change the value in the "Bank Account No." field in the "Bank Acc. Reconciliation" dialog box in the Role Tailored Client (RTC) in Microsoft Dynamics NAV 2009: "The Bank Acc. Reconciliation does not exist"
	Update 0.31	29372	971784	Error message when you create an item journal line in a project that uses the C# language by using the Item Journal page (40) as Web reference in Microsoft Dynamics NAV 2009: "You cannot use entry type Transfer in this journal"
	Update 0.32	29372	972430	You cannot compile a statement that compares two strings in the Role Tailored Client in Microsoft Dynamics NAV 2009
	Update 0.33	29372	972791	A null termination string is added at the end of a text string when you load the string to a BSTR variable in Microsoft Dynamics NAV 2009
	Update 0.34	29372	972832	The line breaks that you added manually in the C/AL code do not work in the Role Tailored Client in Microsoft Dynamics NAV 2009
	Update 0.35	29392	972970	The blank spaces after an ampersand (&) character are removed when you pass a string to a Microsoft Dynamics NAV 2009 Web service
	Update 0.36	29392	973041	Error message when you try to access all licensed sessions at the same time in Microsoft Dynamics NAV 2009: "Your program license does not permit more users to work simultaneously"
	Update 0.37	29415	942540	You cannot determine which fields are available and which fields are unavailable when you open a dialog box in Microsoft Dynamics NAV
	Update 0.38	29415	971519	Error message when you run an object that uses the RecordRef.GET(RecordID) function in Microsoft Dynamics NAV 2009: "Object of type Table with id 2000100007 could not be found"
	Update 0.39	29415	973237	The date filter that you set in the "VAT Statement Preview" dialog box does not work in the Role Tailored Client in Microsoft Dynamics NAV 2009
	Update 0.40	29443	973227	Local characters are imported as question marks after you import a file from the RoleTailored client (RTC) in Microsoft Dynamics NAV 2009
	Update 0.41	29443	973416	Transactions are not saved in the Microsoft Dynamics NAV 2009 database when you execute the transactions by using Web services
	Update 0.42	29443	973491	Error message when you use the "Send To Microsoft Office Excel" feature or the "Send To Microsoft Office Word" feature in Microsoft Dynamics NAV 2009: "You do not have permission to read the User Default Style Sheet table"
	Update 0.43	29500	973899	You do not receive an error message as expected when an error occurs in Microsoft Dynamics NAV 2009
	Update 0.44	29500	973959	You do not receive a warning message when you try to add a record that already exists if you use the "No. Series" field with the "Default Nos" setting enabled in the Role Tailored Client in Microsoft Dynamics NAV 2009
	Update 0.45	29515	973997	You receive a Microsoft SQL Server error when you try to synchronize permissions if the "NT AUTHORITY\NETWORK SERVICE" account is set up as a Windows logon account in Microsoft Dynamics NAV 2009
	Update 0.46	29515	974066	You experience slow performance when you restore a single company into a Microsoft SQL Server database in Microsoft Dynamics NAV 2009
	Update 0.47	29518	974024	Error message when you change to another company in the Role Tailored Client (RTC) in Microsoft Dynamics NAV 2009: "Page is not open"
	Update 0.48	29548	974196	Error message when you run the Calculate Inventory report in a "Whse. Physical Inventory" journal in the RoleTailored Client (RTC) in Microsoft Dynamics NAV 2009: "The maximum length for a string value is 20"
	Update 0.49	29548	974245	The lines in a batch are not updated after you add a line to a batch of a general journal in the Role Tailored Client (RTC) in Microsoft Dynamics NAV 2009
	Update 0.50	29607	974526	Microsoft Dynamics NAV 2009 RoleTailored Client crashes when you try to open a home page
	Update 0.51	29683	974244	The Microsoft Dynamics NAV 2009 client crashes when you compile certain objects from the client
	Update 0.52	29735	974717	The Role Tailored Client in Microsoft Dynamics NAV 2009 crashes if you have Outlook 2007 Service Pack 2 installed
	Update 0.53	29735	975655	The "ISTEMPORARY" property of a RecordRef variable becomes incorrect in certain cases in Microsoft Dynamics NAV 2009
	Update 0.54	29762	975799	A newly created purchase invoice has the same number as the previously created invoice if you create the purchase invoice after you view the statistics in the Statistics dialog box in the Role Tailored Client in Microsoft Dynamics NAV 2009
	Update 0.55	30233	948302	The NAS stops responding to events when a lock time-out occurs in Microsoft Dynamics NAV
NAV 2009 SP1		29626		This link for Customers.
	Update 0.1	29958	974980	The import of the translations fails when you export and translate report objects in Microsoft Dynamics NAV 2009 Service Pack 1
	Update 0.2	29958	975339	You cannot synchronize meetings and tasks as expected between Microsoft Dynamics NAV 2009 Service Pack 1 and Microsoft Office Outlook
	Update 0.3	29958	975655	The "ISTEMPORARY" property of a RecordRef variable becomes incorrect in certain cases in Microsoft Dynamics NAV 2009
	Update 0.4	29958	976028	The Microsoft Dynamics NAV 2009 Service Pack 1 development environment becomes unstable when the object cache is set to zero
	Update 0.5	29958	976076	The Microsoft Dynamics NAV 2009 Service Pack 1 classic client crashes when you receive a Microsoft SQL Server error message in a synchronization process
	Update 0.6	29958	976273	The result set is incorrect when you apply a filter on a form in Microsoft Dynamics NAV 2009
	Update 0.7	29958	977219	The subform part of a dialog box is always noneditable if you use the Editable property for the subform of the dialog box in Microsoft Dynamics NAV 2009 with Service Pack 1
	Update 0.8	29987	977063	Microsoft Dynamics NAV 2009 Service Pack 1 crashes when you run a codeunit to call the "RecRef.GETTABLE" method and the "RecRef.FIELD" method
	Update 0.9	29994	976611	You experience slow performance in pages after you run a report in the Role Tailored Client (RTC) in Microsoft Dynamics NAV 2009 Service Pack 1
	Update 0.10	30037	976994	The spaces in a fixed-length file are unexpectedly truncated when you run the XMLPort import in Microsoft Dynamics NAV 2009
	Update 0.11	30037	976646	A report is always printed in portrait orientation even though you set the Orientation property of the report to Landscape in Microsoft Dynamics NAV 2009 with Service Pack 1 installed
	Update 0.12	30045	976543	The GET function disallows you to handle an error when you run the function on an uninitialized RecordID value in Microsoft Dynamics NAV 2009 with Service Pack 1 installed
	Update 0.13	30045	976810	You cannot access the files that are located on a share from the Microsoft Dynamics NAV 2009 Service Pack 1 server
	Update 0.14	30045	976914	Error message when you convert a database to Microsoft Dynamics NAV 2009 Service Pack 1: "CREATE USER [] FOR LOGIN []"
	Update 0.15	30065	975298	You cannot see any processing indication when you save the data in the Gantt component in Microsoft Dynamics NAV 2009
	Update 0.16	30069	977294	Error message when you close the Microsoft Dynamics NAV 2009 Classic Client with SP1 installed: "Date is not valid"
	Update 0.17	30101	976254	The records in a table are displayed as "#Name?" when you create a linked table in Microsoft Access by using the Microsoft Dynamics NAV N/ODBC-connection data source
	Update 0.18	30212	977447	The Microsoft Dynamics NAV 2009 server crashes sporadically
	Update 0.19	30212	977121	You experience various issues when you upgrade Microsoft Dynamics NAV to Microsoft Dynamics NAV 2009 or Microsoft Dynamics NAV 2009 SP1 after you specify a value for the CaptionClass property of a field in a system table
	Update 0.20	30212	977393	Two errors are logged in the Application log when you restart the Microsoft Dynamics NAV Server service in Microsoft Dynamics NAV 2009 with Service Pack 1
	Update 0.21	30212	977455	The user sessions remain active on a Microsoft SQL Server server when the Microsoft Dynamics NAV 2009 Role Tailored Client (RTC) crashes
	Update 0.22	30212	977575	The GETRECORD function returns different results on the Classic Client of Microsoft Dynamics NAV 2009 SP1 and on the Role Tailored Client in Microsoft Dynamics NAV 2009 SP1
	Update 0.23	30212	977604	You experience slow performance when you perform any actions after you print a report in the Role Tailored Client in Microsoft Dynamics NAV 2009 Service Pack 1
	Update 0.24	30212	977602	Only the company that you previously log on to is displayed when you use company-specific roles in the Role Tailored Client (RTC) in Microsoft Dynamics NAV 2009 Service Pack 1
	Update 0.25	30212	976930	You experience slow performance when you open or resize pages after you print or preview a report in the Role Tailored Client in Microsoft Dynamics NAV 2009 with Service Pack 1
	Update 0.26	30212	977218	The Microsoft Dynamics NAV 2009 Service Pack 1 client crashes when you run the FORM.RUNMODAL statement together with the COMMIT statement
	Update 0.27	30232	977533	The Role Tailored Client (RTC) crashes when you run an Automation object in Microsoft Dynamics NAV 2009
	Update 0.28	30232	948302	The NAS stops responding to events when a lock time-out occurs in Microsoft Dynamics NAV
	Update 0.29	30326	978426	Some records in a table are displayed as "#Deleted" when you create the linked table in Microsoft Access by using the Microsoft Dynamics NAV 2009 N/ODBC-connection data source
	Update 0.30	30357	978484	The cursor jumps incorrectly between fields on pages in the Role Tailored Client in Microsoft Dynamics NAV 2009 Service Pack 1
	Update 0.31	30502	979428	A hotfix is available to develop and deploy an unsupported language for Microsoft Dynamics NAV 2009 SP1
	Update 0.32	30522	979700	The Microsoft Dynamics NAV 2009 Service Pack 1 server service does not release memory after you run the SaveAsPDF function when you run a report or a codeunit
	Update 0.33	30553	977064	A RecordID field cannot be used on a page in Microsoft Dynamics NAV 2009 SP1
	Update 0.34	30609	978100	Error message when you add a field to a table in Microsoft Dynamics NAV 2009 SP1: "You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels"
	Update 0.35	30609	978492	Error message when you print a classic report in the RoleTailored client (RTC) in Microsoft Dynamics NAV 2009 Service Pack 1: "The date is not valid"
	Update 0.36	30609	978033	Microsoft Dynamics NAV 2009 Service Pack 1 unexpectedly shows 0 in flow field column in pages even though the amounts in the flow field column are not 0
	Update 0.37	30609	978488	You experience an increase of memory consumption when you run an application that calls a function in the Web Service codeunit in Microsoft Dynamics NAV 2009
	Update 0.38	30609	977606	Error message when you perform a data conversion in Microsoft Dynamics NAV 2009 SP1: "The call to member [Method_member] failed"
	Update 0.39	30609	978942	The data type of a field in a page becomes incorrect when you publish the page to a Web service in Microsoft Dynamics NAV 2009 Service Pack 1
	Update 0.40	30609	978537	You experience slow performance after you print a report in the Role Tailored Client (RTC) in Microsoft Dynamics NAV 2009
	Update 0.41	30609	978290	Error message when you try to compile an object in Microsoft Dynamics NAV 2009 Service Pack 1: "The Type –[Number] was not defined for the function"
	Update 0.42	30609	978298	The Microsoft Dynamics NAV 2009 classic client crashes when you try to compile an object directly from the Object Designer window
	Update 0.43	30609	978343	The Role Tailored Client (RTC) in Microsoft Dynamics NAV 2009 does not use the primary language when a caption is not translated to the current language
	Update 0.44	30623	980448	The FINDSET function may return an incomplete record set, depending on the size of the caching Record Set configuration setting in the Microsoft Dynamics NAV client that uses the Microsoft SQL Server database

Some interesting version-specific links:

Executives & Sales

Developers & Consultants

Microsoft Dynamics NAV 2009 Developer and IT Pro Help
User Experience (UX) Guidelines: a tool to guide ISV's and partners in building more user-friendly applications.
Caption ID's using the Form Transformation Tool for NAV 2009
NAV2009 Download Page
Installation and Application Setup Guides for NAV 2009
System Requirements for NAV 2009
Performance Guide for NAV 2009
Microsoft Dynamics NAV 2009 Developer and IT Pro Help
- The Download of the help files
- The link to MSDN
Feature Enhancements Documents for Microsoft Dynamics NAV 2009
Overview of Released Platform Hotfixes on Partnersource:
- for Microsoft Dynamics NAV 2009
- for Microsoft Dynamics NAV 2009 SP1
Overview of Released Platform Hotfixes on Customersource:
- for Microsoft Dynamics NAV 2009
- for Microsoft Dynamics NAV 2009 SP1
Dynamics NAV Treemap AddIn

Version	Update	Build No.	KB number	Info
5.0 SP1		26084
	Update 0.1	26654	953245	C/Front hangs while generating a lot of temp files
	Update 0.2	26751	953545	Selecting printer tray doesn't work
			951631	Locking error when printing a report with code in a form
				Local variable in debugger
	Update 0.3	26810	954342	NAV Shows unexpected results when filtering, and may crash
	Update 0.4	26948	954672	Certain jobs can run slower after upgrading the client
	Update 0.5	27002	954722	NAV can crash in certain situations: E.g. error 1247 in module 19. No official KB URL available yet. though.
	Update 1	27191	956161	Cumulative Platform Update Rollup
	Update 1.1	27253	954722	NAV crashes when you try to open some forms
	Update 1.2	27368	957219	Error sending a document from Commerce Gateway to a server with BizTalk
	Update 1.3	27368	957471 957733	Restore backup: Company Name 'xx' does not exist All SIFT views of a table are rebuilt when changing the table
	Update 1.4	27398	957824	Changes in Production Schedule are not saved - Native only
	Update 1.5	27831	959911	XMLPort.EXPORT cannot handle DBCS Characters.
	Update 1.6	27831	959912	Permissions too restrictive when calculating flowfields with security filters (recordlevel security)
	Update 1.7	27831	960141	RunModal error screen when deleting record links in certain
	Update 1.8	28007	960607	Save report to html can save the wrong space characters.
	Update 1.9	28028	960661	Lookup list in report request forms do not open.
	Update 1.10	28342	962005	XML Ports do not import data that comes after a white space
.	Update 1.11	28412	963700	Client crashes when using a global FieldRef variable
	Update 1.12	28512	967158	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"
	Update 1.13	28798	968465	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"
	Update 1.14	28884	969452	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
	Update 1.15	28913	969590	You require a new platform feature to provide the functionality to limit the general visibility for users in Microsoft Dynamics NAV 5.0 Sp1
	Update 1.16	28956	969881	The Microsoft Dynamics NAV client crashes when you lose the connection to Microsoft SQL Server in Microsoft Dynamics NAV 5.0 Service Pack 1
	Update 1.17	29040	969777	Some temporary files are not deleted as expected when the Microsoft Dynamics NAV 5.0 application service stops
	Update 1.18	29048	970545	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
	Update 1.19	29083	970913	The card form does not show the detailed information for the record in a list form in Microsoft Dynamics NAV 5.0
	Update 1.20	29118	971172	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
	Update 1.21	29125	971170	The Microsoft Dynamics NAV client crashes when you reopen a company that contains certain customizations in Microsoft Dynamic NAV 5.0 Service Pack 1
	Update 1.22	29469	973584	The value in a field is changed by a value that you select for a field filter on the field in Microsoft Dynamics NAV 5.0 Service Pack 1
	Update 1.23	30018	976908	The data in the Warning column is not exported as expected when you export a planning worksheet to a Microsoft Office Excel worksheet in Microsoft Dynamics NAV 5.0 with Service Pack 1 installed
	Update 1.24	30482	979135	Error message when you add a field to the table in Microsoft Dynamics NAV 5.0 SP1: "You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels"
	Update 2	30488		New product DVD that contains (obviously) all previous Platform Updates. Functional and technical changes in the product (database) as well. Here are the release notes.
	Update 2.1	978893	30550	Some transactions are rolled back without an error message if SHOWPLAN permissions are revoked from the $ndo$shadow application role in Microsoft Dynamics NAV 5.0
	Update 2.2	979210	30550	Error message when you use the Global Filter group feature in Microsoft SQL Server Option for Microsoft Dynamics NAV 5.0 Service Pack 1: "The FlowField value cannot be calculated"
	Update 2.2	978692	30524	Microsoft Dynamics NAV 5.0 Service Pack 1 uses an incorrect key for the lookup operation of the Record Link table
	Update 2.2	980448	30625	The FINDSET function returns inconsistent results that depend on the Record Set value in the Microsoft Dynamics NAV client that uses the Microsoft SQL Server database

Some interesting version-specific links:

Summary of Dynamics NAV 5.0 Sp1 Build Numbers
Summery of platform updates for 5.0Sp1
Released code fixes for NAV 5.0 that are included in SP1
Upgrade Information for Microsoft Dynamics NAV 5.0 SP1
Jobs update for 5.0SP1. It's not a platform update, but rather important, so I just add it here... .
There are new installers (msi) available for about all country versions. You can find more info here or on KB957397. It corrects the error message "The Windows Installer service cannot update the system file c:\WINDOWS\system32\msxml6r.dll".
Overview of Released Platform Hotfixes for Microsoft Dynamics NAV 5.0 SP1 (Partnersource)
Overview of Released Platform Hotfixes for Microsoft Dynamics NAV 5.0 SP1 (Customersource)

Version	Update	Build No.	KB number	Info
5.0		24199
	Update 0.1	24632	936885	Error when opening 4.x db in 5.x: "You do not have permission to modify the [Tablename] Table"
	Update 0.2	25344	943581	All object info is unexpectedly updated after upgrade db to 5.0 (SQL Server)
	Update 1	25359	943858	Platform update.
	Update 1.1	25560	945339	Error when renaming record: "you cannot rename a record because the new value is ''"
	Update 1.1b	25560	953245	C/FRONT API stops responding when creating connection
	Update 1.2	25581	944919	"Two fields below must be the same type " or "No. xxxx is not defined in the contact profile answer table"
	Update 1.3	25653	945349	Locks are not released as expected
	Update 1.4	25684	945992	Crash when processing messages from MSMQ
	Update 1.5	26026	948512	Slow performance when running reports after client upgrade 4 to 5
	Update 1.6	26810	954342	several issues when you set a filter in a list form
	Update 1.7	27241	957267	NAV displays an incorrect character when using a DBCS character in a field
	Update 1.8	27831	959911	The XML port adds unwanted characters when you export data in a double-byte character set (DBCS) environment in Microsoft Dynamics NAV 5.0
	Update 1.9	28007	960607	The characters that indicate an empty HTML cells are incorrect displayed as "&nbsp" in Microsoft Dynamics NAV 5.0
	Update 1.10	28874	969125 969037	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
	Update 1.11	28884	959158 969452 968679	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.0 Error 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'"
	Update 1.12	29083	970913	The card form does not show the detailed information for the record in a list form in Microsoft Dynamics NAV 5.0
	Update 1.13	29178	970256	The Microsoft Dynamics NAV 5.0 client crashes if you receive an error message when you try to close a form
	Update 1.14	29379	973133	Some printers are not displayed in Microsoft Dynamics NAV 5.0
	Update 1.15	29410	973045	The Microsoft Dynamics NAV 5.0 client crashes when you use the Error function in the OnCloseForm trigger
	Update 1.16	29729	974798	The fast forward-only pointer replaces the dynamic pointer when you run the Microsoft SQL Server Option for Microsoft Dynamics NAV 5.0
	Update 1.17	29736	975673	Microsoft Dynamics NAV 5.0 crashes when you open too many dialog boxes
	Update 1.18	30407	978080	You cannot know whether the RecRef object is already opened or not in Microsoft Dynamics NAV 5.0
	Update 1.19	30550	978893 979210	Some transactions are rolled back without an error message if SHOWPLAN permissions are revoked from the $ndo$shadow application role in Microsoft Dynamics NAV 5.0 Error message when you use the Global Filter group feature in Microsoft SQL Server Option for Microsoft Dynamics NAV 5.0 Service Pack 1: "The FlowField value cannot be calculated"

Some interesting version-specific links:

Installations manuals for Microsoft Dynamics NAV 5.0
How to set up e-mail logging in NAV5.0
Demo Center for Microsoft Dynamics NAV 5.0 W1. Here you can find some demo VPC's.
Released platform hotfixes and rollup updates for NAV 5.0

Version	Update	Build No.	KB number	Info
4.0 SP3		25143
	Update 1	24080	931841	included in 4.0SP3!*
	Update 2 – NODBC		Not released	included in 4.0SP3!*
	Update 3	24219	933727	included in 4.0SP3!*
	Update 4	24449	936602	included in 4.0SP3!*
	Update 5	24734	938138	included in 4.0SP3!*
	Update 6	25143	940718	included in 4.0SP3!*
	Update 6.1	25307	943227	F4 Delete function behaves inconsistently when pressing CTRL+A to select all records
	Update 6.2	25638	945349	Locks are not released as expected
	Update 6.3	25709	946247	NAV crashes when saving an object with large amount of text constants
	Update 6.4	25726	945992	Crash when processing messages from MSMQ
	Update 6.5	25732	945339	Error when renaming record: "you cannot rename a record because the new value is ''"
	Update 6.6	26033	948302	NAS stops responding to events when a lock timeout occurs
	Update 6.7	26170	949866	NAV ignores specified printer tray selection when printing a file from second page or later
	Update 6.8	26410	950920	Slow performance when browsing a list in a form
	Update 6.9	26565	952355	Dynamics NAV client stops respoding when NAV calcs a SIFT
	Update 6.10	26708	952873	Error message when you open a company in NAV 4.0: "Property exceeds the buffer size"
	Update 6.11	26752	953313	?????????????????
	Update 6.12	27010	954342 954722	Several issues when filtering an list form
	Update 6.13	27256	957275	NAV crashes on citrix if captions contain an ampersand
	Update 6.14	27742	959165	Inconsistent behavior when you search for the "RecordRef" data type records in different Windows operating systems and Microsoft Dynamics NAV versions
	Update 6.15	27765	959822	Error when printing a report: 'FORM NAME' cannot close because the system is currently working
	Update 6.16	27857	959656	Error when lock time-out occurs: "Function sequence error"
	Update 6.17	28477	965225 965224	The characters that indicates an empty HTML cells are incorrect displayed as "&nbsp" 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
	Update 6.18	28541	967469	Error message when you open a table in the Design mode in Microsoft Dynamics NAV 4.0: "Error 2 in module 5"
	Update 6.19	29021	970383	The BLOB data type cannot be performed on the RecordRefs object in Microsoft Dynamics NAV 4.0
	Update 6.20	29113	971172	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
	Update 6.21	29723	975345	The last Outstream.Writetext statement is not considered by the string.LEN function or the string.TRUNC function in Microsoft Dynamics NAV 4.0
	Update 6.22	29821	975988	You experience slow performance when you browse some forms in Microsoft Dynamics NAV 4.0 with Service Pack 3
	Update 6.23	29961	976327	The Microsoft Dynamics NAV 4.0 client crashes when you delete a record in a List form by right-clicking Delete
	Update 6.24	30033	976911	Error message when you try to change a table that has a primary key field defined by using Variant as the SQL data type in Microsoft Dynamics NAV 4.0: "Invalid cursor state"
	Update 5.25	30377	978895	You experience slow performance when you restore some companies into a Microsoft SQL Server database in Microsoft Dynamics NAV 4.0 SP3

Some interesting version-specific links:

Summary of Dynamics NAV 4.0 Service Pack 3 Build Numbers

Version	Update	Build No.	KB number	Info
4.0 SP2		22100
	Update 1	22611	919407
	Update 2 – NODBC	22851	921893
	Update 3	23099	922695
	Update 4 – NODBC	23460	927113	Update 3

Version	Update	Build No.	KB number	Info
4.0 SP1		21666
	Update 1	21990	913523
	Update 2 – NODBC	22373	912791
	Update 3	22363	915455

Version	Update	Build No.	KB number	Info
4.0		19365
	Update 1	20942	890551
	Update 2	21871	908918	Update 1
	Update 3	21990	911653 911654	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

Version	Update	Build No.	KB number	Info
3.70.B		19516
	Update 1	19868	890640

Manuals

Microsoft Dynamics NAV Local Functionality

Product Information/Updates

Interesting downloads:

Microsoft Dynamics Mobile:
- Product Release
- Evaluation edition
Database Archive for Microsoft Dynamics NAV: You need a db from Navision Financials 1.00? You can find it here.. .
Upgrade Toolkit Archive for Microsoft Dynamic NAV: really cool site to give you access to all info you need to update form very early versions (Navision Financials 1.00) to 5.00 SP1.
Microsoft Dynamics NAV Tools Overview: an overview of all Microsoft Dynamics Nav related tools, like: Tools CD, Upgrade Toolkit, Database Resource Kit, Developer's Toolkit, …

Blogs:

Other interesting links:

KB articles that were added in January 2008, February 2008 and March 2008
Updates for general distribution for NA version of Microsoft Dynamics NAV
Microsoft Dynamics PartnerSource RSS Feeds: Most interesting (imho) are:
- RSS feed for the most recent Knowledge Base Articles
- RSS feed for Microsoft Dynamics NAV News
North American Support Site for Microsoft Dynamics (A LOT of links to find about NAV 5.0, NAV 5.0 SP1, NAV2009, SQL Server, Security, ...)
More information about Certified for Microsoft Dynamics:
- Fact Sheet
- List of current certified products
- Microsoft Dynamics Solution Finder for detailed solution descriptions
- Customer information
Knowledgebase Search Engine
NAV 2009 Developer and IT Pro Help is on MSDN

Remarks

The text in italic and yellow means that that peace was added or changed since last update.

NAV 2009 Reporting: Document Map

waldo — Thu, 04 Mar 2010 20:32:59 GMT

Here is a new blog entry about a feature that comes available thanks to the RDLC we can use in NAV 2009. Called "Document map". A document map is a navigation feature that you know form PDF. In some PDF's you can browse to the chapters in the document. Something like this:

In Microsoft Word 2010, if you use the Header-formats, you get this out-of-the-box:

You can use this in your RDLC-layout as well. It works with groupings. A group-title (if I may call it like that) is some kind of "title" of a certain group of data. You can compare it with a title of a paragraph in a word or pdf document. Let us work this out with an example (a complete useless idiotic example, as always ... you know ... I've got the creativity of a canary (and nothing more)): we'll create a report on Item Ledger Entry, grouped by Location code and Entry Type. I know, it doesn't make sense, but it gave me enough data to show you the concept.

Let's do the report:

I created the dataset with the report-wizard ... A list-style document with these columns:

Entry No.
Item No.
Posting Date
Entry Type
Document No.
Description
Location Code
Quantity

Furthermore, no groupings (we'll do that in Visual Studio when defining the layout) and finished! If you would run this report, it would give you this result:

That's it, we've got the dataset. Now, let's define the RDLC layout. I'm lazy, so I don't want to start from scratch .. therefore, let's click "Tools"/"Create Layout Suggestion". You'll open a Visual Studio (or another RDLC editor)(if you want to know what you need for this, please read my blog entry about it) and the layout will be there.

You see, just a default layout like we had in the NAV Report Designer. We'll change this, because we want to have a document map example ... .

I want to group on "Location code" and "Entry Type", so first I sort on the key (I would recommend to add a key for this, and use this in your dataset - but it seems it's not necessary (my report worked fine without the key)):

Go to the properties of the table
Go to the Sorting tab
Add:
- =Fields!Item_Ledger_Entry__Location_Code_.Value
- =Fields!Item_Ledger_Entry__Entry_Type_.Value

For a better look, I'll move those two columns to the front (you can do this my cut/past). The, I'll add the grouping:

Go to the properties of the table again
Go to the Groups tab
Click Add
Group on Location code
Uncheck the "Include Group Footer" option

Do the same for the "Entry Type" field.

Now, we've got two groups .. to make this a little bit clearer, just move the expression of the location code to its grouping level, and the same for the Entry type. You'll get something like this:

If you run the report by now, you would get something like this.

Now, this is not new. Just a grouping, nothing more, nothing less.

But how do I add that bloody Document Map?

Well, just go back to your RDLC-layout design in Visual Studio, and go to the properties of the table, and to the Groups-tab:

Edit a group. There you'll find the "Document Map Label"-property. Here, you have to fill in the expression of what your label should be in the document map. I want it to be exactly the same as my Location Code, or Entry Type, so I use that value. Just copy the expression into the Document map:

Do this for both Location Code and Entry Type.

When finished, save the layout, and run your report again:

On the left you'll see a treeview, which is your document map. Just click on the value's and it will navigate you through the resulting report.

How cool is that? :-)

If you would think it would stop here ... you're wrong. Just export your report to Excel or PDF. You'll find your document map again. Here is a screenshot of Excel, where it creates a separate sheet "Document Map" with hyperlinks to the resulting report:

While in PDF it creates bookmarks to the position in the document:

Only issue here is that you don't see the indentation anymore ... but I can live with that :-).

Enjoy!

Ps, you can download my report here. Nothing fancy, just to show you the basics of the Document Map possibilities.

The 2010 VAT Update: NAV 2009 SP1 objects available

waldo — Thu, 18 Feb 2010 15:52:40 GMT

The objects for NAV 2009 SP1 of the VAT2010 update are available as from today. As you might have been waiting for this (we haven't .. created our own NAV 2009 objects...), finally they're here. Go and finnish your last updates!

Here is the landing page for partners.

This is for the Belgian localization (for now), but I'm sure the rest will follow real soon.

(funny, BE version of NAV2009 was release more then a year later then the W1 release ... but, NOT for the VAT2010 update! - things are looking gooood (always look on the bright side of life .. tudum .. tududidudidum))

New Statement of Directions: Where is NAV '7' going to …

waldo — Mon, 15 Feb 2010 07:01:00 GMT

Since the hassle I got with my previous post, I'm not sure anymore what I'm allowed to post, and what not... . Sometimes, I've got the feeling that it's not a "straight border" or how do you call it in English .. it's not clearly defined. It's seems more like .. "It doesn't feel appropriate, so you're not allowed to".

Anyway, same with this post. The Statement of Directions (SOD). We're not allowed to distribute the document, but we ARE allowed to share the contents with customers and prospects (so I read this as: EVERYONE). Now, my previous post about SOD wasn't a problem, so I'm sure this isn't a problem either :-).

When you read the document (which partners can download here), you'll notice that everything that's in it, is "what they are focusing on", which means they will try to get in the next release, but every topic is subject to be removed from the scope. This seems obvious to me, really. This is common sense. There isn't a definite release date for NAV '7' (which is a codename) yet, and why and how would they be able to clearly say what's definitely going to be in it?

So, read this article as: they are putting every effort in getting this into the next release, but it could be that it's not going to make it... .

Welcome to the "Statement of Directions" :-).

If you read through the document, you'll find there is a lot they are focusing on. As I'm not really into the functional part of NAV, you have to excuse me that the things I'm going to mention, could not make sense to you, as they definitely make not much sense to me either ;°)

It's a good thing Microsoft still focuses on the right things:

Simplicity
Productivity
Interaction with Microsoft Technology
User Experience
Rapid Time-to-Value

This doesn't say much to you, does it? Well, I will try to go into a more concrete level. Here we go:

On functional level:

Connect with Dynamics ERP. I don't know if you ever heard about it. You can see it as some kind of cloud services. Dynamics NAV will connect with the cloud services that Microsoft is going to build. More about this when more about this is available .
Financial management. People are going to put a lot of work into:
- creating a solid foundation on which to build and deliver environmental management accounting and compliance capabilities.
- enhancing electronic Payments
- creating electronic Invoicing
- ...
For Sales & Marketing it seems that the most important new thing is going to be a "NAV-CRM Connector". I hear you know thinking "FINALLY" :-). Not unimportant: you're going to be able to extend this connector.
What about Service Management? It's clear that in general, they will focus on a closer integration with other application areas such as Jobs, Resource mgt, Warehouse, Distribution and MS Dynamics CRM (via the connector)
The Manufacturing-granule is also something they are going to put a lot of work in in following areas:
- Production planning overview
- Tracking and analyzing of plans,
- Prioritization
- Subcontracting
- Integration with the job module
  
  --> one planning for all resources
- Increased client extensibility and visualization capabilities (is that a visual planning?)
On top of these functional areas, there will be some improvements in these as well .. where I'm not going into detail (because I was bored with the functional stuff, and wanted to get into the technical stuff - there wasn't much more, believe me .. just read the document):
- Warehouse & Distribution
- Jobs and Project Management
- Resource Management
- Business Intelligence

On Partner productivity (which is mostly "Technically Speaking"):

Improvements to the Page Designer.
- More graphical page designer. When I read this, I guess there is going to be some kind of preview or whatever. Something where you can clearly see what consequences will a particular change have on a page (visually).
Discontinuation of forms. This is stated more then once in the document, so I really think this is a strong focus of the development team. This also means many things:
- You'll HAVE to go RoleTailored
- You'll HAVE to go on SQL Server
- ...
Ability to debug on the NAV Server in C/AL. Is this a new debugger? Yep, it is! And this one is going to show you the C/AL code, not the C#.
MS Dynamics Sharepoint Integration Framework. This can mean a lot of different things. But let's just think they're going to create a framework where it's possible to publishe pages into a sharepoint web part ;°).
Adminstration from within the RTC. Now, it's not possible to e.g. Create users within the RTC. You have to use the classic for that. They will put a focus on "not having to do that anymore".
.NET interoperability: allowing .NET to be accessed from C/AL. Now, isn't THAT cool?
Query designer. Now, Finally: Now, building a report meant, building a data set, then, building a RDLC. But what if I want to reuse that dataset? Or what if something changes? Multiple datasets had to changes. In next release: they will try to create a query which you can use for multiple reports. On top of this, you will get a RDLC-wizard. This is less useful in my opinion, because RDLC is quite easy to do.
Improved client extensibility: Easy deployment.

So, what about User productivity:

Improved integration with sharepoint is obviously a very important part of "user productivity".
Extend integration with office 2010
- Timesheet mgt
- Customer report generator
Support for unified communication. Cool. Although I don't have customers yet that use UC ... .
Easier reporting for customers by SSRS & Report Builder. Are they going to foresee something in this Area?
Ability for ad hoc reporting in Excel. Hm. And what about JetReports? Is it going to be useful after this?
More charts and KPI's.
Improved page layout options and other enhancements that make it easier for the user to enter and view data. Whatever that's going to be....

Other Technical Improvements. Not unimportant and definitely worth mentioning:

No support for C/SIDE Databases. Isn't that a ***? That means: guys, get yourself migrated to SQL Server!
Support to easily consume web services. True. Consuming web services still is a b***h. Apparently, they're working on a solution :-).
Improved integration with outlook (large synchronizations would go easier and faster)
64 bit service tier. One word: YES! :-).

So, dibbededibbede, that's all, folks. That's all I would like to share with you concerning the SOD. Again, there are NO PROMISES. There are FOCUS points. And if you ask me: there is a LOT to look forward to, so Microsoft, keep up the good work, and try the get everything in !

For partners, it's always a good idea to follow the focus and strategy of Microsoft. For example, don't go building you own solution to consume web services, or at least, don't put too much work in it, because Microsoft is going to provide you a solution ... or at least ... is probably going to provide you one. Now you know the strategy and directions of Microsoft, so try to build your own strategy around it: the discontinuation of forms and no support for native databases are quite clear points in this.. .

Enjoy!

The 2010 VAT Update: bug in the bugfix!

waldo — Wed, 03 Feb 2010 19:45:00 GMT

*** REMOVED ***

I had to remove this article, because I accidently used inside information, and I wasn't allowed to warn you all ... obviously. Anyway, all KB articles from my previous blog are up-to-date and everything is fine now:

http://dynamicsuser.net/blogs/waldo/archive/2010/02/02/the-2010-vat-update-warning-bug.aspx

The 2010 VAT Update Warning: Bug!

waldo — Tue, 02 Feb 2010 14:32:42 GMT

It keeps bugging us. We thought we were finished with the update of all our customes .. But nooo. There is a bug. There has been found a minor issue with "item ledger entries for EU services that are added to the Intrastat journal lines in Microsoft Dynamics NAV with VAT 2010 Update installed".

More information you can find here:

KB 979746 for Dynamics NAV 4.0 SP3,
KB 979747 for Dynamics NAV 5.0 SP1, en
KB 979748 for Dynamics NAV 2009 SP1

It comes down to a change in report 594. It's going to fetch EU-service entries from the Job Ledger Entry table ... and that's not allowed.

So it's up to you. We're going to update all our customers ... AGAIN ... because in my opinion, we have to. If customers don't us it now, but going to use it in the future, then they need this fix anyway.

The BDC Connection Day: Software + Services Review

waldo — Mon, 01 Feb 2010 08:45:08 GMT

It's over, finished, done, happened, ... and I think we can say: it was a success . I had a few attendees that were saying that this was one of the most interesting evening events we ever organized. People were really happy they spared the time to come over .. it was worth it.

At least .. that's what they told me [:/].

We slightly changed the approach this time. In the first "Connection Day", we had simply four concurrent session. There, we noticed that people just tend to go to the session of their product, not a general session. And that's too bad for the general session .. because that should be equally interesting as well.

Now, we decided to go for a general session, followed by three product-specific sessions. This means: still four sessions, but one "keynote" session that everyone could attend.

Keynote Session - Living on the cloud: software and services - Luc Van de Velde

Two words: very interesting. For quite some time now, people (and mainly Microsoft) have been talking about .. "the cloud" or "cloud computing" or ... . But what is it all about? Is it hosting? Is it something else? Is it really putting some servers on higher level (in the clouds) and beam the data down? (ridiculous, I know, but I couldn't resist :-) ). Luc explained it very well. It all comes down on putting stuff (software )on the web and letting people use it when they want (services). And the goal is: people only pay for the usage. If they don't use it, they don't pay for it. Luc talked about the services which are there, the services that are coming .. and what the price model is going to be (paying for usage, kind of services, band with, ... stuff like that). To explain it, Luc used the comparison with a pool:

On Premises: you can buy a pool for your own house. But you have to pay for the entire pool, plus maintenance and all that...
Shared (like hosting): you can use a pool in the building complex you live in. Many people will use it. Many rules apply. You pay for it, also for the days you don't use it.
Cloud: you buy a ticket for a pool when you want to swim. It's available when you want it to be available, and you pay for it when you use it, for the time you use it.

What services do they bring in the cloud? This was a bit unknown for me. They talk about operating systems, development abilities, Windows Azure, SQL Server services, PHP, ... . I strongly suggest you download the PowerPoint when it comes available on the download section of the Belgian Dynamics Community site. You'll see the necessary schema's to understand all the things they are bringing to the cloud .. and you'll realize it's time to put a little bit less time in twittering your Facebook .. and get yourself familiar with "the cloud".

NAV Session - How Dynamics NAV could work together with Dynamics Online - Jesper Lachance Ræbild

Dynamics Online? What's that?
Jesper also receives our newsletter and saw that we were doing an evening about S+S. He volunteered to speak about "Dynamics Online" .. stuff in the cloud that is there, and where Dynamics (NAV, AX, .... doesn't matter) can connect with. Again, for NAV people: very interesting off course.

You could see an online payment platform, provided by Microsoft, and integrated in Dynamics NAV 2009 . The scenario of the demo: we saw that someone (named Eric Wauters ) was buying something and wanted to pay with VISA. The complete VISA handling (authorization, balance check, and what-else-does-a-credit-card-payment-has-in-its-standard-flow..-) was done in the cloud, behind the scenes, when you were still just working in NAV, swiping the card, getting the authorisation - it was a "good card" (it was mine, off course it's good ;°) ), posting the invoice, getting the payment confirmation.

May be the fact that it was so "simple" and so "integrated" made people a little bit wondering "is it safe", "is that allowed". Off course. You really think Microsoft is putting something like this out there ... and didn't check that legal requirements??

Very cool demo .. very cool upcoming functionality. Thank you, Jesper, for coming over to Belgium to show that!

NAV Session - How to extend NAV 2009 with Web Services - Eric Wauters

This was my session :-) (yep, I'm Eric). I'm not going to say whether it was good or not, that's for other people to decide (I didn't get any results of the evaluation forms until now either (may be that's a good thing )). But the fact that some high school teachers approached me after the session to ask me whether I wanted to visit their school and do a lecture there about this topic .. made me feel quite confident that it went well :-).

About 9 months ago, I had a session for the Belgian community about web services. Back then, I tried to show the people what could be done. Showing some cool examples. But I didn't show HOW they were built, or what it meant to build something like that.

Exactly THAT was the goal of this evening. I tried to create a technical background session for Web Services. The audience that I was expecting was indeed technical, so that was good ;°). I built some web services complately from scratch on stage to convince the simplicity. I showed different options of building web services(working with XMLPorts, extend with codeunits, pages, ... ) and tried to explain it technically. I explained how Freddy's popular "EditInExcel" application works .. and tried to go a little bit beyond by explaining how to work with the web services from "other technologies" (java, php, javascript,...).

You see, I used Freddy a lot in my presentation .. but let's be honest ... Freddy's blog has become the "Mekka" of Dynamics NAV 2009 Web Services. Why shouldn't I be using it? Thanks, Freddy! .

You'll find pictures and downloads of the presentation soon enough on our site of the BDC. So just watch the site being updated (and if you can't resist ... you can subscribe to the news letter as well ).

Enjoy!

BDC: Connection Day - Software + Services

waldo — Wed, 20 Jan 2010 17:43:00 GMT

It has been a while since I posted an update on the Belgian Dynamics Community (BDC). You know, "the thing" that we (a few others and me) started two years ago. "The thing" .. being a community that organizes events (some info evenings about a number of topics regarding the Microsoft Dynamics products). In the beginning, it was all about Microsoft Dynamics NAV ... but now, also AX and CRM evenings are organised. So, I think we can say it has grown to a full worthy "Dynamics" Community, isn't it?

You can imagine .. three products, 6 evenings per product per year is 18 evenings, plus some customer visits and such ... it involves quite some work. To do this a little bit "efficiently", we came up with the concept of "Connection Days". The concept is to organize one evening, for all three products ... about the same topic. Last time we had the topic "Business Intelligence". It was a very (VERY) succesful evening. We had to stop the registration about one week before the event, because we already had 100 attendees (which is the limit ... If we only had an unlimited amount of money ). The sessions were good .. . The only negative feedback we got was that people got something else that they expected. Too technical for functional people, too functional for technical people. Let's say ... the session description seemed to have been quite vague ... .

That's the reason I write this blogpost. I would like to give some more information about the upcoming event, next week on the 28th of January.

This time, it's the same deal. We already have over 100 people registered, so we're putting every effort into it to make it worthwhile. The topic this time: "Software + Services".

As this is a NAV blog (and I'm BDC Product Lead (or how do you kids call it these days ...) for NAV ... so can't go into detail for the other products...), I will only talk about the NAV session that will take place.

Originally, the topic of the NAV session was simply " Extending the Value of Dynamics NAV with Web Services ". The intention was to make it a purely technical session. Why? I have been giving quite some sessions about Web Services, but never went into code ... while every time, technical people were in the room (one might expect when doing a session about web services ...), and every time, I got the comment that "I didn't go technical enough". This time, it was (is..) time for code. And that's what we have been communicating.

Now, people in Denmark seem to be following the happenings at the BDC as well .. and noticed we were doing sessions about S+S. They found it so interesting they volunteered to participate. Jesper Lachance Ræbild is flying over to Belgium, especially to join our NAV Session. This is something we couldn't refuse, because it makes the evening so more useful. Why?

Jesper is going to talk about Dynamics ERP, Hosting and "Attached Services". Microsoft is releasing services "in the cloud" that we, as NAV consultants, will be able to easily attach our NAV System with. There is already one useful service ... which I will not reveal just yet. That's for during the session. Curious, are yah? ARE YAH?? (Okay Okay, I will be writing a review to keep everyone up-to-date ;°)).

Anyway .. that means the agenda for the NAV session is slightly going to change. First we will have Jesper with "the stuff in the cloud" ... things you should know for understanding the value of Software + Services. After ... you will still have the technical part, that will be hosted by myself (sorry if that is a disappointment ..). So, first the "bla bla", then the "boom boom".

Looking forward seeing you there ... and for those who can't attend ... watch the blog for the review.

The 2010 VAT Update: License update required!

waldo — Thu, 14 Jan 2010 20:53:00 GMT

This week, there were many confusions about the VAT 2010 issue ... apparently people forgot to update the license of the customers. This license update is needed because of the fact new objects were created ... so a new range had to be supported. Quite logical, but not a cat thought of it (as they say in Belgium).

You can imagine, upgrading all licenses of your customers might take a while .. especially when you know the EOC online app, and the flow to request the updates. Luckily, Microsoft is helping us out for this. All customers with an active BREP will be updated by them without request ... you'll just have to manually download them.

Here is the official story:

As was written in the release notes of the VAT 2010 Report Pack for Microsoft Dynamics NAV (yeah yeah .. we don't read those, guys ... get real ), a License update is required for every customer that needs the VAT 2010 update. In order to save some time, EOC will automatically update all the Microsoft Dynamics NAV licenses under active BREP for Belgian partners. Customers who do not have an active BREP will not be able to receive the update.

At the latest on Tuesday next week, this update will have been done by EOC. You will receive an email from EOC with the list of all customers where the licenses will have been updated When a customer is missing, you, as a partner will have to do a CLT request for every customer that is missing. The updated license key will be at your disposal in Commerce as soon as the update has been done.

As you can read, this is the case for Belgium. I don't know if other countries are treated the same way... . If you don't know .. here's a good reason to check with your local Microsoft office (no, not the software... ).

So, I guess this is why customers need to pay for maintenance?

Dynamics NAV 2009 AddIn Treemap Officially Available!

waldo — Wed, 13 Jan 2010 22:30:00 GMT

I don't know if you've ever seen a demo of the "Dynamics NAV 2009 SP1 Treemap"-addin. No? Here is a screenshot:

It's actually another view on the "Customer List". People who have ever seen the Performance Point "TreeMap"? This one is quite the same. It gives you a customer list with the most important customer bigger then less important customers. In fact, you can set this up yourself with the parameters on top of the graph.

This is Microsoft's explanation:

The Treemap Business Data Visualization for Microsoft Dynamics® NAV provides a unique view on business data. It can provide insight from different data perspectives and can be used to help identify outliers and actionable items. Combined with histogram-based visual filtering and integration into business logic and the user interface (UI) of the RoleTailored client, this is a powerful tool for end users.

This AddIn is now available for Microsoft Dynamics NAV … officially (and supported!). You (partners) can find the application files here and the whitepaper here.

Enjoy!!

NAV 2009 Reporting: Paper Orientation

waldo — Mon, 11 Jan 2010 10:25:00 GMT

When you're planning to print reports from the new RDLC layout, things have been changed. One of the things is: how do I print this damn report in landscape?? With the new matrix-report possibilities, one might expect to have too many columns to print it in portrait.

Well, keep in mind that in the RoleTailored client, the properties PaperSize and Orientation (that we know as report-properties in the Report Designer) are obsolete. This means: you can do whatever you want with it .. the printout won't take these properties into account.

So, how DO I set the size and orientation then?

That part, I could not find in the manual (in the 10 minutes I searched for it .. sorry). But I did find it online. And it's quite simple. I was searching for literally the "orientation" or "size" keyword, but actually all I needed is the Report Properties in the RDLC layout (Visual Studio):

As you can see, you can set the page width and height. For example an A4 paper size:

In Portrait:
- Page Width: 21cm (8,3in)
- Page Height: 29,7 (11,7in)
In Landscape:
- Page Width: 29,7 (11,7in)
- Page Height: 21cm (8,3in)

It's all manually in the Layout-tab of the Report Properties.

Hope this is helpful!

The 2010 VAT Package Whitepaper: Report objects available

waldo — Tue, 05 Jan 2010 11:26:00 GMT

Like Mark already mentioned in his blog: the first report-objects are available. This means some countries can finish the upgrade process for their customers.

I'm posting this extra blog to mention to you that the table has been updated again … and now … the Belgian objects ARE available . I suggest you check this table on a daily basis to know if you can start the upgrades in your country

Warning!
Furthermore … watch what you're doing. If you're upgrading the reports now, see that the VAT Reporting of December 2009 is still legal. So, you don't want to update the report objects when the reporting of previous month has to be done by the legal requirements of 2009. You will have to work around that, if it's requested by your country (or the country that you're upgrading).

I'm working on this as we speak, so I don't have a workaround myself just yet. I just wanted to give this as a warning.

This is the complete list:

Country/Version	Microsoft Dynamics NAV 4.0 SP3
Worldwide (w1)	Complete (data + reporting):
Worldwide (w1)	VAT2010_DAT_W1_NAV4.0SP3.exe
Austria	Complete (data + reporting):
Austria	VAT2010_FULL_AT_NAV4.0SP3.exe
Belgium	Data part:
	VAT2010_DAT_BE_NAV4.0SP3.exe

	Report part:
	VAT2010_REP_BE_NAV4.0SP3.exe
Bulgaria	Data part:
Bulgaria	VAT2010_DAT_BG_NAV4.0SP3.exe
Czech Republic	Data part:
Czech Republic	VAT2010_DAT_CZ_NAV4.0SP3.exe
Denmark	Data part:
Denmark	VAT2010_DAT_DK_NAV4.0SP3.exe
Estonia	Data part:
Estonia	VAT2010_DAT_EE_NAV4.0SP3.exe
Finland	Data part:
	VAT2010_DAT_FI_NAV4.0SP3.exe

	Report part:
	VAT2010_REP_FI_NAV4.0SP3.exe
France	Data part:
France	VAT2010_DAT_FR_NAV4.0SP3.exe
Germany	Data part:
	VAT2010_DAT_DE_NAV4.0SP3.exe

	Report part:
	VAT2010_REP_DE_NAV4.0SP3.exe
Greece	Data part:
Greece	VAT2010_DAT_GR_NAV4.0SP3.exe
Hungary	Data part:
Hungary	VAT2010_DAT_HU_NAV4.0SP3.exe
Italy	Data part:
Italy	VAT2010_DAT_IT_NAV4.0SP3.exe
Latvia	Data part:
Latvia	VAT2010_DAT_LV_NAV4.0SP3.exe
Lithuania	Data part:
Lithuania	VAT2010_DAT_LT_NAV4.0SP3.exe
Netherlands	Data part:
	VAT2010_DAT_NL_NAV4.0SP3.exe

	Report part:
	VAT2010_REP_NL_NAV4.0SP3.exe
Poland	Data part:
Poland	VAT2010_DAT_PL_NAV4.0SP3.exe
Portugal	Data part:
Portugal	VAT2010_DAT_PT_NAV4.0SP3.exe
Romania	Data part:
Romania	VAT2010_DAT_RO_NAV4.0SP3.exe
Slovakia	Data part:
Slovakia	VAT2010_DAT_SK_NAV4.0SP3.exe
Slovenia	Data part:
Slovenia	VAT2010_DAT_SI_NAV4.0SP3.exe
Spain	Data part:
Spain	VAT2010_DAT_ES_NAV4.0SP3.exe
Sweden	Data part:
	VAT2010_DAT_SE_NAV4.0SP3.exe

	Report part:
	VAT2010_REP_SE_NAV4.0SP3.exe
United Kingdom	Data part:
	VAT2010_DAT_GB_NAV4.0SP3.exe

	Report part:
	VAT2010_REP_GB_NAV4.0SP3.exe

Country/Version	Microsoft Dynamics NAV 5.0 SP1
Worldwide (w1)	Complete (data + reporting):
Worldwide (w1)	VAT2010_DAT_W1_NAV5.0SP1.exe
Austria	Complete (data + reporting):
Austria	VAT2010_FULL_AT_NAV5.0SP1.exe
Belgium	Data part:
	VAT2010_DAT_BE_NAV5.0SP1.exe

	Report part:
	VAT2010_REP_BE_NAV5.0SP1.exe
Bulgaria	Data part:
Bulgaria	VAT2010_DAT_BG_NAV5.0SP1.exe
Czech Republic	Data part:
Czech Republic	VAT2010_DAT_CZ_NAV5.0SP1.exe
Denmark	Data part:
Denmark	VAT2010_DAT_DK_NAV5.0SP1.exe
Estonia	Data part:
Estonia	VAT2010_DAT_EE_NAV5.0SP1.exe
Finland	Data part:
	VAT2010_DAT_FI_NAV5.0SP1.exe

	Report part:
	VAT2010_REP_FI_NAV5.0SP1.exe
France	Data part:
France	VAT2010_DAT_FR_NAV5.0SP1.exe
Germany	Data part:
	VAT2010_DAT_DE_NAV5.0SP1.exe

	Report part:
	VAT2010_REP_DE_NAV5.0SP.exe
Greece	Data part:
Greece	VAT2010_DAT_GR_NAV5.0SP1.exe
Hungary	Data part:
Hungary	VAT2010_DAT_HU_NAV5.0SP1.exe
Italy	Data part:
Italy	VAT2010_DAT_IT_NAV5.0SP1.exe
Latvia	Data part:
Latvia	VAT2010_DAT_LV_NAV5.0SP1.exe
Lithuania	Data part:
Lithuania	VAT2010_DAT_LT_NAV5.0SP1.exe
Netherlands	Data part:
	VAT2010_DAT_NL_NAV5.0SP1.exe

	Report part:
	VAT2010_REP_NL_NAV5.0SP1.exe
Poland	Data part:
Poland	VAT2010_DAT_PL_NAV5.0SP1.exe
Portugal	Data part:
Portugal	VAT2010_DAT_PT_NAV5.0SP1.exe
Romania	Data part:
Romania	VAT2010_DAT_RO_NAV5.0SP1.exe
Slovakia	Data part:
Slovakia	VAT2010_DAT_SK_NAV5.0SP1.exe
Slovenia	Data part:
Slovenia	VAT2010_DAT_SI_NAV5.0SP1.exe
Spain	Data part:
Spain	VAT2010_DAT_ES_NAV5.0SP1.exe
Sweden	Data part:
	VAT2010_DAT_SE_NAV5.0SP1.exe

	Report part:
	VAT2010_REP_SE_NAV5.0SP1.exe
United Kingdom	Data part:
	VAT2010_DAT_GB_NAV5.0SP1.exe

	Report part:
	VAT2010_REP_GB_NAV5.0SP1.exe

Country/Version	Microsoft Dynamics NAV 2009 SP1
Worldwide (w1)	Complete (data + reporting):
Worldwide (w1)	VAT2010_DAT_W1_NAV2009SP1.exe
Austria	Data part:
Austria	VAT2010_DAT_AT_NAV2009SP1.exe
Belgium	Version not available as of 12.2.09




Bulgaria	Version not available as of 12.2.09
Bulgaria
Czech Republic	Version not available as of 12.2.09
Czech Republic
Denmark	Data part:
Denmark	VAT2010_DAT_DK_NAV2009SP1.exe
Estonia	Version not available as of 12.2.09
Estonia
Finland	Version not available as of 12.2.09




France	Data part:
France	VAT2010_DAT_FR_NAV2009SP1.exe
Germany	Data part:
	VAT2010_DAT_DE_NAV2009SP1.exe

	Report part:
	Version not available as of 12.29.09
Greece	Version not available as of 12.2.09
Greece
Hungary	Version not available as of 12.2.09
Hungary
Italy	Data part:
Italy	VAT2010_DAT_IT_NAV2009SP1.exe
Latvia	Version not available as of 12.2.09
Latvia
Lithuania	Version not available as of 12.2.09
Lithuania
Netherlands	Data part:
	VAT2010_DAT_NL_NAV2009SP1.exe

	Report part:
	VAT2010_REP_NL_NAV2009SP1.exe
Poland	Version not available as of 12.2.09
Poland
Portugal	Version not available as of 12.2.09
Portugal
Romania	Version not available as of 12.2.09
Romania
Slovakia	Version not available as of 12.2.09
Slovakia
Slovenia	Version not available as of 12.2.09
Slovenia
Spain	Data part:
Spain	VAT2010_DAT_ES_NAV2009SP1.exe
Sweden	Version not available as of 12.2.09




United Kingdom	Data part:
	VAT2010_DAT_GB_NAV2009SP1.exe

	Report part:
	Version not available as of 12.22.09

Merry X-mas and a Happy New Year

waldo — Thu, 24 Dec 2009 12:31:00 GMT

This is going to be my last post of the year .. going skiing in a few days . I would like to wish all you guys and girls a Merry Christmas and a very healthy and Happy New Year !...(read more)

Platform updates overview - 3.70.B - NAV2009 SP1 (UPDATED 2)

waldo — Tue, 22 Dec 2009 16:08:56 GMT

It has been a while since I updated my table. Not many updates since last time. Probably because of the fact people have been working on the Group 2 releases, and VAT 2010 update? Or … all bugs are fixed and everything works perfectly? :-) I want to mention againthat Group 2 seems to be releasing their...(read more)

Halleluja! Group 2 is releasing NAV 2009 SP1!

waldo — Thu, 17 Dec 2009 08:16:00 GMT

Remember this post ? I was so glad that I could finally announce that there was at least a release date in Belgium. Now, today, December 17th 2009 (yes, still 2009!), sooner then announced, (but ok, still hundreds of days after the official world wide release of NAV 2009, but let's forget that for...(read more)

Waldo's Blog Microsoft Dynamics NAV

Platform updates overview - 3.70.B - NAV2009 SP1 (UPDATED 3)

NAV 2009 Reporting: Document Map

The 2010 VAT Update: NAV 2009 SP1 objects available

New Statement of Directions: Where is NAV '7' going to …

The 2010 VAT Update: bug in the bugfix!

The 2010 VAT Update Warning: Bug!

The BDC Connection Day: Software + Services Review

BDC: Connection Day - Software + Services

The 2010 VAT Update: License update required!

Dynamics NAV 2009 AddIn Treemap Officially Available!

NAV 2009 Reporting: Paper Orientation

The 2010 VAT Package Whitepaper: Report objects available

Merry X-mas and a Happy New Year

Platform updates overview - 3.70.B - NAV2009 SP1 (UPDATED 2)

Halleluja! Group 2 is releasing NAV 2009 SP1!

Waldo's Blog
Microsoft Dynamics NAV