Preview:
//For Negative validation Check
if(row.Rate < 0 && row.Rate != null)
{
	alert "Please enter positive values";
	row.Rate=null;
}
else
{
	get_tax_value = GST_Details[ID == ifnull(row.Tax,"")].Total_Rate;
	Tax_calc = ifnull(row.Qty,0) * ifnull(row.Rate,0) * ifnull(get_tax_value,0) / 100;
	amount_calc = ifnull(row.Qty,0) * ifnull(row.Rate,0);
	row.Sub_Total=ifnull(amount_calc,0.00);
	row.Tax_Value=ifnull(Tax_calc,0);
	row.Total_Amount=ifnull(amount_calc,0) + ifnull(Tax_calc,0);
	//alert amount_calc + Tax_calc;
	tot = 0.0;
	subtot = 0.0;
	totqty = 0.0;
	for each  rec in Item_Details
	{
		tot = tot + ifnull(rec.Total_Amount,0.0);
		totqty = totqty + ifnull(rec.Qty,0.0);
		subtot = subtot + ifnull(rec.Sub_Total,0.0);
	}
	input.Item_Total = tot;
	input.Overall_Total = tot + ifnull(input.Extra_Charge_s_Total,0.0);
	//new field calculation starts here - 1/4/2023
	//input.Gross_Total = ifnull(input.Gross_Total,0.0) + ifnull(row.Sub_Total,0.0);
	//input.Grand_Total = ifnull(input.Gross_Total,0.0);
	input.Total_Quantity = ifnull(totqty,0.0);
	input.Gross_Total = ifnull(subtot,0.0);
	input.Gross_with_Discount = ifnull(input.Gross_Total,0.0);
	if(input.Discount_Amount > 0)
	{
		input.Gross_with_Discount = ifnull(input.Gross_Total,0.0) - ifnull(input.Discount_Amount,0.0);
		input.Overall_Total = ifnull(input.Overall_Total,0.0) - ifnull(input.Discount_Amount,0.0);
	}
	else
	{
		input.Gross_with_Discount = ifnull(input.Gross_with_Discount,0.0);
	}
	get_tax_value = GST_Details[ID == ifnull(input.TaxP,"")].Total_Rate;
	if(get_tax_value == 0)
	{
		input.Gross_Value_Tax = 0;
		//	input.Grand_Total = ifnull(input.Gross_Total_after_Discount_PF,0.0);
	}
	else
	{
		Tax_calc = ifnull(input.Gross_with_Discount,0.0) * ifnull(get_tax_value,0.0) / 100;
		input.Tax_Total = ifnull(Tax_calc,0.0);
		input.Gross_Value_Tax = ifnull(Tax_calc,0.0);
		input.Gross_Total_with_Discount = ifnull(input.Gross_with_Discount,0.0) + ifnull(input.Gross_Value_Tax,0.0);
		//	input.Grand_Total = ifnull(input.Gross_Total_after_Discount_PF,0.0) + ifnull(input.Tax_Total,0.0);
	}
	if(input.Packing_Forwarding > 0)
	{
		Tax_calc1 = ifnull(input.Packing_Forwarding,0.0) * ifnull(get_tax_value,0.0) / 100;
		input.PF_Tax_value = ifnull(Tax_calc1,0.0);
		input.PF_Total_with_tax = ifnull(input.Packing_Forwarding,0.0) + ifnull(input.PF_Tax_value,0.0);
	}
	input.Grand_Total = ifnull(input.Gross_Total_with_Discount,0.0) + ifnull(input.PF_Total_with_tax,0.0);
	//new fields calculation ends 
}
downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter