Set value to Custom field in a table row


As per the new law is Saudi Arabia, we need to display item wise tax in Sales Invoice. It should be like below

I have added two new custom fields, vat and vat_value, in ‘Sales Invoice Item’ form. ‘vat’ is a select doctype with different tax rates. When we select the item, qty and vat, it should automatically populate the ‘vat value’ and ‘total’.
The row total should be ‘qty’ * (‘price’ + ‘vat value’).
How could we achieve this?

KR, Fasil.

ERPNext Version 10 (released a few hours ago) is VAT ready. You don’t need to add a custom field for this.

Thanks Rush

Unfortunately that didnt address my requirement.

:slight_smile: Fasil