Recursive Error: Bill-To Customer

In Microsoft Dynamics NAV >>> Customer Card, a user enters the value of Bill-To Customer No. on the invoicing tab as the Value of Customer No. on the General Tab, the following error is triggered when user to use the customer:

Error message : “You must not specify Bill-to Customer No. in Customer customer no. = [nn]

Solution is to Clear the Bill-to Customer No., this is because Bill-to customer No. can only be defined where it is different from the customer No. in question.

How to apply the 6.0 Hotfix to the existing Demo Install

Usage Scenarios

4.1 You have downloaded the RTM image of Microsoft Dynamics NAV 2009 and want to update it with the Hotfix.

  1. Download the HF package from PartnerSource.
  2. Copy the updated database files into the existing database folders and overwrite the existing databases: Demo Database NAV (6-0)_Data.MDF, database.fdb, and database.fbk.
  3. Overwrite the existing form transformation tool files in the Transformation Tool folder with the updated form transformation tool files.

4.2 You have installed the demo database and want to update it with the Hotfix.

  1. Download the HF package from PartnerSource.
  2. Detach or delete the existing Demo Database NAV (6-0)_Data.MDF.
  3. Attach the updated Demo Database NAV (6-0)_Data.MDF from the HF package as described in the C/SIDE online help. To view the online help, on the Open Database form, click Help. In the Microsoft Dynamics NAV Classic Client Help, in the Open Database topic, click the Microsoft SQL Server Option for Microsoft Dynamics NAV link and then go to step 8.
  4. Overwrite the existing form transformation tool files in the Transformation Tool folder with the updated form transformation tool files.

4.3 You have downloaded the RTM image of Microsoft Dynamics NAV 2009 and want to update it with the Hotfix, and you have already started transforming custom forms to pages.

  1. Export language modules for all pages.
  2. Export forms.
  3. Retransform the forms, including report request forms, in your development database to pages by using the new form transformation tool.
  4. Import pages.
  5. Import language modules for pages.
  6. Retransform the forms in your development database to pages by using the new form transformation tool.
  7. Import the transformed pages and report request pages.
  8. Import the language module into the development database.

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.

Terminologies: Microsoft Dynamics NAV Software Updates

This article describes some standard terms associated with Software update in the scope of Microsoft Dynamics NAV.

Critical Update
Definition: A critical update is a broadly released fix for a specific problem that addresses a critical, non-security-related bug.

Feature Pack
Definition: A feature pack is new product functionality that is first distributed outside the context of a product release and that is typically included in the next full product release.

Hotfix
Definition: A hotfix is a single, cumulative package that includes one or more files that are used to address a problem in a product and are cumulative at the binary and file level. A hotfix addresses a specific customer situation and may not be distributed outside the customer’s organization.
Additional Information: Hotfixes are distributed by Microsoft Product Support Services. Customers may not redistribute hotfixes without written, legal consent from Microsoft.

Security Update
Definition: A security update is a broadly released fix for a product-specific, security-related vulnerability. Security vulnerabilities are rated based on their severity. The severity rating is indicated in the Microsoft security bulletin as critical, important, moderate, or low.

Service Pack
Definition: A service pack is a tested, cumulative set of all hotfixes, security updates, critical updates, and updates. Service packs may also contain additional fixes for problems that are found internally since the release of the product and a limited number of customer-requested design changes or features.

Software Update
Definition: A software update is any update, update rollup, service pack, feature pack, critical update, security update, or hotfix that is used to improve or to fix a software product that is released by Microsoft Corporation.

Update
Definition: An update is a broadly released fix for a specific problem. An update addresses a non-critical, non-security-related bug.

Update Rollup
Definition: An update rollup is a tested, cumulative set of hotfixes, security updates, critical updates, and updates that are packaged together for easy deployment. A rollup generally targets a specific area, such as security, or a component of a product, such as Internet Information Services (IIS).

Reference

Microsoft Dot Com : Microsoft Business Solution

* Critical Update
Definition: A critical update is a broadly released fix for a specific problem that addresses a critical, non-security-related bug.

* Feature Pack
Definition: A feature pack is new product functionality that is first distributed outside the context of a product release and that is typically included in the next full product release.

* Hotfix
Definition: A hotfix is a single, cumulative package that includes one or more files that are used to address a problem in a product and are cumulative at the binary and file level. A hotfix addresses a specific customer situation and may not be distributed outside the customer’s organization.
Additional Information: Hotfixes are distributed by Microsoft Product Support Services. Customers may not redistribute hotfixes without written, legal consent from Microsoft.

* Security Update
Definition: A security update is a broadly released fix for a product-specific, security-related vulnerability. Security vulnerabilities are rated based on their severity. The severity rating is indicated in the Microsoft security bulletin as critical, important, moderate, or low.

* Service Pack
Definition: A service pack is a tested, cumulative set of all hotfixes, security updates, critical updates, and updates. Service packs may also contain additional fixes for problems that are found internally since the release of the product and a limited number of customer-requested design changes or features.

* Software Update
Definition: A software update is any update, update rollup, service pack, feature pack, critical update, security update, or hotfix that is used to improve or to fix a software product that is released by Microsoft Corporation.

* Update
Definition: An update is a broadly released fix for a specific problem. An update addresses a non-critical, non-security-related bug.

Update Rollup
Definition: An update rollup is a tested, cumulative set of hotfixes, security updates, critical updates, and updates that are packaged together for easy deployment. A rollup generally targets a specific area, such as security, or a component of a product, such as Internet Information Services (IIS).