- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Invoice Template MERGEFIELD for $0.00 invoice item
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".
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Invoice Template MERGEFIELD for $0.00 invoice item
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.