List-page to Card-page relationship

To successfully create a logical relationship between a List page and Card page in RTC, perform the following steps:

  1. In Dynamics NAV classic client, go Tools || Object Designer || Page.
  2. Select the List page required || Click Design || Go to first blank line preceding the Field Controls
  3. Select the page properties (Shift+F4) || Page Properties Window Displays.
  4. In the Page Properties Window:
    1. Change the Value of Editable to NO.
    2. Change the Value of CardFormID to the Card Page required (Enter the object ID).
  5. Save and Compile the List Page.
  6. Test the List page :
    1. In Dynamics NAV 2009 SP1 –>> Select and Run the Object Designer :
      1. Double Click a Record, the Card Page for the Record Displays.
    2. Alternatively, In Dynamics NAV 2009 –>>  At Run cammand, type : DynamicsNAV:////runpage?page=<page ID> to invoke the Listpage
  7. The above simulates the logical relationship between Customer List and Customer Card in RTC.

SQL Attachments – Access to object tracking table denied

The Classic client allows attaching a SQL Server database from an .mdf file. When a database is attached this way, permissions to the object tracking table are not set correctly. The user under which the Microsoft Dynamics NAV Server service is executed needs permissions to this table. The service stops responding when you try to start the RoleTailored client, and the event log reports that access to the object tracking table was denied.

Resolution – Workaround

  1. Stop the Microsoft Dynamics NAV Server service.
  2. Stop the SQL Server service.
  3. Open a command prompt.
  4. At the command prompt, type the following command:
    Sqlcmd -d “Demo Database NAV (6-0)” -q “GRANT SELECT ON [dbo].[Object Tracking] TO [NT AUTHORITY\NETWORK SERVICE]”
  5. Start the SQL Server service.
  6. Start the Microsoft Dynamics NAV Server service.

System Requirement For Nav 2009

I have been involved in advising and deploying Microsoft Dynamics Nav 2009 to organisations. I often attempt to jog my memory on the software and hardware prerequisite, so I thought it might be useful to put this on my website for quick references. I have excerpted a Summary of system requirements for NAV 2009 as suggested by Microsoft, I’m sure there are individuals who might find this useful, especially if they cant quickly find the product media where all the documentation can be found.

Client Option Requirements

This section outlines the software and hardware that you need when you install the Client Option.

Read More