Scenario:
The user noticed that some inventory items were missing from the Inventory Valuation Report when running the report across all inventory. However, when filtering specifically for the missing items, the data appeared correctly. Attempts to use broader filters, such as merchandise hierarchy filters, resulted in report timeouts due to the large transaction volume.
Solution:
This behavior is typically caused by NetSuite report row limitations rather than missing inventory data.
If the items appear when filtered individually, it indicates that the inventory records are still included in the system but are not fully displayed because the report results exceed NetSuite’s maximum row limits.
According to SuiteAnswers Article 8392 – Row Limitations for Report Results:
- 100,000 rows maximum for reports executed on demand (synchronously)
- 1,000,000 rows maximum for reports executed in the background (asynchronously)
When report results exceed these limits:
- NetSuite truncates the displayed results
- Some items may no longer appear in the visible output
- Large filter combinations may also cause report timeouts
To improve report accuracy and visibility:
- Apply additional filters to reduce report size.
- Break the report into smaller segments such as:
- Item category
- Merchandise hierarchy
- Subsidiary
- Location
- Date range
- Run reports asynchronously where possible for larger datasets.
Using smaller filtered report segments is the recommended approach to ensure complete inventory valuation visibility in high-volume NetSuite environments.
