i want to create report categorize inventory on hand on periods like from 1to 30 days and from 31 to 90 days etc

AI generated answer (using internal Slack threads):

To create a report that categorizes inventory on hand in periods like from 1 to 30 days, 31 to 90 days, etc., you can use the Inventory Aging report in NetSuite. This report typically categorizes items based on their age (age distribution of current stock based on time intervals, like every month for the past two years). However, if you want to know the inventory on hand at the start and end of each month, you might be looking for an inventory valuation or stock status report. This report provides a snapshot of quantity and cost at specific points in time. To retrieve the quantity on hand at a certain date, you can use the Inventory Snapshot report or the Inventory Activity Detail report in NetSuite. If you want to find out inventory on hand at year-end for items bought from a particular vendor, you can customize the "Inventory Valuation Summary" report to add the vendor as a filter. Change the "As of" date to be year-end and filter for the desired vendor. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******