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

Created by Damien Zwillinger, Modified on Thu, 5 Oct, 2023 at 9:33 PM by Damien Zwillinger

Applies to:

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


Overview

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)

 

Example

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

 

mceclip2.png


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

 

mceclip0.png


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

 

mceclip3.png

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").


mceclip2b.png

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