Discussions
NSC | Saved Search Returning Incorrect Preferred Stock Level and Reorder Point Values
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
- Preferred Stock Level
Niks Blando-Oracle | Ask A Guru?️
Learn how to Refer A Member|Earn the Answer Accepter Badge|Be the Content Creator of the Quarter|Vote for the content you want to see!
Expand your NetSuite knowledge by joining this month'sAsk A Guru Live about Advanced Accounting.RSVPon this event now!
