Happy Business Starts Here

Highlighted
Scholar

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

1 REPLY 1
Zuora Support Moderator

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. 

 

Regards,
Yong Xiang | yxiang@zuora.com
Application Support Engineer | Zuora Inc.



SigNowBlue.png

 


If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √