Skip to Content
0
Former Member
Sep 16, 2005 at 01:53 PM

Problem in Stock

13 Views

hello all,

I have created query on 0IC_C03 which displays closing stock,receipt and issue stock. For this query, I have created a structure in which there are two selections:

1) for first selection, the restriction is on date .

2) For second selection,the restriction is on month for which I have created a customer exit variable which calculates the month based on the date entered by user.

If i execute the query for 05/08/2005 the result expected in the first columnis is it should display the closing stock of 05/08/2005 and in the second column it should display the closing stock of 31/08/2005.But when the result (both columns) comes it is not matching with R3 .

Now if i remove the 2nd selection ie, for the month and execute the query the result is getting tallied with R3. That is closing stock for 05/08/2005 is matching with R3.

It is even matching if i remove the first selection and hardcode 08.2005 for the second selection.

Not getting why difference is coming if i used both the selection in the structure. Any suggestion would be greatly appreciated.

Thanks in advance.

regards,

Anuj