Hi Jeff,

The reason for this report and data present this way are for account department audit analysis, which have keep the track of the inventory flow in and out....

Thank you all for imput...this is what I have so far.

--BUILD DATA TO USED

IF OBJECT_ID('tempdb..#tmptb1','U') IS NOT NULL

drop table #tmptb1

select identity (int, 1,1) ID, prodid,tranid, qty into #tmptb1 from...