Skip to Content
This question has been flagged
costanalysisManufacturing Order
4 Replies
3060 Zobrazenia
Avatar
Kevin Knight

I was looking at Cost Analysis reports from our manufacturing orders. I realized the cost of one of our components was entered incorrectly. The "Cost" field on the product page was set to $250 per foot when the actual price was $1 per foot. This has thrown off our cost analysis numbers for any manufacturing order that was processed using that component. 


I have corrected the cost of the item, but my problem is I would like to see that change reflected in the cost analysis as well. Can we edit the price of a component and have that edit retroactively update a closed manufacturing order's cost analysis report?


Thank you for your help! 

Avatar
Zrušiť
Avatar
Namrata Jain
Best Answer

Hello,

By updating the item cost it will not change the existing records, when you will create new orders then it will take that updated cost so for now you can update the valuation records from backend to see the changes.

Avatar
Zrušiť
Avatar
Doug
Best Answer

Hi Kevin, 
​If you haven't sorted this yet, I just had a similar issue (using v17). I was able to unlock the BoM, change the component quantity used to zero in all affected MO's. Then add the component required again to the BoM. This removed all trace of the stock moves with the wrong price and added new moves with correct price. 
Doing it this way was necessary for us as it also corrected the AVCO pricing. 

Avatar
Zrušiť
Avatar
Kevin Knight
Autor Best Answer

@Lars, 

I was not able to find the "Landed Costs" section where you said it was located. Is there another location that I can find it? 

Avatar
Zrušiť
Balagopal R

You have to enable the Landed Cost under Inventory > Configuration > Settings. Then you will see the landed cost option

Avatar
Lars Aam
Best Answer

You can modify cost from Inventory->Operations->Landed Cost

Avatar
Zrušiť
Related Posts Replies Zobrazenia Aktivita
Export MO Costs shown in overview report Solved
cost Manufacturing Order
Avatar
Avatar
Avatar
3
okt 23
3822
Cost not calculated for by products in V18 E
accounting cost Manufacturing Order
Avatar
Avatar
1
sep 25
606
Cost Of Items while completing sales transfers gets wrongly picked.
cost valuation Manufacturing Order Lots/Serial maketoorder
Avatar
Avatar
Avatar
2
máj 24
2182
How do you find the amount of raw materials from finished products?
Manufacturing Order
Avatar
Avatar
1
máj 24
2445
How Can I set about Manufacturing Order?
Manufacturing Order
Avatar
0
máj 24
2046