Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

Jet Web Portal - Feature Support


Overview

The Jet Web Portal supports the vast majority of all features present in the Jet Excel add-in.

Note: Information presented here applies to the latest version of the Jet Web Portal.  Older versions may not support all features listed.

 

Data Sources

The following data sources are supported in the Jet Web Portal:

  • Dynamics NAV 2013 and higher
  • Dynamics GP (On Premises)
  • Dynamics NAV (Remote Data Service)
  • Dynamics GP (Remote Data Service)
  • Jet Enterprise Data Warehouse
  • Jet Enterprise Cubes
  • Universal

 

Supported Excel Functions

The following Excel functions are supported.  Those not in this list will fail to calculate if they are either dependent upon or a dependency of a Jet function:

A-C D-H I-L M-R S-Z
  • ABS
  • ACOS
  • ACOT ^
  • ACOTH ^
  • ACOSH
  • ADDRESS
  • AND
  • ASIN
  • ASINH
  • ATAN
  • ATAN2
  • ATANH
  • AVERAGE
  • AVERAGEA
  • AVERAGEIF
  • AVERAGEIFS
  • CEILING
  • CEILING.MATH ^
  • CHAR
  • CHOOSE
  • COLUMN**
  • COLUMNS
  • CONCATENATE
  • COS
  • COSH
  • COT ^
  • COTH ^
  • COUNT
  • COUNTA
  • COUNTBLANK
  • COUNTIF
  • COUNTIFS
  • CSC ^
  • CSCH^

 

  • DATE
  • DATEVALUE*
  • DAVERAGE
  • DAY
  • DAYS**
  • DAYS360
  • DCOUNT
  • DCOUNTA
  • DEGREES
  • DGET
  • DMAX
  • DMIN
  • DSUM
  • DVAR
  • DVARP
  • EDATE
  • EOMONTH
  • ERROR.TYPE
  • EXACT
  • EXP
  • FACT
  • FACTDOUBLE ^
  • FALSE
  • FIND
  • FIXED
  • FLOOR
  • FLOOR.MATH ^
  • GETPIVOTDATA*
  • HLOOKUP
  • HOUR
  • HYPERLINK
  • IF
  • IFERROR
  • IFNA
  • INDEX
  • INDIRECT
  • INT
  • ISBLANK
  • ISERR
  • ISERROR
  • ISEVEN
  • ISLOGICAL
  • ISNA
  • ISNONTEXT
  • ISNUMBER
  • ISODD
  • ISOWEEKNUM
  • ISTEXT
  • LARGE
  • LEFT
  • LEN
  • LN
  • LOG
  • LOG10
  • LOOKUP
  • LOWER
  • MATCH
  • MAX
  • MAXA
  • MEDIAN
  • MID
  • MIN
  • MINA
  • MINUTE
  • MOD
  • MONTH
  • N
  • NA
  • NETWORKDAYS*
  • NOT
  • NOW
  • NUMBERVALUE**
  • OFFSET
  • OR
  • PI
  • POWER
  • PRODUCT
  • PROPER
  • QUOTIENT
  • RADIANS ^
  • RAND
  • RANK ^
  • RANK.EQ ^
  • RANK.AVG ^
  • RANDBETWEEN
  • REPLACE
  • REPT
  • RIGHT
  • ROUND
  • ROUNDDOWN
  • ROUNDUP
  • ROW**
  • ROWS
  • SEC ^
  • SECH ^
  • SECOND
  • SIGN
  • SIN
  • SINH
  • SMALL
  • SQRT
  • SQRTPI
  • STDEV
  • STDEVA ^
  • STDEVPA ^
  • STDEV.P
  • STDEV.S
  • STDEVP
  • SUBSTITUTE
  • SUBTOTAL
  • SUM
  • SUMIF
  • SUMIFS
  • SUMPRODUCT
  • SUMSQ
  • T
  • TAN
  • TANH
  • TEXT
  • TIME
  • TODAY
  • TRUE
  • TRUNC
  • UPPER
  • VAR
  • VAR.S ^
  • VAR.P ^
  • VARA ^
  • VARP
  • VARPA ^
  • VLOOKUP
  • WEEKDAY
  • WEEKNUM
  • WORKDAY
  • YEAR
  • YEARFRAC

 * Supported in version 2017 R2 and newer     ** Supported in version 2017R3 and newer     ^ Supported in version 2018 and newer

 

Function and Report Limitations

Currently, there are some features that are not available for use with the Jet Web Portal.

 

The following data sources are not supported in the Jet Web Portal:

  • Dynamics NAV 2009 and earlier (C/Front)

 

Some function arguments are required to be constant.  This means that they must be either hard-coded in the formula or be absolute cell references to cells that are not Report Options.  These include:

Function Arguments that must be constant:
NL
  • What
  • FilterField
NF
  • Field
  • FlowFilterField
NP
  • What
  • Formula (must be a text string in the function)
GL (Dynamics NAV)
  • What
  • View
  • Exclude Close
GL (Dynamics GP)
  • Where
  • What
  • Include Unposted

 

Supported Examples:

  
{constant - supported}


{hard-coded cell reference - supported}

 

Unsupported Example:


{Why?  Cell references to report Options are not supported for these parameters}

 

Using LINK=

Functions utilizing the LINK= must:

  • include all filters within the function    OR...
  • if using the NL("Link) function within a replicating function [ NL(Rows) or NL(Columns) ] :
    • the NL("Link") must be on the same row as the replicating function   OR... 
    • the NL("Link) must be referenced using Excel's absolute referencing ($)

 


Supported Examples:

=NL("Rows","Sales Invoice Header","No.","Posting Date",">1/1/2009","LINK=","Sales Invoice Line","Document No.","=No.","Type","Item")

{Why?  all filters reside within the function}

 

OR...

support_link.png

{Why?  the LINK= filter in cell B5 includes an absolute cell reference to the NL("Link") function in cell C3}

 

OR...

support_link2.png

{Why?  Even though the cell reference "C5" is not absolute, cell C5 is contained within the replication area}

 

Unsupported Example:

unsupported_link2.png

{Why?  the LINK= filter in cell B4 includes a relative reference to the NL("Link") function which is outside the replicated area)

 

 

The following functions and report features are not currently supported in the Jet Web Portal:

  • ShowQuery=
  • Stored User Data
  • External workbook connections (e.g. OLAP Pivot Tables) cannot be refreshed from Excel online.
  • Use of the VALID keyword with the Report Options feature
Was this article helpful?
0 out of 1 found this helpful
Have more questions? Submit a request

Comments