0TOTALSTCK displays data intermittently

Hi All,

I have an issue where we have query that uses 0totalstck for an opening and closing stock value. It seems to work fine with the opening and closing stock date variables being set equal to a day. Except there is one plant which has movement types prior to the day which are not being picked up. If I change it so that the opening stock day variable is less than or equal to the date specified, then it displays the correct value. The same goes for the closing stock.

This only seems to be an issue for a certain plant / material while all other plants have the correct data using a single date for both the opening and closing stock.

Can anyone advise why this might be?

Thanks in advance for any help on this.