on 10-25-2010 12:10 PM
Hi,
COPA planning updated through manual entry in excel sheet which was shown in right side of the KEPM, planning updated successfully with breakup of material cost,labout cost and machine cost in KE30 report. But when i do Excel sheet upload through KE13N system is updating only sales qty and sales value in KE30 report and it is not updating the material cost,labour cost and machine cost. Can anyone guide me what necessary setting to be done for this update in KE30 report.
govind.
Hi
I dont know if you have manually updated the break up of RM cst, labor from excel... If yes, it wud update whatever you upload
But, if you want to upload only the qty and want to derive the break up automatically from system, follow the steps
1. COPA > Master Data > Valuation > valuation strategy : Create a Valuation strategy , say, 002 and assign to point of valuation 04.. (I guess 04 is meant for planning)
2. IN KE4J or KEPC - Assign costing key to point of valuation 04, record type and material types ,etc
3. In KE4R - Assign Value fields in all the 6 columns against your cost comp structure
4. After you upload in KEPM, you need to run the step VALUATION... Or VALUATION indicator must be switched on in your KEPM settings for auto valuation
Regards
Ajay M
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ajay MAheswari,
Thanks for your valuable input. Actually in KEPM i have entered two products with plant,customer,product, sales qty and sales value, and then i have posted the detail i am not given any material cost,labour cost and machine cost in the KEPM. But in KE30 report system has posted with breakup of material,labour and machine as per cost component structure. Same time if i do the excel upload system is not updating the breakup of cost component structure in KE30 report. Is there anyother customizing missing.
govind.
Hi ,
Please check wether KE4R ( assigning Cost Elements to Value field) has been done..
Regards
Sarada
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
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.