TableData does not exist

—————————
Microsoft Dynamics NAV Development Environment
—————————
TableData 404 does not exist.
—————————
OK
—————————

TableData 404 does not exist

TableData does not exist

Cause:
You are trying to import from a fob file an existing table in which was changed the value of the property DataPerCompany.

Solution:

  1. delete the Table with number as from the error message (in my case it was 404)
  2. import the object

Related Post: TableData 2000000001 does not exist.

Did my solution solve your problem? Leave a comment.

HOW TO Copy from Excel and Paste as Picture without gridlines

The title of this post contains exactly the words I used to search on Google.
Why for this simple task I’m writing a post?
Because in this case, as happens often, the task is easy but we should know the logic behind the software and functionalities we want use.
To clarify the concept: we want

"Paste as Picture hiding gridlines"

rather then

"Copy as Picture without gridlines"

HOW TO Copy from Excel and Paste as Picture without gridlines?

The correct tile of the this post should be

HOW TO Copy as Picture without gridlines from Excel

Click Copy -> Copy as Picture…

Copy as Picture

Under Appearance section, select “As shown when printed“, then click OK

Copy Picture As shown when printed

When you’ll paste it, for example in a Word document, the image will be without gridlines.

Did my HOW TO help you? Leave a reply.

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.

HOW TO change data for all Companies

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

    GLSetup.CHANGECOMPANY(Name);
    
    GLSetup.MODIFYALL("Allow Posting From", 010114D); 
    GLSetup.MODIFYALL("Allow Posting To", 310114D);
    

    or

    TO DELETE

    ChangeLogSetup.CHANGECOMPANY(Name);
    
    ChangeLogSetup.DELETEALL; 
    
    1. Did my HOW TO help you? Leave a reply.