Hi Community,
I am looking for guidance on whether it is possible to create or customize an Inventory Value Report similar to the standard Stock Valuation Report, but with additional time-based column grouping.
In the Financial Reports section, there is an option where we can break down data using columns such as Year, Quarter, and Month, which dynamically splits the report values based on the selected period.
What I need is something similar for inventory:
- Inventory Value Report / Stock Valuation Report
- With the ability to split values by Month / Quarter / Year in columns
- So we can analyze inventory valuation trends over time, not just a single snapshot
- Ideally showing item-level inventory value movement across periods
Is there any standard NetSuite report, saved search, or customization approach (SuiteAnalytics / Workbook / SuiteScript) that can achieve this?
Any suggestions or best practices would be highly appreciated.
Thank you in advance.