- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Question:
In an invoice PDF/template preview, is there a way to display the negative amounts with the minus/negative "-" sign instead of enclosing them in parenthesis? If so, can you please teach me how?
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Answer:
The merge field function in an invoice template is essentially controlled by Microsoft Mail Merge feature, and creating or modifying invoice templates based on customer mockups/requirements is out of Zuora Support scope according to this article. Therefore, we are providing suggestions based on online research as a courtesy.
Steps:
1. Toggle the field code and result:
- Press Shift + F9 on Windows.
- Press option + fn + F9 on Mac.
2. Add the following into the merge field.
\# "$,0.00;-$,0.00"
E.g. Before modification:
After modification:
3. Save the template, upload to Billing Settings > Manage Billing Document Configuration.
4. Preview the template/generate an invoice PDF file.
5. Observe the result.
E.g. Before modification:
After modification:
For more features or functionalities regarding Mailmerge Number & Currency Formatting, you may refer to this MS TechNet discussion or contact Microsoft support.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Answer:
The merge field function in an invoice template is essentially controlled by Microsoft Mail Merge feature, and creating or modifying invoice templates based on customer mockups/requirements is out of Zuora Support scope according to this article. Therefore, we are providing suggestions based on online research as a courtesy.
Steps:
1. Toggle the field code and result:
- Press Shift + F9 on Windows.
- Press option + fn + F9 on Mac.
2. Add the following into the merge field.
\# "$,0.00;-$,0.00"
E.g. Before modification:
After modification:
3. Save the template, upload to Billing Settings > Manage Billing Document Configuration.
4. Preview the template/generate an invoice PDF file.
5. Observe the result.
E.g. Before modification:
After modification:
For more features or functionalities regarding Mailmerge Number & Currency Formatting, you may refer to this MS TechNet discussion or contact Microsoft support.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: How to Display Negative Sign "-" Instead of Parenthesis "()" in an Invoice
I want to put negetive in () in charge summery, for a template built for multiple currencies, but when I do so the currecy disappear, is there a way to keep both.