Scenario:
The user created an Item Saved Search to display inventory planning values such as Reorder Point (Min) and Preferred Stock Level (Max). However, the values returned by the saved search did not match the values shown directly on the Item record.
Solution:
This issue commonly occurs when the saved search uses the generic fields:
- Preferred Stock Level
- Reorder Point
These fields return combined values across all locations, including inactive locations, which can cause discrepancies compared to the Item record.
To correct the saved search:
- Edit the existing Item Saved Search.
- Replace the following fields:
- Preferred Stock Level
with
Location Preferred Stock Level - Reorder Point
with
Location Reorder Point
- Save and run the search again.
Important Notes:
- The location-specific fields pull values tied to the selected inventory location.
- Using the generic fields may return aggregated or unintended values across multiple locations, including inactive ones.
Reference: SuiteAnswers ID 65360 – Create an Item Saved Search to Display Preferred Stock Level and Reorder Point to Match on Item Record