i want to create inventory aging show the age of inventory in days

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** To create an inventory aging report that shows the age of inventory in days, you can use NetSuite's Saved Search feature. This feature allows you to create custom reports based on your specific needs. Here are the steps to create an inventory aging report: 1. Navigate to Reports > Saved Searches > All Saved Searches > New. 2. Select the record type as 'Inventory'. 3. In the Criteria subtab, you can set the filters as per your requirements. For example, you can set the 'Date' field to a specific range to get the inventory for that period. 4. In the Results subtab, you can select the fields you want to display in the report. For example, you can select 'Item', 'Quantity', 'Date', etc. 5. You can also set the 'Summary' type for each field. For example, you can set the 'Summary' type for 'Quantity' as 'Sum' to get the total quantity for each item. 6. Save the search. Please note that this will give you a snapshot of the inventory for the specified period. If you want to get the age of the inventory, you might need to calculate it based on the 'Date' field. Also, there is a SuiteAnswer 75940 that shows inventory affecting transactions by bucket (30/60/90 days). However, it doesn't really show inventory aging, it shows inventory affecting transactions by bucket. If you want to use the FIFO method for inventory aging, it is possible but might require more complex calculations in the saved search or potentially a custom script. Remember, the Saved Search feature in NetSuite is very powerful and flexible, allowing you to create a wide variety of custom reports based on your specific needs.