Hey... Does anyone use the inbound function feature and have a saved search for them? I was trying to create a 30 day outage report which would show the item, QTY on hand, QTY sold in last 3 months, QTY on backorder, and QTY in transit. I cant get the report to show the QTY sold in last three months and QTY in transit. If I remove one the other will work but if I have both only the QTY sold shows and In Transit is blank. I even created a custom field on the Iventory Item page and use a saved search to show the QTY sold in last 3 months and then tried to use that field on the search instead of the formula itself but it just comes up blank.

@Nichole Broom I know you asked for a saved search, but here's a SuiteQL query that is pretty close:

SELECT

Item.ItemID,

Item.QuantityOnHand,

Item.QuantityCommitted,

Item.QuantityOnOrder,

Item.QuantityBackordered,

(

SELECT

SUM( TransactionLine.Quantity) * -1

FROM

TransactionLine

INNER JOIN Transaction ON

( Transaction.ID = TransactionLine.Transaction )

WHERE

( TransactionLine.Item = Item.ID )

AND ( Transaction.Type = 'SalesOrd' )

AND ( TRUNC( SYSDATE ) - Transaction.TranDate <= 90 )

) AS QuantitySold90Days

FROM

Item

WHERE

Item.ID = 999999

I'm not using the inbound function, but there are two tables that are available that you could use to get the total qty in transit: InboundShipment and InboundShipmentItem. The second table has a "quantityremaining" column, and I think that's what you'd want to sum up. I hope that helps.

@tdietrich Thank You! I will look into it.