Capture of Packaging Cost in Sals tax & charges master

HI,

As we manufacture in bulk and offer our products under white label, our pricing is based on a product + packing basis.

In ERPNext I have added in the pricing of the product. However on this I would like to add the cost of packaging. Two packaging costs exists.

Primary packing - refers to bottle / packet cost.
Secondary packing - refers to boxes in which these are placed.

These are fixed costs and vary based on the size of the bottle. These costs are available on a per bottle basis. E.g. A 100 ml bottle costs 1.2Rs per bottle. The charges for the cardboard box is abt Rs0.38 based on the number of bottles that fit in a box.

I was planning to capture this using the Sales Tax & Charges Master wherein I give a fixed charge and based on the quantity the net charge is computed. However don't think this can be done directly.

As part of customization I was thinking of adding a 'Multiplier cost' option in the drop down where it says 'Actual', 'On net total' etc whereby the user could enter the cost and define the field to which it should be multiplied by. In this case we would multiply with quantity which would be a field available in the sales order.

Can someone help me develop custom script for this as this is the 1st time I'm doing something like this? If there are any other easier solutions you might think of do let me know.

Thanks & Regards,
Vikram






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.
Vikram,

Another alternative I can think of is to add Primary Packing and Secondary Packing charges as separate item in Sales Order item table.

Example below.

Sales Order Item table:

1. - Bio Product - Qty (100) - Rate (XXX) - Amount (XXX)
2. - Primary Pack - Qty (100) - Rate (XXX) - Amount (XXX)
3. - Secondary Pack - Qty (2) - Rate (XXX) - Amount (XXX)

In table table, you can define on which items tax will be applicable.

Hope this helps.



On Mon, Sep 23, 2013 at 12:59 PM, <vi...@agrilife.in> wrote:
HI,

As we manufacture in bulk and offer our products under white label, our pricing is based on a product + packing basis.

In ERPNext I have added in the pricing of the product. However on this I would like to add the cost of packaging. Two packaging costs exists.

Primary packing - refers to bottle / packet cost.
Secondary packing - refers to boxes in which these are placed.

These are fixed costs and vary based on the size of the bottle. These costs are available on a per bottle basis. E.g. A 100 ml bottle costs 1.2Rs per bottle. The charges for the cardboard box is abt Rs0.38 based on the number of bottles that fit in a box.

I was planning to capture this using the Sales Tax & Charges Master wherein I give a fixed charge and based on the quantity the net charge is computed. However don't think this can be done directly.

As part of customization I was thinking of adding a 'Multiplier cost' option in the drop down where it says 'Actual', 'On net total' etc whereby the user could enter the cost and define the field to which it should be multiplied by. In this case we would multiply with quantity which would be a field available in the sales order.

Can someone help me develop custom script for this as this is the 1st time I'm doing something like this? If there are any other easier solutions you might think of do let me know.

Thanks & Regards,
Vikram






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.