Assuming quantity is required, the following 28 results were found.
-
"PO Item ID", poi."Item Name" AS "PO Item Name", poi."Item Price (BCY)" AS "PO Item Price", poi."FCY Tax Amount" / if(poi."Quantity" = 0, 1, poi."Quantity") AS "PO Item Tax", poi."Quantity" AS "PO Qty", poi."FCY Tax Amount" AS "PO Line Tax",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
poi."Item Name" AS "PO Item", poi."Item Price (BCY)" AS "PO Item Price", poi."Graded Score" AS "PO Item Grade", poi."Quantity" AS "PO Item Qty", poi."Quantity Billed" AS "PO Item Qty Billed", poi."Quantity Received" AS "PO Item Qty Rcved", po."Total...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
Zoho had recently introduced the ability to have custom fields in your line items, alongside the product name, list price, quantity, tax, etc. In the example below, we have added a column called "Group Name" in the CRM Quote module as per the following...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
m_BooksItem = ifnull(r_BooksItem.get("item"), m_Blank); v_BooksItemRate = ifnull(m_BooksItem.get("rate"),0.00); v_ThisQuantity = ifnull(m_LineItem.get("quantity"),1); info "Line Item Rate: " + v_BooksItemRate; info "Line Item Quantity: " +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
m_NewLineItem.put("Product_Name",m_LineItem.get("Product_Name")); m_NewLineItem.put("Quantity",m_LineItem.get("Quantity")); m_NewLineItem.put("List_Price",m_LineItem.get("List_Price")); l_NewLineItems.add(m_NewLineItem); } } } // // if there is reason...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
for each r_NewLineItem in r_NewSoDetails.get("line_items") { v_NewSoItemID = r_NewLineItem.get("item_id"); v_NewSoLineItemQuantity = r_NewLineItem.get("quantity").round(0); v_NewSoLineItemRate = r_NewLineItem.get("rate");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
v_LineItem_Desc = r_QuoteDetails.Product_Description; v_LineItem_Price = r_QuoteDetails.Product_List_Price; v_LineItem_Quantity = r_QuoteDetails.Product_Quantity; v_LineItem_TaxAmount = r_QuoteDetails.Product_Tax_Amount; // v_LineItemTotalExclVat =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Product Line Items) If I call my subform "Quoted Items" and specify this having the fields "Ref, Item, SKU, Description, Quantity, RRP, Discount, Total". Add the subform to your document and ensure that none of the fields have a slightly transparent red...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
= o_ThisLineItem.Purchase_Price; o_NewLineItem.Purchase_Price_Euro = o_ThisLineItem.Purchase_Price_Euro; o_NewLineItem.Quantity = o_ThisLineItem.Quantity; o_NewLineItem.Sub_Total = o_ThisLineItem.Sub_Total; o_NewLineItem.VAT1 = o_ThisLineItem.VAT1;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
m_CrmLineItem.put("List_Price",m_XeroLineItem.get("UnitAmount")); m_CrmLineItem.put("Quantity",m_XeroLineItem.get("Quantity")); v_DiscountPercent = ifnull(m_XeroLineItem.get("DiscountRate"),0.0); v_DiscountAmount =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
} m_CrmLineItem.put("List_Price",m_XeroLineItem.get("UnitAmount")); m_CrmLineItem.put("Quantity",m_XeroLineItem.get("Quantity")); l_CrmLineItemTax = List(); m_CrmLineItemTax = Map(); v_ZohoLineItemTaxPercent =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Calculating Percentagehttps://joellipman.com/articles/else/e-commerce/calculating-percentage.html
Sell * 100 = Gross Margin Percent eg. ( 75 - 50 ) / 75 * 100 = 33.33% Margin Percentage With Discount Applied: ((( Sell * Quantity ) - Discount ) - ( Cost * Quantity )) / (( Sell * Quantity ) - Discount ) * 100 eg. ( $100 * 1 ) - $20 - ( $50 * 1 ) / (...
- Type: Article
- Author: Joel Lipman
- Category: eCommerce Systems
- Language: *
-
[ { "product": { "Product_Code": null, "Currency": "USD", "name": "Test Product", "id": "1642130000000104087" }, "quantity": 1, "Discount": 0, "total_after_discount": 0, "net_total": 0, "book": null, "Tax": 0, "list_price": 0, "unit_price": 0,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
for each m_LineItem in l_QuotedItems { r_Row = Quotes.Line_Items(); r_Row.Product = m_LineItem.get("Product"); r_Row.Quantity = m_LineItem.get("Quantity"); r_Row.List_Price = m_LineItem.get("List_Price"); r_Row.Tax = m_LineItem.get("Tax");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
m_SOLineItem.get("item_id")); m_InvoiceLineItem.put("rate", m_SOLineItem.get("rate")); m_InvoiceLineItem.put("quantity", m_SOLineItem.get("quantity")); l_InvoiceLineItems.add(m_NewLineItem); } m_InvoiceDetails.put("line_items",l_InvoiceLineItems); // //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
m_BooksLineItem.put("description",r_CrmLineItem.get("Description")); m_BooksLineItem.put("quantity",r_CrmLineItem.get("Quantity")); m_BooksLineItem.put("rate",r_CrmLineItem.get("List_Price").toDecimal().round(2));...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
ZIP1 +44 (0)1234 567890 info@mycompany.com www.mycompany.com QUOTE Quote For: Quote Date: Quote By: Item Description Quantity Unit Price Unit Discount 0) { v_LineItemTotal = 0.00; v_ThisQuantity = ifnull(c_Quote.Quantity,1).toLong(); v_TotalQuantity =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
o_NewLineItem.Discount = o_ThisLineItem._Discount; o_NewLineItem.List_Price = o_ThisLineItem._list_price; o_NewLineItem.Quantity = o_ThisLineItem._quantity; o_NewLineItem.Tax = o_ThisLineItem._Tax; // going to create a new set of line items...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
NOT ACTION) 1", "DueDate": "2021-09-13", "Date": "2021-08-13", "LineItems": [ { "Description": "My expensive product #1", "Quantity": 1, "UnitAmount": 240, "TaxType": "OUTPUT2", "TaxAmount": 48, "AccountCode": 3610, "DiscountAmount": 24, "Tracking": [ {...
- Type: Article
- Author: Joel Lipman
- Category: Xero
- Language: *
-
do this might be different for you depending on the components of your PC. So here's a list of what I used: Type Component Quantity Price (GBP) Reused components Monitor Acer K242HL 2 ~@£100.00 (at time of purchase) Monitor Dell U2414Hb 3 ~@£250.00 (at...
- Type: Article
- Author: Joel Lipman
- Category: Articles
- Language: *