Inventory Reconciliation Report Queries

Purchase Reciepts Review:

SELECT T.PRODUCT_CODE, t.trx_type,T.inventory_gl,P.inventory_gl  PROD_INV_GL,
T.offset_gl,apclear_gl,
qty_change,T.COST, P.STandard_COST PRODCOST,T.qty_CHANGE*T.COST ext_cost,
t.trx_date,P.ACTIVE_FLAG,P.STOCKED,t.trx_date mo
 FROM ARTPRTRX T 
INNER JOIN ARTPROD P ON P.PRODUCT_CODE=T.PRODUCT_CODE
where trx_date between :Start_Date and :End_Date and  trX_type='R'
order by product_code,session_no,trans_no,trx_date

Cost of Sales Review:

SELECT T.PRODUCT_CODE,P.DESCRIPTION_1, t.trx_type,T.inventory_gl ORIG_INV_GL,P.INVENTORY_GL,P.costofsales_gl,
T.offset_gl,apclear_gl,
qty_change,T.COST, P.STandard_COST PRODCOST,T.qty_CHANGE*T.COST ext_ORIG_cost,
P.STandard_COST*T.QTY_CHANGE EXT_COST_STD,
t.trx_date,P.ACTIVE_FLAG,P.STOCKED,t.trx_date mo
 FROM ARTPRTRX T 
INNER JOIN ARTPROD P ON P.PRODUCT_CODE=T.PRODUCT_CODE
where trx_date between :Start_Date and :End_Date and  trX_type='S'

Physical Transaction Review:

SELECT T.PRODUCT_CODE,description_1, t.trx_type,P.inventory_gl  PROD_INV_GL,
qty_change,T.COST,t.cost*qty_change Inv_Value, P.STandard_COST PRODCOST,
t.trx_date,P.ACTIVE_FLAG,P.STOCKED 
 FROM ARTPRTRX T 
INNER JOIN ARTPROD P ON P.PRODUCT_CODE=T.PRODUCT_CODE
where trx_date>'12/31/6' and trX_type='P'
order by PRODUCT_CODE,trx_date,trx_time,session_no,trans_no