Im trying to make a saves search to get last purchase/build price at a specific location. The documentation says last purchase price is the last transaction that adds positive inventory. I’m using the formula

MAX({transaction.rate}) KEEP(dense_rank last order by {transaction.trandate}, {transaction.trandate})

to get the value, but i think i may be leaving out some record types? What are all the transaction types that add positive inventory? I have work order completion, transfer, item reciept, inventory transfer, inventory adjustment, assembly build so far. or Is there an easier way to get this? The standard last purchase price field doesnt work because it uses the last price at any location.