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?
Accepted Solutions
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.
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.
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.
