LS NAV - OMNI - How to set the default customer for Ecommerce transactions

• Store Setup>Omni>Web Store Customer Number
• DEV>WI Setup Table>WI In use = yes, Web Store Code=store code,  Web Store Customer No. = default cus no

LS NAV - Create an Out of Stock Report

• Custom Report in NAV
• Datasets
• T27 Item
• T10012209 Replen. Out of Stock Log (Dataitemlink on No.)
• Filters
• Custom Filters for StartDate and EndDate
• Layout
• Group by Item
• Group by Location
• Total Days out of stock
• Total % of time out of stock for date range selected
• Total Count of Times item went out of stock in period
• Globals
• StartDate Date 
• EndDate Date 
• CalcDaysOOS Integer 
• CalcDateOut Date 
• DaysInRange Integer 
• PCDaysOOS Decimal

• CAL

Documentation()

OnInitReport()

OnPreReport()

DaysInRange := EndDate - StartDate;

OnPostReport()

Item - OnPreDataItem()

Item - OnAfterGetRecord()

Item - OnPostDataItem()

Replen. Out of Stock Log - OnPreDataItem()

Replen. Out of Stock Log - OnAfterGetRecord()

CalcDaysOOS := 0;

IF "Date Out of Stock" < StartDate THEN BEGIN

  CalcDateOut := StartDate;

END ELSE BEGIN

  CalcDateOut := "Date Out of Stock";

END;

IF "Date In Stock" <= DMY2DATE(1,1,1900) THEN BEGIN

  CalcDaysOOS := EndDate - CalcDateOut;

END ELSE BEGIN

  CalcDaysOOS := "No. of Days Out"; 

END;

PCDaysOOS := CalcDaysOOS / DaysInRange;

Replen. Out of Stock Log - OnPostDataItem()

GP Web Client - Smartlist

Administration-Reports
Add site to trusted sites to export to excel

Dynamics NAV - Add Revision No. to Purchase Order

• Use the "No. of Archived Versions" in the T38 Purchase Header
• Add field to page header in R405 Order 
• Ensure you enable quote and order archiving in the Purchase & Payables Setup
• Advise users to archive whenever they make major changes to increment the revision number

GP 2016 Web Client - Mods do not display, or throw errors in Web Client

Ensure gp web server has all customizations installed and is pointing to shared dictionaries.





https://winthropdc.wordpress.com/2015/04/08/how-to-enable-visual-studio-tools-customisations-for-the-web-client/

Your VB code needs to explicitly state the mod is available in the web client

Enable Mod in VB

<SupportedDexPlatforms(DexPlatforms.DesktopClient Or DexPlatforms.WebClient)>

Public Class GPAddIn

    Implements IDexterityAddIn

    ' IDexterityAddIn interface

    Sub Initialize() Implements IDexterityAddIn.Initialize

    End Sub

End Class

SSRS - After modifying a GP SSRS Report, you get an error about xmlns and Semanticquery

When reconnecting the data sources, be sure that you reconnect SemanticQuery sources to the Data Model Sources, and not regular Data Sources.

• Data Model Sources
• Stored in GP/Reportserver/ReportModels/TWO
• Regular Data Sources
• Stored in GP/Reportserver/Data Sources

If you connect them badly, none of the Sematicqueries will run.

NAV - CAL Get Currency Exchange Rates

T330 Currency Exchange Rate.GetLastestExchangeRate
T330 Currency Exchange Rate.GetCurrentcurrencyFactor
T330 Currency Exchange Rate.POSExchangeLCYToFCY