Get sum of net rate in sales invoice

1

In sales invoice there is sales invoice item table i need to get sum of total net rate … in custom script i cant write script for child table … any one have idea?

Thank you

script for net rate
script for net rate1432×361 15 KB

2

total net rate - Copy
total net rate - Copy1531×706 23.6 KB

total rate - Copy
total rate - Copy1554×511 28 KB

This is my code.

3

@GhadaEbrahim Doctype you selected is Collection Invoice and code you are writing is on Sales Invoice, seems weird.

It should be Collection Invoice

4

The doctype is sales invoice i just rename it to collection invoice

5

@GhadaEbrahim Ok,

Try with after_save method

6

I tried it but not working …
both field type (rate and total rate) are currency , it should be float ??