LS NAV - NAS Scheduler stops, sticks, freezes or hangs for no reason

Review the windows error logs
Give the NAS service account access to

• tabledata Calendar Event User config: insert
• tabledata job queue entry: modify

C99001468 controls the nas scheduler

The TYPEFILTER set in the NAS setup control what job types will actually get to run

Ensure your jobs always have a type dd-from-ho or dd-to-ho

LS NAV - Configure Manager MSR Card to takeover transaction until completion, revert to staff

This can be controlled on the Functionality Profile. Look for Card Logon at Sale in the Staff & Logon fast tab. Set this to Manager Key.

NAV - Reports CAL use OnPreDataItem for additional filters

The OnPreDataItem can be used to put additional filters on your report data before it is populated, which can significantly increase the speed of certain reports if they are pulling unnecessary data due to joining constraints.

You can populate variables with data that can be used in a setfilter in the OnPreDataItem

NAV - SQL Database Tuning and Indexes for speed improvements

https://www.sqlshack.com/a-great-tool-to-create-sql-server-indexes/

• Run  a trace in the SQL Profiler, save it
• Load it into the Database Tuning advisor
• Let it analyze and recommend indexes
• In NAV, build keys in the dev environment to best meet the recommendations at your discretion
• Each key will build an appropriate index in sql
• DO NOT run the scripts and generate indexes outside of NAV

LS NAV - Change shows negative value on screen and does not open drawer

On the tender type, set the change tend code as the code for cash

LS NAV - Object Push - [22924070] The CRONUS database on the NAV server cannot be opened by this version of the Microsoft Dynamics NAV Development Environment. The database has already been converted by a newer version. You must upgrade the Microsoft Dynamics NAV Development Environment to the latest version to open the database.

This happens when the destination has multiple versions of nav installed.
Uninstall the old nav.

LS NAV - How to deal with Web Service Issues - Enable Log

• How to enable web requests
• Pos Functionality Profile>DD Tab>Send Transaction = Yes
• This will send a transaction immediately to ho as soon as it is posted to the local db via web services "SEND_TRANS_HEADER"
• Turn on the Web service Log
• Departments/LS Retail/Administration/Web Service/Web Service Setup
• Client Log On = Yes
• Server Log Level = All
• Client Log Path = C:\Temp\Webservice
• Use the Web Request Log to view the log
• After every transaction, there is a long delay while "Sending Transaction Header" is displayed
• "Sorry, we just updated this page. Reopen it, and try again."

-------------------------------------------

Check the Trans. Server Work Table, if it has too many entries, it may be locking itself up.

Copy the data out to excel, then put it back in 20 at a time.

Login and logout of pos to send requests

Repeat for all records.
-------------------------------------------

Be sure to fill in Functionality Profile / Web Servers -> Dist. Location.


https://ptsteadman.com/nav.html