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".
