Item volume field in Sales Order and Delivery Note

Hi everyone

We want to be able to compute and display the TOTAL volume in cubic meters of a sales order on the sales order form. We want to show both the volume per sales order line item, and for the total order.

We currently use a workaround by using the price field for this, but this has two drawbacks:

1) We can't use the price field anymore to display price, which we realize we want as well
2) The small fractional values of our item volumes creates quantity errors when pulling data (bug submitted to erpnext team)

I realize I may need to create custom fields and custom scripts in order to
get to a separate
  • VOLUME field
  • VOLUME*QUANTITY field
  • SUM(VOLUME*QUANTITY from line order 1 to line X)

I found this (https://gist.github.com/rmehta/3866677) but not sure how to implement for my needs.

I'm not sure which form to assign the script, and how to modify the script to allow for an indefinite number of fields to get to the final grand total volume for one particular sales order form.

Maybe someone has done something similar? Hope someone can point me in the right direction.

Thanks.



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.

To post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/174dd8f7-cee3-405a-a5ac-6717b0feebdd%40googlegroups.com.

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

 

 

For those fields you should create custom fields for all sales transactions.


Then for calculation, you have to write some custom script for doctype "Sales Common". To get started, you can look into following link:

https://github.com/webnotes/wnframework/wiki/Client-side-scripting#Calculate Incentive in Sales Team table based on some custom logic


On Wednesday, 3 July 2013 10:20:14 UTC+5:30, lxnow wrote:
Hi everyone

We want to be able to compute and display the TOTAL volume in cubic meters of a sales order on the sales order form. We want to show both the volume per sales order line item, and for the total order.

We currently use a workaround by using the price field for this, but this has two drawbacks:

1) We can't use the price field anymore to display price, which we realize we want as well
2) The small fractional values of our item volumes creates quantity errors when pulling data (bug submitted to erpnext team)

I realize I may need to create custom fields and custom scripts in order to
get to a separate
  • VOLUME field
  • VOLUME*QUANTITY field
  • SUM(VOLUME*QUANTITY from line order 1 to line X)

I found this (https://gist.github.com/rmehta/3866677) but not sure how to implement for my needs.

I'm not sure which form to assign the script, and how to modify the script to allow for an indefinite number of fields to get to the final grand total volume for one particular sales order form.

Maybe someone has done something similar? Hope someone can point me in the right direction.

Thanks.



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.

To post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/7f409a83-1cbe-4102-8815-cd35f2e66e5e%40googlegroups.com.

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

 

 

Thanks. I’m not a programmer – do you know what language erpnext language uses so I can read up on the syntax?

On Wednesday, July 3, 2013 2:11:45 PM UTC+8, Nabin Hait wrote:

For those fields you should create custom fields for all sales transactions.


Then for calculation, you have to write some custom script for doctype "Sales Common". To get started, you can look into following link:

https://github.com/webnotes/wnframework/wiki/Client-side-scripting#Calculate Incentive in Sales Team table based on some custom logic


On Wednesday, 3 July 2013 10:20:14 UTC+5:30, lxnow wrote:
Hi everyone

We want to be able to compute and display the TOTAL volume in cubic meters of a sales order on the sales order form. We want to show both the volume per sales order line item, and for the total order.

We currently use a workaround by using the price field for this, but this has two drawbacks:

1) We can't use the price field anymore to display price, which we realize we want as well
2) The small fractional values of our item volumes creates quantity errors when pulling data (bug submitted to erpnext team)

I realize I may need to create custom fields and custom scripts in order to
get to a separate
  • VOLUME field
  • VOLUME*QUANTITY field
  • SUM(VOLUME*QUANTITY from line order 1 to line X)

I found this (https://gist.github.com/rmehta/3866677) but not sure how to implement for my needs.

I'm not sure which form to assign the script, and how to modify the script to allow for an indefinite number of fields to get to the final grand total volume for one particular sales order form.

Maybe someone has done something similar? Hope someone can point me in the right direction.

Thanks.



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.

To post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/6558c821-607e-4b53-9c8a-a843b9ad4de5%40googlegroups.com.

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

 

 

Sorry just to add if anyone is reading this who might be interested in freelancing to write these scripts… please ping me!

On Wednesday, July 3, 2013 7:11:29 PM UTC+8, lxnow wrote:

Thanks. I’m not a programmer – do you know what language erpnext language uses so I can read up on the syntax?

On Wednesday, July 3, 2013 2:11:45 PM UTC+8, Nabin Hait wrote:

For those fields you should create custom fields for all sales transactions.


Then for calculation, you have to write some custom script for doctype "Sales Common". To get started, you can look into following link:

https://github.com/webnotes/wnframework/wiki/Client-side-scripting#Calculate Incentive in Sales Team table based on some custom logic


On Wednesday, 3 July 2013 10:20:14 UTC+5:30, lxnow wrote:
Hi everyone

We want to be able to compute and display the TOTAL volume in cubic meters of a sales order on the sales order form. We want to show both the volume per sales order line item, and for the total order.

We currently use a workaround by using the price field for this, but this has two drawbacks:

1) We can't use the price field anymore to display price, which we realize we want as well
2) The small fractional values of our item volumes creates quantity errors when pulling data (bug submitted to erpnext team)

I realize I may need to create custom fields and custom scripts in order to
get to a separate
  • VOLUME field
  • VOLUME*QUANTITY field
  • SUM(VOLUME*QUANTITY from line order 1 to line X)

I found this (https://gist.github.com/rmehta/3866677) but not sure how to implement for my needs.

I'm not sure which form to assign the script, and how to modify the script to allow for an indefinite number of fields to get to the final grand total volume for one particular sales order form.

Maybe someone has done something similar? Hope someone can point me in the right direction.

Thanks.



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.

To post to this group, send email to er...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/f60d80d9-7ba8-4aac-86d9-e945fdacedbc%40googlegroups.com.

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