Inventory aging report On hand value mismatch with physical cost amount of transactions

I have a report built in AX that sum up all the transaction till given date. I have retrieved the PhysicalCostAmount of inventtrans as amount field and qty field as quantity. My report qty is matched with AX Default inventory aging report on-hand quantity but the on-hand value does not matches with my PhysicalCostAmount although it does matches with the amount of transactions if i sum up them till given date. I run both report with same date but still gets mismatch amounts. Can anyone guide me how exactly amount is retrieved in inventory aging report so it can be matched with transactions amount in inventory transactions ?