LS NAV - Replenishment Tables - Configuration Package Tables

• Item Vendor (99) - Lead times per vendor (Item Vendors)
• Item (27) - Control if item can be replenished
• Replen. Item Store Rec (10012206) - Replen. Item Store List Card (Item Store Replenishment Rule Card)
• Status: Active
• Ordered by: Central
• Ordering Method: Calculated
• Blocked: False
• Item Status Link (10001404) - Retail Item Status
• Block Purchasing: False
• Block Transferring: False

LS NAV/BC - Useful / Helpful LS NAV Reports

https://community.dynamics.com/nav/b/exploredynamicsnav

Report Layouts list of all Reports in BC

• Core NAV
• Item Card>Items by Location
• Customer\Item Sales
• Item Sales by Customer
• Sales Statistics
• Inventory-Sales Statistics
• Price List
• Item Age Composition
• Inventory Value
• Inventory Availability - Reorder Points, order recommendation
• Item Expiration - Quantity report (R5809) 
• Invt. Valuation - Cost Spec. - Shows cost breakdown of all items
• Item Charges - Specification - Shows all item charges
• Inventory to G/L Reconcile (For reconciling to GL)
• Use this report for auditing to GL
• Inventory Valuation - WIP
• Items to be counted
• Phys Inventory Journal > functions > calculate counting period
• Warehouse Shipment Status - shows all orders and what shipments they are on
• Total Purchases?
• Vendor Purchases by Item
• Total Sales?
• Salesperson Statistics by inv
• Profitability?
• Salesperson Statistics by inv
• Core Purchasing
• Vendor Purchase Statistics (Shows LCY)
• Item Charges - Specification
• Purchase Order>Purchase Advice (low stock, no stock)

• LS NAV
• Item Sales Statistics
• Payments by Store Report 0 - Shows cash in all stores
  Payments by Periods Report
• Dyn. Item Hierarchy
• Sales History - Dyn. Item Hierarchy
• Shelf Label Printing> Actions>Functions>Print New Label Price Report
• Average Basket Size
• 
  

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.