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.