Assuming subtotal is required, the following 4 results were found.
Discrepancy Total", 0) / if(if_null(pquantity."PO Total Qty", 0) = 0, 1, pquantity."PO Total Qty"))) AS "PO Subtotal excl Tax", (poi."Quantity" * (poi."Item Price (BCY)" + (if_null(pshipping."PO Delivery", 0) / if(if_null(pquantity."PO Total Qty", 0) =...
record only has 1 item. void emailMergedReceipts(Partners_Quote l_Quotes) { v_ContactFname = ""; v_ContactSname = ""; v_SubTotal = 0.0; v_TotalVat = 0.0; v_Total = 0.0; v_Total_Tax_Factor = 0.2; for each r_Quote in l_Quotes { r_QuoteDetails =...
ID of the quote): // init Map m_UpdateQuote = Map(); // r_QuoteDetails = zoho.crm.getRecordById("Quotes", p_QuoteID); v_SubTotal = r_QuoteDetails.get("Sub_Total").toDecimal() * 0.2; v_GrandTotal = r_QuoteDetails.get("Sub_Total").toDecimal() * 1.2;...
options available to be ticked, the same popup will appear if you click on the edit icon in the header "Tax" (applies to subtotal). Note: If you do not do the second section as per this article, even having customized the tax rates, when selecting a...