Mohana’s Dynamics Blog

Please read complete post at

http://mohana-dynamicsnav.blogspot.in/2013/02/how-to-updatemodify-data-in-all.html

Today I encountered different behavior of DateFormula Datatype field in NAV2013 from NAV2009R2

Version: NAV2013 & Build 33781

1.      Create New table as below

I came across above error message while running a page in NAV2013. (while upgrading our NAV2009R2 solution to NAV2013)

This occurs mainly when TableRelation property of any field is having “Table0″ (table zero).

This can happen if we didnt have relation table in new database or by wrong merging etc.

In above case, simply go to source tabel and check all fields table relations and fix.

This procedure describes how to transform a MenuSuite object from the Classic client to a MenuSuite object that you can use in the RoleTailored client.

In the Classic client, you access forms and reports from the navigation pane, which displays menus that are contained in a MenuSuite object. In the RoleTailored client, you navigate to pages and reports by using the following elements:

Role Centers

Departments

You can transform a MenuSuite object that you use in the Classic client to a Departments page that you use in the RoleTailored client.

From Microsoft Dynamics NAV 2009, when you create a new MenuSuite object, you must select either the Classic client or the RoleTailored client as the target.

The ID of a MenuSuite object for the RoleTailored client will be the Classic client ID plus 1000, as demonstrated in the following table.

For this first we need to import Transformation Input File (TIF) Editor to classic client from Transformation Tool folder of DVD To import the TIF Editor

1. In the Classic client, click Tools, and then click Object Designer.
2. In the File menu, select Import.
3. In the Import Objects window, select the TIF.fob file, and then click Open.( from Transformation Tool folder of DVD)
4. In the dialog window, click Yes to import all objects.

To transform the MenuSuite object

1.      In the Classic client, on the Tools menu, click Object Designer.

2.      In Object Designer, click MenuSuite, and then select the MenuSuite object that you want to transform.

3.      To export the existing MenuSuite object from Object Designer to a text file, on the File menu, click Export.

4.      In the Export Objects window, select the location where you want to export the MenuSuite object. We recommend that you export the object to the same folder where the Microsoft.Dynamics.Nav.Tools.FormTransformation.exe file and the transformation input files reside.

5.      In the Save as type drop-down list, select Text Format (*.txt).

6.      Specify the name (Ex. MEN90) of the file, such as navigationpane.txt, and then click OK.

7.      In Object Designer, select Form, select form 177000, Transformation Forms, and then click Run.

8.      In the Transformation Forms window, click Functions, and then click MenuSuite Transformation.

9.      In the MenuSuites window, click Functions, and then click Import to import the navigationpane.txt file into the TIF Editor.

10.    In the Open File window, select the navigationpane.txt file that you created in step 6, and then click Open.

11.     Click Functions, and then click Show Menu to display all objects in the suite and their properties. After you review the objects in the suite, close the MenuNodes window. The following figure shows the MenuSuite objects in the TIF Editor.

12.  To transform the MenuSuite, in the MenuSuites window, click Functions and then click Make Suggestion. In the dialog box,         click Yes to confirm.

13. In the MenuSuites window, click Functions, and then click Validate to verify the result and find additional actions that you will need to take to modify the transformed MenuSuite object. The BadLink column specifies objects that are not in the database. The Comment column specifies menu items that you must delete manually, such as ignored forms or dataport objects. You will make the required modifications in Navigation Pane Designer after you export the transformed MenuSuite object.

14.Click Functions, and then click Show Menu. In the Menu Nodes window, note that the following new properties have been added to the items in the MenuSuite:

          1.IsDepartment 

          2.RunObjectType

          3.DepartmentCategory 

          4.New RunObjectID

If IsDepartment is cleared, then the menu item is a group heading only.

If IsDepartment is selected, then the menu item or group is a link.

Card pages are now replaced with list pages as the first access point when accessed from the navigation. This is specified in the Menu Nodes window by the New RunObjectID column, which references a list object, and the Department Category column, which specifies Lists.

15.To export the new MenuSuite object from the TIF Editor to an object text file, in the MenuSuites window, click Functions, and then click Export.

16.In the Save File window, select the location where you want to export the new MenuSuite object. We recommend that you export the object to same folder where the Microsoft.Dynamics.Nav.Tools.FormTransformation.exe file and the transformation input files reside.

17.In the Save as type drop-down list, select Text Format (*.txt).

18.Specify the name (Ex. MEN1090) of the file, such as departments.txt, and then click Save.

19.To import the new Departments MenuSuite object, in Object Designer, click MenuSuite, click the File menu, and then click Import.

20.In the Import Objects window, browse to the location where you created the departments.txt file.

21.In the Files of type drop-down list, select Text Format (*.txt).

22.Select departments.txt, and then click Open.

23.In Object Designer, select the new MenuSuite object, and then click Design. Make any modifications that were specified when you validated the MenuSuite object in step 13, such as deleting ignored forms or dataport objects.

24.In Object Designer, select the new MenuSuite object, click the Tools menu, and then click Compile. Click Yes to confirm compilation.

25.To view the transformed MenuSuite object, open the RoleTailored client and then select the Departments page. Verify whether you need to update the Departments page. For example, you may want to move items to other folders, delete folders, or change categories.

Till now, we are not able to remove the departments menu in navigation pane through “Customize Navigation Pane”

If you look at remove option for Departments is disabled in “Customize Navigation Pane” till NAV 2009 SP1 (Build 29626)

Now, Microsoft has released a HF to remove the Departments from 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.

The Remove Departments menu from Navigation Pane feature is implemented in Microsoft Dynamics NAV 2009 R2. (No HF application needed)

We can implement this HF only on builds 31671 or higher.

If your build is not 31671 or higher, please upgrade your build to 31671 by downloading KB ID: 2420354 from Partner Source.

Implement the above HF as per the instructions in the link

Note Before you replace the files in the Microsoft Dynamics NAV Classic client installation, you must close the Microsoft Dynamics NAV Classic client.

To implement Remove Departments menu from RTC Navigation Pane feature in Microsoft Dynamics NAV 2009 SP1 you must Download Article ID: KB 2496107 platform hotfix from Partner Source.

Implement the above HF as per the instructions in the link.

Note Before you replace the files in the Microsoft Dynamics NAV Classic client installation, you must close the Microsoft Dynamics NAV Classic client.

Now, restart the service and open RTC

You can remove the Departments menu from the Navigation Pane in the Customize Navigation Pane window by following these steps:

1. Click the Customize button at the top right corner of the Role Center or right-click on one of the Navigation Pane buttons in the Navigation Pane to open the Customize Navigation Pane window.
2. In the Customize Navigation Pane window select the Departments navigation pane button and select Remove.
3. Click OK.
4. Select Yes to restart the RoleTailored client.