Sage Intacct does not support querying the field

Created by Harry Lewis, Modified on Wed, 3 Apr at 6:37 PM by Harry Lewis

Applies to:

Velixo NX
Sage Intacct

Overview

When using the SI.QUERY or SI.QUERYFILTER function, #VALUE! appears in the cell and the following message is displayed:

Text of Message

Sage Intacct does not support querying the field {fieldname} in entity {entityname}

Cause

As noted in the message, there are certain fields (especially certain password fields) which Sage Intacct does not support being returned by of filtered by within a query.

Resolution

Remove the problem field from the SI.QUERY or SI.QUERYFILTER function. The function can then be evaluated.