Hello It is possible to have on transaction search : Criteria : sales order Résultat : kit parent Member of Member of : location Member of : location on hand Because I need to know the qty on hand by location on the composent I think is not possible

I don't think it's possible in a search, but might be in a SuiteAnalytics Workbook

I'm not sure this is what you're looking for but it shows kit inventory at each location by referencing member quantity available

It’s a transaction search or Item search ?

that's item search. those formulas should prove useful though

yes they look very interesting but they wouldn't work on my transaction search because I already tried to reach members and inventory location and it’s not working

that makes sense because the one join