This week I had a challenge to upgrade a menusuite for 5.x to a NAV2009 menusuite and found myself puzzled how to do it.
I 'solved' it by exporting the old menusuite to text and did a find and replace of Form with Page. This felt dirty so I started searching.
This is what I found, so for everyone else who is looking....
Microsoft has asked me to develop a tool to change all dates in a CRONUS database in one batch. Since a CRONUS database has about 40.000 dates it is handy to have a tool.The project is called 'Back to the future'.The tool is based on the SQL conversion tool but handles only and all dates.Enjoy...
The DateChange tool is designed to change ALL date fields in the database in order to apply a date formula.
NEVER, EVER implement this tool into a customer database. This tool is designed to maintain demo databases like the Microsoft Cronus system.
Keep in mind that changing the dates is a huge transaction that requires free space in the database.
A partner development license is a prerequisite. The tool also uses the IMPORTOBJECTS function in NAV2009.
Import the DateChange 1.00.fob file in the database and start codeunit 99991 Create Field Checking Code.
Compile and run codeunit 99993
After the execution, form 99990 Incorrect Data Values is automatically started. Here you can make manual or batch adjustments.
To make a batch adjustment, select some records and populate the DateFormula field.
When leaving the field the system asks permission to change the values
BE CAREFUL : There is no undo function!
After checking the values, implement the changes.
If the date field is part of the unique key of a record, then there is a small change that the record already exists. Especially with planning and calendar entries and the Accounting Periods.
These records should be manually changed.
Some time ago I reported two bugs in NAV build number 29113.
Microsoft has worked on this and released a new build number 29821.
My customer has tested it and the bugs seemed solved. Currently it is further tested.
This buildnumber is not yet on the official 'Waldo' list so if you want it, request it at Microsoft.
On September 30th 2009 I teached a workshop on NAV 2009 SP1 for developers in The Netherlands (and Waldo).
Here is a link to the powerpoint I used for this workshop.