Error when exporting budget to Excel – The call to member Add failed. Microsoft Office Excel returned the following message: That name is not valid.

Sometimes you get a question, which seems so easy, that you know the answer instantly. You need to follow simple steps and the issue will be resolved. However, just to be sure (before giving the answer) you try the solution yourself, and you bang your head into another, totally different issue. Today, I was trying […]

Error: You do not have permission to read the 0 table.

There are quite a few error messages you can get when setting up Dynamics NAV security – database is invalid or cannot be access, you do not have permissions to read the table, etc, etc. And once you have seen them, next time you will know (more or less) possible solution for it. And I […]

Error: The Microsoft Dynamics NAV Server cannot connect to the Change Listener to SQL Server because of the following error

————————— Microsoft Dynamics NAV ————————— The Microsoft Dynamics NAV Server cannot connect the Change Listener to SQL Server because of the following error: Cannot open database “Demo Database NAV (6-0)” requested by the login. The login failed. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’. ————————— OK ————————— According to Murphy’s Tech Law – New systems […]

Error when importing FOB file: Cannot find the object because it does not exist or you do not have permissions

There are some tasks in Dynamics NAV, where it is not sufficient to be a SUPER user, to complete them. You need more permissions added for your username on the SQL Server. For example, if you would try to upload a license file without having sufficient SQL permissions, you would get an error message: Database […]

Error: The active fields in a record cannot take up more than 4000 bytes

So, you started working on your modification in Dynamics NAV, and after adding a few new fields, you get hit by an error meesage: The active fields in a record cannot take up more than 4000 bytes. The active fields in the table take up to 4063 bytes. You must reduce the number or the […]

Error: You cannot use the file TEMP because it is already in use

You are working in Dynamics NAV, creating your sales orders, and… you were kicked out from the server (getting error message: You cannot use the file TEMP because it is already in use). OK, let’s try to replicate the issue. Go back to Dynamics NAV, create a few more sales orders. Nothing… this time no […]

Error: BACS Exported must be No in Gen. Journal Line Journal Template Name=’PAYMENT’,Journal Batch Name=’GIRO’,Line No.=’10000′.

Once in a while someone will ask me: could you reset “BACS Exported” on Payment Journal for me? When faced with this question for the first time, my first though was – but why? And scenario is quite simple. Imagine that you are working on a payment journal, applying entries to be paid, and you […]

Error: Login failed for user ‘username’. The user is not associated with a trusted SQL Server connection

Last week, when testing Extended Demo Database, when logging to SQL server with Dynamics NAV client, I received error message saying: “Login failed for user ‘username’. The user is not associated with a trusted SQL Server connection.” This got me thinking… what did I do differentlly? I was able to login just a minute ago […]

Error: You cannot print in a report where the property ProcessingOnly is set to Yes

I wanted to share a quick tip (or rather a possible solution for another Dynamics NAV erorr message). If you will ever receive error message saying: ————————— Microsoft Dynamics NAV Classic ————————— You cannot print in a report where the property ‘ProcessingOnly’ is set to ‘Yes’. ————————— OK ————————— Remember, that there are two things […]

Error: You do not have permission to read the table

Dynamics NAV permissions can be either a very simple topic (if you need to add a table permissions to existing security setup), or a very complex one (if you need to create security roles/permissions from scratch for the first time). In case of missing Dynamics NAV permissions, users will be getting error messages saying “You […]