Price update with split valuation

[former_member417357]

Hi,

Business wants to maintain multiple stock against multiple valuation type.

I have done the necessary setep in split valuation. Create valuation category and set it as auto batch determination.Not created any valuation type.

assign the plants to valuation category.

Mean time created material master with accounting view  and set price control as V with price as 10 rupees. at plant header level.

Then created PO with that material and plant and assign valuation type as X and batch is also X.complete GR.

I can see the accounting entries  are not correct. Material Debit.......GR/IR credit.......PRD Credit

I can see the material master update with valuation type X maintained price control as S and standard price updated with 10 rupee and MAV as 1 rupee.

Initial Price control as V with price as 10

Update price against valuation type X with price control as S and with MAV as 1 and standard price as 10 after goods receipt.

For EX :

PO qunatity as 40000 and price in PO as 10 rupees.

after goods receipt,

The accounting entries as

Material : 400000 +

GR/IR : 4000 -

PRD : 396000-

I have 2 clarifications :

1. Why price control got changed from V to S and 10 to 1 rupee as  MAV price while updateing prices against valuation type in material.

2. Why system pick MAV price from material accounting view  as 1 rupee instead of fetching from PO price.

Please let me know what goes wrong and how to fix this issue.

Thanks

Santosh

[tejyadav]

Check this Material in MM60 & find out how many Valuation type is created for this Material, Then Check your PO what Valuation type is selected in PO, You will come to know the Problem.

[former_member417357]

I can see the material is maintain at header level with price control as V with 10 rupees.

and it is maintained with valuation type which I entered during the time of PO with price control as S.

There are 2 records for material. 1. With out valuation type and 2. With valuation type.

[former_member417357]

Hi Friends,

This is very urgent. Please help.

My only concern is  why system update price control as S instead of V (How it determines) while updating material master with new  valuation type once we receive the goods.

Any solution highly appreciated.

Regards

Santosh

[tejyadav]

Initial Price control as V with price as 10
Update price against valuation type X with price control as S and with MAV as 1 and standard price as 10 after goods receipt.
I have 2 clarifications :
1. Why price control got changed from V to S and 10 to 1 rupee as  MAV price while updateing prices against valuation type in material.
2. Why system pick MAV price from material accounting view  as 1 rupee instead of fetching from PO price.
I can see the material is maintain at header level with price control as V with 10 rupees.
and it is maintained with valuation type which I entered during the time of PO with price control as S.
There are 2 records for material. 1. With out valuation type and 2. With valuation type.

As you said in MM60 you can see material with only 1 Valuation type with price control 'S', So logically now your material will be acting as only 1 material with price control 'S'

Basic concept of Split Valuated material is, The Header Material will be only for informational purpose & will not act as Active materials,

In case of Split Valuation, Materials with Valuation type play the active role, So now in your case, the Material is having only 1 Valuation type with price control 'S', So you do any Process i.e. Purchase or Sales or any good movement by default this Valuation type will only be pulled, that's the reason you got the above accounting entries & it is completely perfect,

So solution for you will be to Extend the material for 1 more Valuation type having price control 'V',

Maintain the appropriate price in that i.e. 10 rupees, Now when you make PO for that material, since you are now having 2 Valuation Type, now system will ask you to select the appropriate Valuation type & will not assign the default Valuation type with price control 'S',

Select Proper Valuation type & Test your Scenario.

[former_member182609]

Have you updated split indicator in PO X as s intem detail screen?.If yes then it change it to moving average price then it will automatically caluculate the price.It seems in your PO valuation type is changed to 'S'

[former_member417357]

Thanks for the update.

Here the requirement is  the reverse one. Business does not want to create any valuation type initially.

thats why instead of assigning valuation type against valuation category we have set valuation category as "Determine valuation type automatic" field checked mode.

Now while receiving the goods we need to assign valuation type manually at the time of GR. and the stock with valuation type will get updated in MBEW . This issue is while updating valuation type with stock and it got updated with price control as S instead of V.

Hope it is clear now.

Santosh

[tejyadav]

What Valuation Category are you using, I would suggest you to go on that field "Determine valuation type automatic" through OMWC & Press F1 & read the usage of that field.

[former_member417357]

Please provide the detailed path. Where I need to check split indicator.

[former_member417357]

Hi ,

Could you please more elaborative. i am not able to find the path. This is very critical to fix this.

Need your help.

Thanks

Santosh

[Former Member]

Please check the price control at material level