Entries by Andy, Software Engineer

, ,

Configuring the Web Client for tablets (NAV 2013+)

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 […]

, ,

NAV Know How: Creating a test system

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 […]

SQL Backup Schedule & Email Notification

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

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?

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