Skip to Content
0
Former Member
Dec 06, 2011 at 04:18 PM

Stock on hand at a point in time

795 Views

Hi Experts

I am busy doing an inventory report in Crystal. I need to pull the stock on hand for all the items for each month (past 4 years, +-2500 items)

At the moment, i am taking inqty - outqty where date <= (beginning of each month)

My report is taking forever to process the info.

Is there any other way I can get the stock on hand at previous points in time? Or any tricks to help SQL process the data quicker?