Get latest information from inventdim having transactionid D365

Question

can someone show me a easy way to get information from inventdim? I need to get batchid/ siteid/locationid for a project transaction. D365FO I tried this select but I don't think its accurate enough

while select InventTransOrigin join salesline where SalesLine.InventTransId == InventTransOrigin.InventTransId
        &&  SalesLine.inventtransid == ProjItemTrans::find(projInvoiceItem.ProjTransId).inventtransid
       join inventTrans where InventTrans.InventTransOrigin == InventTransOrigin.RecId
       join inventdim order by inventdim.inventBatchId desc where InventDim.inventDimId == InventTrans.inventDimId