Item Table in Quotation - Total Issue

Sumit_Arora · December 22, 2016, 8:08am

Hi, I have added another Quotation Table in Quotation form, but I am getting issue with Total, please have look on screen shot for same.
red boxed is added table and blue boxed is default one. total is coming only for default.

Please suggest what i need to do to rectify this.

shachiTakalkar · December 23, 2016, 6:52am

@Sumit_Arora can you add a screenshot of the customization you have done to add the table?

Sumit_Arora · December 24, 2016, 5:20am

Please have look on below screenshots

shachiTakalkar · December 27, 2016, 9:06am

@Sumit_Arora you have to write a custom script for calculating values in the custom table.

rohit_w · December 28, 2016, 6:11am

Hi @Sumit_Arora,

System uses the the table which has fieldname items, check below code

github.com

frappe/erpnext/blob/master/erpnext/controllers/taxes_and_totals.py#L161-L170


      
          					self.doc.get("taxes")[cint(tax.row_id) - 1].grand_total_fraction_for_current_item
          
          
		if getattr(tax, "add_deduct_tax", None):
          			current_tax_fraction *= -1.0 if (tax.add_deduct_tax == "Deduct") else 1.0
          		return current_tax_fraction
          
          
	def _get_tax_rate(self, tax, item_tax_map):
          		if tax.account_head in item_tax_map:
          			return flt(item_tax_map.get(tax.account_head), self.doc.precision("rate", tax))
          		else:

You have to make changes in this file and making changes in this file will broke your application.
Can you share the case study to add new child table Quotation Item which is already there on the Quotation?

umair · December 28, 2016, 6:16am

Another example on how to write a custom script for the calculation.

https://youtu.be/PTbZY9grZ9k?t=18m42s