Limitations of the Dynamics NAV 2013 and later (Web Services) Data Source
NL(Picture)
In the 'Dynamics NAV 2013 and later (Web Services)' Data Source, NL(Picture) does not work when Calc Filters, Link Filters, or manual sorts are present in the NL(Picture) formula.
DateFormula Field Values/Filters
DateFormula field values use unit abbreviations such as D for Day, WD for Week Day, or M for Month. So a value like "5D" means 5 days. DateFormula values are stored in a non language-specific manner, and then translated when the value is retrieved. Currently in 'Dynamics NAV 2013 and later (Web Services)' data source, the Jet Excel Add-In only retrieves and filters by DateFormula values using the English unit abbreviations.