i want to build report show the age of quantity of items on the warehouse for example i have 10 quantity available from item x 2 quantity their age less than 30 days and 3 quantity their age between 31 and 60 days and 5 quantity their age is greater than 60 days using saved search i want the steps with details step by step and categorical item age

AI generated answer (using internal Slack threads):

Based on the conversations, here are the steps to create a saved search to show the age of quantity of items in the warehouse: 1. Navigate to

Reports > New Search

. 2. Select

Inventory Item

as the record type. 3. In the

Criteria

tab, add the following filters: -

Type

is

Inventory Item

-

Inventory Location

is your warehouse location 4. In the

Results

tab, add the following fields: -

Name

-

Quantity Available

5. To categorize the age of the items, you will need to create three formula fields: - For items less than 30 days old:

Formula (Numeric)

with the formula

CASE WHEN {inventorydetail.receiptdate} >= {today}-30 THEN {quantityavailable} ELSE 0 END

- For items between 31 and 60 days old:

Formula (Numeric)

with the formula

CASE WHEN {inventorydetail.receiptdate} BETWEEN {today}-60 AND {today}-31 THEN {quantityavailable} ELSE 0 END

- For items older than 60 days:

Formula (Numeric)

with the formula

CASE WHEN {inventorydetail.receiptdate} <= {today}-61 THEN {quantityavailable} ELSE 0 END

6. Save the search. Please note that this search will only work if you are using lot or serial tracked inventory. If you are using standard inventory, NetSuite does not track the age of individual units of an item. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******