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  

We dont have Office 2007 either. But the principal is the same for any office or any program that needs to connect to DBA
You need to setup a ODCB connection
 
then connect your excel to it
 
http://www.mwaccounting.com/dba/white_paper.htm
 
here is some instruction for excel 2007
 
http://office.microsoft.com/en-us/excel-help/use-microsoft-query-to-retrieve-ext ernal-data-HA010099664.aspx
 
 
 
if  you want to retrieve all SKUs just remove : "AND MTIT_CODE = 'MY PART/SKU ID' "
 
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  
 
Kelloggs