NAV Web Client - Customize the Navigation Bar

The Web Client Navigation Bar is controlled by the Page Actions setup on the Role Center Page object.

Add entries to the Page Actions to add new menus.

NAV Email Notification Document Approval Link is incorrect

Set the web client base url correctly on the instance

https://www.cronus.com/BC190/Webclient/

Modify R1320

Modify the DocumentURL variable and replace the text with whatever you need

IF NotificationSetup."Display Target" = NotificationSetup."Display Target"::Windows THEN
  DocumentURL := PageManagement.GetRTCUrl(RecRef,"Notification Entry"."Link Target Page")
ELSE
  DocumentURL := PageManagement.GetWebUrl(RecRef,"Notification Entry"."Link Target Page");

//mod
DocumentURL := DELSTR(DocumentURL,1,STRLEN('http://LSNav:48900'));
DocumentURL := 'http://localhost:8080' + DocumentURL;
//mod

Dynamics NAV and Date Formats

• General Date Formats are controlled by your machine's regional settings
• Regional Settings>Format>English (United States) Allows 
• Short Date: dd-mmm-yy
• What will not work
• Default dates displayed by your excel when exporting data
• Excel AND NAV will not display mmm by default, and will instead display mm
• You can manually change the formatting on the cell, but the cell will not originally default to any mmm date format
• Eg. short date 31-jan-18 will display in excel by default as 31-01-18
• Long dates on the other hand will display correctly dd-mmm-yy if you set the default long date format in the regional settings to dd-mmm-yy
• You Cannot mix - and / separators in the date
• Excel and NAV will use the first separator character they find
• Eg. Windows date format 31-Jan/2019 will display by default as 31-01-19
• What will be affected
• Dates displayed in SQL server
• Dates displayed in NAV if NO Language pack is installed
• Default W1 uses en-US, but is not a language pack
• If you change the regional settings on the machine, you must restart the NAV instance for it to detect the new format
• NAV Date Formats
• Are controlled by the Language Pack
• Default EN-US: DD/MM/YYY

SSRS - Countdistinct ignoring blanks

=CountDistinct(IIF(Fields!InStockItem.Value>"",Fields!InStockItem.Value,Nothing))

LS NAV Stock Turnover Report R10000757

• Period = Date filter range
• Sale: Total qty sold for period
• Inventory Workdate: Current Total Inventory
• Inventory Enddate: Inventory as at end date
• Average Stock: Current Stock / Days in period
• Turnover av. inventory: Sales Qty / Avg Stock
• Turnover end Date: Sales Qty / Inventory Enddate
• Waiting Time: Number of days to sell all remaining stock

LS NAV - Preload does not pull all records for statement. Statement Autopost throws "missing transaction" errors

Confirm that all Transaction jobs have the correct linked tables configured
Confirm that all links on each linked table is valid.
These can fall out of sync, or be missing if the job was copied or imported, and the links were not included.

LS NAV - The License Information is not valid

The country code was incorrect on the license.
Contact LS Retail and have them generate a new license with the correct country code.