On a inventory Detail report  I needed to show 2 additional field-
1. When was the first date that the item was first sold- e.g I get the result with this query for a specific invtid.
select min(ShipDateAct)  from SOShipHeader where shipperid in
(select shipperid from SOShipLine where invtid = '9781591041542');

2. I am trying to see what the Itemhist2.YTDQtySls is for the year before
the year that I am running the report for. The YTDQTYSLS numbers are stored for each Year (Year is coloum FISCYR in table Itemhist2)
So if I am running the report for 2007 I want to see the Itemhist2.YTDQtySls numbers for the year before ie.2006

I would really appreciate any help with this


Thanks

Sam



Edited by scommar1 - 10 Apr 2009 at 10:06am

I can use either but i need your help my friend. I dont know how to.