Filtering using Custom Attributes and User-Defined Fields (UDFs)

Created by Damien Zwillinger, Modified on Thu, 05 Oct 2023 at 09:33 PM by Damien Zwillinger

Applies to:

  • Velixo NX
  • Velixo Classic
  • Acumatica, Cegid, MYOB


In your ERP, it is possible to define dynamic attributes that one can link to records such as business accounts, customers, vendors, stock items etc.


(Explaining them is out of scope of this article - see Acumatica help for details)



The screens below show an example attribute of "Company size" (assume it is linked to the "Business Account" records in the system):



Once properly configured, you can include the respective attribute value in a Generic Inquiry result set in your ERP:



These will now be included in your GI() calls to that inquiry in Velixo:



Filtering Pitfalls

There is a peculiarity of Acumatica that you need to be aware of to properly filter by attribute values.

On the screenshot above, note that the GI() call returns a Description value of the attribute ("1-100").

However, for the purposes of OData filtering, you need to specify the values from the Value ID column instead! ("100").


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 atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article