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.

  

 



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article