Valuated stock quantity not matching in from IC_C03 cube

[Former Member]

Hello Experts,

While I am checking Valuated stock quantity from standard cube it is not matching with my MC.9 valuated stock in R3.

I have checked issued quantiy and recieved quantity of the month and it matches as in MC.9.

Can any one help in finding what could be the reason, as I understand Valuated stock is a non cummulative key figure calculated on the basis of Issued Quantity and Reciept quantity.

Thanks in advance.

Warm Regards,

Neha

[Former Member]

The Issue and receipt might by matching, but it all depends on the intial stock. If there was a mistake done during the opening stock load, even if you have issue and receipt in sync with r/3, your stock as of now would not match.

Can you take one sample material for which your stock is not matching and browe the content of the cube with the following selection.

Material - Selected Material

Record ID - 1

1. Browse the content and check the opening stock of the material.

2. Now go to cube manage and see, what is the last request which has been compressed in the cube.

3. Now take the issue / receipt starting the last compressed date till date and do the arithmatic and add the opening stock into it and see if that matches.

Thanks,

Danny

[Former Member]

Dear Danny,

Many Thanks for your reply.... Could You eloborate a lil more as I am a New Bee to the Inventory Mang. Looking forward to hear from U....

[Former Member]

Hi Neha,

Could you help me out....

Not all the Materials of IC_C03 cube data is matching with the MC.9 Report, Only Few Material Stock Value is matching with my BI Min Max Report. I don't know the reason behind.

One more thing, could you please help me how to make query for ValStock Value.

Your Help is much Appreciated.

Edited by: Harsha on Feb 19, 2011 11:25 AM