In a NAV Know How webinar from earlier in the year, we covered configuring the Web Client for tablets in versions 2013 and above. Some of the specific areas we covered include: Overview 1) Preview Client 2)SQL database- CRONUS-SQL 3) NAV Server – meta-dtp-11x 4) IIS (Web Server) Server – metapdtp-11x 5) Server Certificate/Self Signed […]
How to Create a test system and load fobs The latest Metaphorix NAV Know How webinar covers test systems; how to create a test system and configure it correctly, how to load objects onto the system, how to import worksheets and the best practices when performing these actions. Test systems are a valuable tool that […]
This issue relates to the failure of the Web Client install which gives the error ‘Fatal Error During Installation’ – (see error logs – code 1603) I’ve had this issue occur a few times for NAV 2013 R2, NAV 2015 and NAV 2016. For this particular error (1603) it turned out the Windows Firewall had […]
Often users of NAV face the issue whereby all the available NAV licenses have been taken up. This is often caused by users leaving a NAV client open, which in turn consumes a single concurrent license. To get around this Microsoft have given us the ‘Idle Client Timeout’ option. This option is set from the […]
SQL Backup Schedule & Email Notification Creating 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 day / week / month. We can in fact trigger a Powershell command to send us […]
Currency Code Filter = LCY A 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 filter using ‘GBP’ or whatever the LCY code is. The […]
Who is in SQL? SQL Server Management Studio >> New Query >> exec sp_who2 This will list the users logged into specific databases, especially useful if you need to force kill the sessions. New Query >> Kill ‘spid’ eg. Kill 11 Andy
Turn On Trace Flag 4616 Dynamics NAV SQL Server Mangement Studio >> New Query >> master DBCC TRACEON(4616,-1) Andy
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 – 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 […]
