Moving Average Price for Sales stock and Project stock of a material

[Former Member]

Hiya Gurus,

I am developing a report to display inventory details. My requirement is that I have to display the Moving average price of a material for all Valuation type. I also need to display the Moving average price if a material has got Project stock or Sales stock.

In MBEW table I can get the Valuation type and its Moving average price, but how can I find the moving average price for the same material if it has got Sales stock and project stock. Please let me know the table and field where I could get the relevant data.

Kindly help me on this, it would be deeply appreciated.

Cheers,

ZIa

[Former Member]

Hi

can you look at tables

EBEW Sales Order Stock Valuation

QBEW Project Stock Valuation

Nat

[Former Member]

Thanks vey much mate,

In those tables i can get the Moving average price.

Cheers