Sage Intacct does not support querying the field

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.