Object fields present in Acumatica cannot be used with ACU.QUERY and ACU.OBJECTDEFINITION

Overview

Using ACU.QUERY or ACU.OBJECTDEFINITION to query an object field that is present in the Acumatica DAC Schema Browser results in a #VALUE! error.

Cause

This behavior is typically linked to feature configuration in Acumatica. Fields associated with specific features are hidden from the OData schema if the required feature is disabled in your instance.

Resolution

Follow these steps in your Acumatica environment to resolve the issue:

1. Navigate to Features

   1. Go to Enable/Disable Features (screen ID: CS100000).

      

   2. Click the MODIFY button.

      

2. Enable the Required Feature:

   1. Identify the feature(s) related to the object(s) you are querying.

   2. Ensure the checkbox is selected.

   3. Click Enable, then allow the system to complete the configuration update.

      

3. Click Refresh → Current sheet in the Velixo NX menu in Excel.

   

4. Your query should now return results as expected.