Scenario:
The user encountered an issue in their Production account where an Analytics Dataset based on the Item record type displayed the following error:
"This dataset contains fields with data that you do not have access to, or which has been altered or corrupted. The data and the number of rows displayed in the dataset may be inaccurate because the criteria and filters based on those fields are not considered."
The affected dataset specifically involved the Locations related record, which suddenly became unavailable or invalid.
Solution:
This behavior is a known limitation when the Advanced Item Location Configuration (AILC) feature is enabled.
When AILC is turned on:
- The standard Location field is no longer available in Analytics datasets for the Item record.
- Existing datasets referencing the Location related record may become invalid or display corrupted field warnings.
To confirm or resolve the issue:
- Navigate to:
Setup > Company > Enable Features - Open the Items & Inventory tab.
- Locate the feature:
Advanced Item Location Configuration - Review whether the feature is enabled.
- If appropriate for testing purposes, disable the feature and reload the dataset.
Once the feature is disabled, the dataset should load successfully again and the Location-related fields will become available.
This behavior is currently tracked under the following enhancement request:
Enhancement 468240: Advanced Item Location Configuration = T > Item > IncludeLocationsList
At this time, the behavior is considered system limitation behavior when AILC is enabled.