Scenario: Create a saved search to show the inventory aging.
Solution: Currently, there is no standard provision in NetSuite for Inventory aging reports. This is an enhancement in the voting stage(Enhancement 44650).
As an alternative, we can create a Transaction Saved Search to show inventory effecting transactions for a specific period.
Under criteria tab set the following criteria
Formula (Numeric) Formula: Enter case when {item.inventorylocation.id} = {location.id} then 1 end
Formula (Numeric): equal to
Value: Enter 1
Click Set
Formula (Numeric) Formula: Enter case when {item.assetaccount.id} = {account.id} then 1 end
Formula (Numeric): equal to
Value: Enter 1
Click Set
Posting
Click Yes
Click Set
Under Results tab
Fields:
Summary Type: Select Group
Document Number
Summary Type: Select Group
Item
Summary Type: Select Group
Location
Summary Type: Select Group
Quantity
Summary Type: Select Sum
Custom Label: Enter Total Quantity
Amount
Summary Type: Select Sum
Custom Label: Enter Total Amount
Formula (Numeric) Formula: Enter case when Trunc({today}) – {trandate} < 30 then {quantity} else 0 end Summary Type: Select Sum Custom Label: Select Less than 1 Month (Quantity)
Formula (Numeric) Formula: Enter case when Trunc({today}) – {trandate} < 30 then {amount} else 0 end Summary Type: Select Sum Custom Label: Enter Less than 1 Month (Amount)
Formula (Numeric) Formula: Enter case when Trunc({today}) – {trandate} between 30 and 60 then {quantity} else 0 end Summary Type: Select Sum Custom Label: Enter 30 – 60 days (Quantity)
Formula (Numeric) Formula: Enter case when Trunc({today}) – {trandate} between 30 and 60 then {amount} else 0 end Summary Type: Select Sum Custom Label: Enter 30 – 60 days (Amount)
Formula (Numeric) Formula: Enter case when Trunc({today}) – {trandate} between 61 and 90 then {quantity} else 0 end Summary Type: Select Sum Custom Label: Enter 61 – 90 days (Quantity)
Formula (Numeric) Formula: Enter case when Trunc({today}) – {trandate} between 61 and 90 then {amount} else 0 end Summary Type: Select Sum Custom Label: Enter 61 – 90 days (Amount)
Formula (Numeric) Formula: Enter case when Trunc({today}) – {trandate} > 90 then {quantity} else 0 end
Summary Type: Select Sum Custom Label: Enter More than 90 days (Quantity)
Formula (Numeric) Formula: Enter case when Trunc({today}) – {trandate} > 90 then {amount} else 0 end
Summary Type: Select Sum Custom Label: Enter More than 90 days (Amount)
Click Save & Run
Note: This search shows the quantities and valuations that would match the values from the Item Record. If there are negative values in the search, this would pertain to quantity-reducing transactions such as Item Fulfillment, Inventory Transfer, etc.
