You can use MS Excel to get that data
Here is the sql statement
SELECT
MTIT_DATE,
MTIT_CODE,
MTIT_QTY,
MTIT_AVGCOST,
(MTIT_QTY *MTIT_AVGCOST) AS MY_VALUE
FROM INVTXN
WHERE MTIT_TYPE = 'A' AND MTIT_QTY < 0 AND MTIT_CODE = 'MY PART/SKU ID'
On MS Excel go to Data, then "Import External Data", then "New Database Query"
Kelloggs
PD: note that I am using Average Cost