Storage location wise project stock valuation

[Former Member]

Hi all,

I am tying to generate a report for storage locationwise project stock valuation. MBBS is giving the data valuation type as well as WBS element wise valuation.That is fine. I want to show the data storage location wise. So, I have taken MSPR table where I am getting data storage location wise. For this stock, i am picking up unit price from QBEW table. My user says there will be cases that the material comes in with different prices in a same financial period.Here I am facing issue when there are two prices for the same material with same Val.area and same WBS element .Pls tell me how can I pick up the correct price.

[Former Member · Accepted solution]

Hi,

In this case, I don't think storage location is the correct way to differentiate the price. You need to implement valuation type in MM stock and MBBS report can be use to get the price based on valuation type.

[Former Member · Accepted solution]

Yes, but MSPR table does n't have valuation type. Please let me know where I can get the valuation type for every record in MSPR table. Thank u for response.

[Former Member · Accepted solution]

in MSPR the field is CHARG. For each valuation type in valuation area you can have different price.

Hope this helps.

[Former Member · Accepted solution]

Hi Fadli,

here valuation type is not updating in QBEW . Even , batch is not updating in MSPR table. Hope batch management is not activated. What may be the solution then? Can we prepare a report storage location wise then ?

[Former Member · Accepted solution]

Hi,

If stock with different price under 1 plant and 1 WBS Element put into different storage location based on the material price then in table MSPR we can have LGORT (storage location) as indicator there. Otherwise, since valuation type is not implemented, there is no other way you can differentiate stock based on price as you mentioned before.

[Former Member · Accepted solution]

yaa yaa, but storage location is not there in QBEW table. Price is coming from QBEW . Here data is updating WBS element wise only naa.

[Former Member · Accepted solution]

Closing thread