A series of user guides to Microsoft Dynamics NAV. These free resources detail specific issues and questions brought up by our clients. If you have any questions on Microsoft Dynamics NAV you’d like addressed by NAVGuides let us know at enquiries@metaphorix.co.uk

SQL Backup Schedule & Email Notification

SQL Backup Schedule & Email NotificationCreating a SQL Backup schedule using the SQL Server Agent is very straightforward however we don't want to check this manually by logging into the SQL Server and checking the success Logs every…

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…

NAV 2013 R2 - Posting Dates

Set Up and Amend Posting DatesNavision makes it possible to limit users to posting within specified time frames. This helps to prevent errors occurring with back/forward posting during closed accounting periods. Despite this it may be…

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