Turn On Trace Flag 4616 Dynamics NAV

Turn On Trace Flag 4616 Dynamics NAV

SQL Server Mangement Studio >> New Query >> master

DBCC TRACEON(4616,-1) 

Andy

Inventory Valuation - Slow Report FIX (NAV 2009/R2)

Inventory Valuation - Slow Report FIX


Microsoft released a hotfix for the Inventory Valuation report 1001 for NAV 2009 / R2 to decrease the length of time the report takes to run. This is especially important for big databases. 

Hope this helps! 

Download


Andy 

Departments Menu Glitch - NAV 2009 / R2

Departments Menu Glitch - Assign Users 

In Navision 2009 / R2 (Classic) you are able to hide departments from your users, however somtimes this can glitch. I've witnessed this issue a few times whereby the you disable / enable a department for a user but nothing happens.

The quick fix is to delete the user completely from NAV.

Tools >> Security >> Windows/Database Logins >> Copy all the permissions >> Delete the User >> Synchronize >> Re-Add the user >> Paste the logins back in >> Synchronize.

As to why this happens, I have no idea. I think the 'User Menu Level' gets corrupted.

 

 

Delete All Users from NAV 2015

Delete All Users from NAV 2015 - SQL

Note: This same script can be used on NAV 2013/NAV 2013 R2

Sometimes we will need to delete all of our users from a NAV 2015 database as we may inadvertantly lock ourselves out or experiences glitches with user accounts. A quick way to delete all users from NAV 2015 is to do the following: 

1. Open SQL Server Management Studio. 

2. New Query (select the database we want to remove all the users from). 

3. Use the query below >> Hit Execute

delete
from
[dbo].[User]
delete
from
[dbo].[Access Control]
delete
from
[dbo].[User Property]

delete
from
[dbo].[Page Data Personalization]
delete from
[dbo].[User Default Style Sheet]
delete from
[dbo].[User Metadata]
delete from
[dbo].[User Personalization]

NAS Manual Install

NAS Service Install

(NAV Application Server)

"C:\Program Files (x86)\Microsoft Dynamics NAV\60\Application Server\nassql.exe" appservername="Application Server", NETTYPE=TCP, servername="SQL-SERVER", database="Cronus 2009 R2", company="CRONUS Ltd.", nettype=tcp, startupparameter="JOBQUEUE", objectcache=40000, installasservice

The configuration for this can be ammended in the registry if you dont have the MMC snap in installed. 

HKEY_LOCAL_MACHINE/SYSTEM/CurrentConotrolSet/Services

Invalid Page Number: NAV 2009

Error Message: Invalid Page Number

When attempting to click on the Posted Invoices option, in the Sales & Marketing navigation pane, I am meet with the below error.

“Invalid Page Number (8) for the tab control names “Control1”. (InPage was set to 8 on the CheckBox “Control1000000091”).

This is a relatively common error that occurs when there are certain sections (in this case the Posted Invoices) where the Multi-language settings are not set-up correctly.

To fix this issue and stop the error message from appearing simply click on Tools >> Language.

This will open the window below. From here, select your preferred language (in this case English United Kingdom).

No I am able to select and open the Posted Purchase Invoices.

NAV 2013 R2: The requested record cannot be located (Save View As...)

When using Navision 2013 R2 it is possible that certain Role Centres will display the error below when clicking the Notifications displayed on the homepage.

The reason for this issue is that the notifications refer to posted information. Therefore, this information is not available to view via the notifications box.

In this example we are trying to view a posted invoice and we are logged into a Procurement Role Tailored Client; although we aren't able to view the posted invoice by clicking on the notification, we are still able to go to Departments > Finance > History > Posted Invoices. From here we can view the invoice for which our notification appeared.

As it is not possible to navigate to this view from the notifications pane; we can instead click on Posted Invoices header and select Save View As...

This will display the options below:

This allows us to personalise the Role Centre so that, from the home page, I am able to navigate to Posted Invoices.

The Save View function allows users to personalise their homepage to ensure that information that they will need to regularly access is readily available to them. In addition it is also possible to save various views with filters applied.