Invoice Template MERGEFIELD for $0.00 invoice item

[rdeloach]

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

[yongxiang]

Hi rdeloach, 

InvoiceItem.ChargeModel is the supported Invoice merge field, InvoiceItem_Details.ChargeModel is not. Refrence https://knowledgecenter.zuora.com/CB_Billing/IA_Invoices/Creating_a_Custom_Invoice_Template/Merge_Fi...

The invoice templated design related issue is usually complicated. `!Undefined Bookmark` is given by Microsoft Word which indicates some formula is wrong.