3795432 - Stock Overview Auto-Loads All Records Without Requiring Filter Criteria

Stock Overview automatically fetches all available stock records without requiring filter criteria, leading to performance issues.

SAP Business ByDesign

1. Go to Physical Inventory work center.
2. Open Stock Overview view under Common Tasks.
3. The system automatically starts fetching all available stock records.

• The "Execute on Selection" checkbox is enabled in Organize Queries for the affected user in Stock Overview.
• This setting triggers automatic loading of all stock records upon opening the view.

Disable the "Execute on Selection" setting in Organize Queries to ensure data retrieval occurs only after applying filters.

1. Go to Physical Inventory work center.
2. Open Stock Overview view under Common Tasks.
3. Choose Advance Filter.
4. Choose Organize Queries.
5. Select the relevant query that is currently in use or set as default.
6. Uncheck the "Execute on Selection" checkbox.
7. Save the changes.
8. Go to Physical Inventory work center.
9. Choose Stock Overview view.
10. Apply filter criteria and choose Go.

The Records are retrieved only after applying the filter criteria.

Stock Overview; Execute on Selection; Organize Queries; Physical Inventory; Auto Load; Filter Criteria; Performance; ByDesign , KBA , AP-IP-INV , Inventory , Problem