Production cost is calculated on BOM cost and not on actual material consumption cost

Hi;

When I made the production order backflush I found the incoming cost of the FG item calculated upon BOM cost and not upon actual material consumptions cost ... How can I make it calculate the product cost on the actual material consumption total cost ??




Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.
Hello Hisham,

You can update costing in BOM by "Update Cost" option. With this, the valuation of raw-material items will be updated based on valuation method selected in BOM. You should update costing in BOM before using it for Production transaction.


On Thu, Oct 24, 2013 at 9:00 PM, HF <gm...@gmail.com> wrote:
Hi;

When I made the production order backflush I found the incoming cost of the FG item calculated upon BOM cost and not upon actual material consumptions cost ... How can I make it calculate the product cost on the actual material consumption total cost ??




Note:



If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.



    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.




--
Thanks and Regards,
Umair Sayyed
www.erpnext.com



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.
Hi Umair;

Yes but I need to evaluate the stock on the actual cost of production, what if I used more quantities in the backflush this doesn't affect the finished product incoming rate which is wrong, the finished product incoming rate produced should be affected by all material consumptions in this transaction.

How can I make this happen ? I need a script to calculate the sum of all raw materials amount in the backflush divided by the quantity of the finished product in the backflush and put that amount in the incoming rate of the finished product.

Thanks.



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.
Hi Umair;

Have you found a solution for this issue ?



On Sunday, October 27, 2013 9:41:53 AM UTC+2, HF wrote:
Hi Umair;

Yes but I need to evaluate the stock on the actual cost of production, what if I used more quantities in the backflush this doesn't affect the finished product incoming rate which is wrong, the finished product incoming rate produced should be affected by all material consumptions in this transaction.

How can I make this happen ? I need a script to calculate the sum of all raw materials amount in the backflush divided by the quantity of the finished product in the backflush and put that amount in the incoming rate of the finished product.

Thanks.



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.
HF,

Thanks for the elaborated response. I have created Github issue to calculation valuation of FG item based on your suggestions. We shall update you when its released.

https://github.com/webnotes/erpnext/issues/1005


On Mon, Oct 28, 2013 at 3:08 PM, HF <gm...@gmail.com> wrote:
Hi Umair;

Have you found a solution for this issue ?



On Sunday, October 27, 2013 9:41:53 AM UTC+2, HF wrote:
Hi Umair;

Yes but I need to evaluate the stock on the actual cost of production, what if I used more quantities in the backflush this doesn't affect the finished product incoming rate which is wrong, the finished product incoming rate produced should be affected by all material consumptions in this transaction.

How can I make this happen ? I need a script to calculate the sum of all raw materials amount in the backflush divided by the quantity of the finished product in the backflush and put that amount in the incoming rate of the finished product.

Thanks.



Note:



If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.



    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.




--
Thanks and Regards,
Umair Sayyed
www.erpnext.com



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.
Thank you Umair.

HF



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.

    For more options, visit https://groups.google.com/groups/opt_out.

Hello dear friend

Any solution on this problem?