Sign Up for Training |
Jet Global Company Site
Community
Downloads
Submit a Request
Give Feedback

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.
 
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments