on 04-17-2012 1:06 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.