Tag: Table

Categories
Dynamics NAV Microsoft SQL Server

You do not have permission to read the Change Log Setup table

—————————

Microsoft Dynamics NAV

You do not have permission to read the Change Log Setup table.

—————————
OK
—————————

You do not have permission to read the Change Log Setup table

Cause:
The customer doesn’t have permission to read the Change Log Setup table with his license.
Someone activated and deactivated the Change Log functionality with developer license.
As result there is a blank line in the Change Log Setup table.

Solution:
Open the Change Log Setup table with developer license and remove the blank line.
Otherwise, if you have an installation with Microsoft SQL Server, you can delete this blank line directly running a query in SQL.

Did my solution solve your problem? Leave a reply.

Categories
Dynamics NAV HOW TO Microsoft

HOW TO change data for all Companies in NAV

HOW TO change data for all Companies?

You have different ways to complete this task, the choice depends from how many lines or Companies you have. In the following steps I will explain you how to change data for all Companies in C/SIDE using the CHANGECOMPANY Function (Record):

  1. Create a new ProcessingOnly Report using with the System Table 2000000006 – Company as Data Source of a DataItem.
  2. Declare a C/AL Globals Variable of DataType Record with the table that you need.
  3. Insert the following code in the OnAfterGetRecord trigger

    TO MODIFY

    [sourcecode lang=”Cside”]
    GLSetup.CHANGECOMPANY(Name);

    GLSetup.MODIFYALL("Allow Posting From", 010114D);
    GLSetup.MODIFYALL("Allow Posting To", 310114D);
    [/sourcecode]
    or

    TO DELETE

    [sourcecode lang=”Cside”]
    ChangeLogSetup.CHANGECOMPANY(Name);

    ChangeLogSetup.DELETEALL;
    [/sourcecode]

Here find another reading suggestion, this time in T-SQL: HOW TO run SQL query for multiple companies in NAV database

Did my HOW TO help you? Leave a reply.