I have a saved search for Transactions. It is an aging report that I created, but each widget is grouped and I have the total On Hand being populated, based off Suite Answers #75940 . One thing I don't have populated, but what we want to have populated is quantity in transit. The field in NetSuite is "Location in Transit" and when trying to populate the search with it does not populate the field. This is because of "Formula (Numeric) is 1 case when {item.inventorylocation.id} = {location.id} then 1 end Formula (Numeric) is 1 case when {item.assetaccount.id} = {account.id} then 1 end" criteria. Is there anyway around this besides maybe creating a custom record on the inventory item page? Even when I do remove those two formulas, because it is a transaction search I am would be getting duplicate entries since each item receipt is its own line due to it being a transaction report.

@Noel B It's not super clear to me what you're asking, but I think you're wanting to show the In-transit quantity on that saved search. If you have an in-transit location it should automatically create this as a separate line. If you're using the native in-transit numbers, it's probably possible. If you're not that familiar with saved searches you're probably better off just creating a separate saved search as outlined in SA Answer Id: 73064. But if you are really good with SQL expressions then you could build those same criteria into a column using a formula.

Yeah, it is hard to explain, but the inventory aging is based off of subtracting item receipts from the on hand quantity. Because of this the transit on hand gets repeated for each item receipt transaction record it is counting. I am grouping by the item. No easier answer for now I don't think.