Skip to Content
0
Former Member
Jul 21, 2009 at 06:28 AM

No stock showing in Inventory on date stock report

241 Views

Hi

I have created a Stock on date query at plant material level using standard cube 0IC_C03

to get stock quantity on posting date i have restricted 0TOTALSTCK

by 0CALDAY variable .

Correct me if any thing wrong to get on date stock.

When i m executing that report for date 20.07.2009 , it shows 0 qty for a given Plant(1001) and a given material(ABC)

where MB5B report in R/3 with same date show sum stock qty.

again i executed the report with 17.07.2009 , on which the material(ABC) was lastly transacted for that given plant(1001)

for this date i m able to match the qty with MB5B.

Then i check sum other stock report which is at 0CALMONTH level wen executed with 07.2009 shows correct qty.

Now my question is y it is showing 0 qty wen the stock is there in it ? is query definition not proper to get stock on date ?

Thanks and regards,

Sonal....