I WANT TO CREATE INVENTORY AGING REPORT USING SCRIPTING TO CALCULATE ON HAND INVNTORY

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 using scripting to calculate on-hand inventory, you would need to create a script that populates some fields on the inventory record daily. This is because NetSuite does not provide an out-of-the-box solution for Inventory Aging reports. Here's a general approach you could take: 1. Create a custom field on the inventory item record to store the date the quantity was last updated. 2. Create a scheduled script that runs daily and checks for any changes in the inventory quantity. If there's a change, update the custom field with the current date. 3. Create a saved search that groups inventory items by the custom field (date last updated) and shows the quantity on hand. This will give you the quantity on hand for each date. Please note that this is a simplified approach and might need to be adjusted based on your specific requirements. Also, this approach assumes that you have a good understanding of SuiteScript and how to create and deploy scripts in NetSuite. For more detailed information, you might want to refer to SuiteAnswer 75940, which provides an example of how to show inventory affecting transactions by bucket (30/60/90 days). However, please note that this does not show inventory aging, but it might give you a starting point for your script. Remember, this is a complex task that requires a good understanding of both NetSuite and SuiteScript. If you're not comfortable with scripting, you might want to consider hiring a NetSuite professional to help with this task.