We have our default invoice template set to display $0.00 invoice lines ( Do not display zero value invoice line items: is unchecked on the template) . My Gross Amount formula is a nested IF statement. When I have an invoice item that is $0.00, the formula displays "!Undefined Bookmark" instead of a usable value. FORMULA: { IF {MERGEFIELD InvoiceItem_Details.ChargeModel}="Tier*" "TIER" "{ = { MERGEFIELD InvoiceItem_Detail.Sku } = "*FREE" "$0.00" "{ = { MERGEFIELD InvoiceItem_Details.ListPrice \#0.00} * { MERGEFIELD InvoiceItem_Details.Quantity} \# $,#.00;($,#.00);$ 0.00" }" }}"} Logic: IF my charge model is a tiered model, display the word "TIER" ELSE IF my SKU ends in "FREE" THEN "$0.00" ELSE ListPrice * Quantity I need to somehow check that InvoiceItems don't exist for this line item so I can set to "$0.00".
... View more