Currency Code Filter = LCY

,
Currency Code Filter = LCYA common question we get asked is how to filter a report (eg. Aged Accounts Payable) using the LCY Currency Code for the system (as per the General Ledger Setup). This catches people out as they tend to try and…

Who is in SQL?

,
Who is in SQL? SQL Server Management Studio >> New Query >> exec sp_who2This will list the users logged into specific databases, especially useful if you need to force kill the sessions.New Query >> Kill 'spid'eg.…

Turn On Trace Flag 4616 Dynamics NAV

,
Turn On Trace Flag 4616 Dynamics NAVSQL Server Mangement Studio >> New Query >> masterDBCC TRACEON(4616,-1) Andy

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

,
Inventory Valuation - Slow Report FIXMicrosoft 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…

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…

NAS Manual Install

,
NAS Service Install(NAV Application Server)"C:Program Files (x86)Microsoft Dynamics NAV60Application Servernassql.exe" appservername="Application Server", NETTYPE=TCP, servername="SQL-SERVER", database="Cronus 2009 R2", company="CRONUS…

Invalid Page Number: NAV 2009

,
Error Message: Invalid Page NumberWhen 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”.…

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.…

How to: Delete Companies NAV 2013 R2

,
How to: Delete Companies NAV 2013 R2Firstly; we recommend that you make a backup before you delete the company. This can be stored as a read only file and even zipped in order to save space.In addition to this, before deleting…

How to: Create a New Company NAV 2013 R2

,
How to: Create a Company NAV 2013 R2To create a company in Microsoft Dynamics NAV Windows client or Microsoft Dynamics NAV Web client1.       In Microsoft Dynamics NAV, in the Search box, enter…