About Thoeff

Thoeff

Got it ... {Currency] of course is not defined! Thanks

Thoeff

Hi Ben, thanks for sharing. Looks very good for me. I checked a few of my invoices, I like the part with BMG2 beeing the difference. With my solution I had rounding issues. I get the right numbers, great, but also :Error! Bookmark not defined ... no worries I will figure this out. Kind regards Thomas

Thoeff

Dear Community, in my word document I get an error message for calculations done with the a mergefield. The issue is, that the formula seems to work for most of the invoices, but not for all. {={Mergefield TaxSummary.TaxExtendedAmount}/{TaxSummary.TaxRate}/100} is delivering most of the times the correct value, but a view time !syntaxError. I figured out, that the error is issued by the field TaxExtendedAmount. Background: Because of the german VAT change I need to show on some invoices both tax rates and both tax amounts. Therefore I use the TaxSummary table. Issue is that this table does not contain the net amount by tax rate, so I claculate this by dividing the TaxExtendedAmount with the TaxRate. Maybe this is not the best way I do it ... How do you solve the issue to show the separate net amounts for invoices with different tax rates? Answers in German are also welcome 😉 Kind regards Thomas

Thoeff · ‎01-31-2020

Hi perswardh, I checked your solution and Ithink that is the right direction to go. Not exactly what I am looking for, but a very good advice to do further investigations for me. Thanks and Kind regards Thomas

Thoeff · ‎01-30-2020

Hi Everybody, I am looking for a way to create related prices. E.g. customer busy product A for € 100,00, then the price for product B should be € 75,00. If he buys A for € 150,00 price for be should be € 95,00. Anyone ever had the same issue? How did you solve it? Kind regards Thomas

Thoeff · ‎11-12-2019

Hi, I tried the same. I solved this with the Mergefield {If "{BillToContact.WorkEmail}"="" ... ...} However, this works only if users keep the email address empty for customers with print version. Any one other ideas? Kind regards Thomas

Thoeff · ‎07-26-2019

Hi @Yong , thanks for your link which helped me together with another link. So I got a solution, I would like to share: Situation: Account has recurring contracts and usage contracts. To avoid diferent invoice templates/accounts, create a invoice template that shows usage infomation only and really only if usage is invoiced. How to do: Create the table for the usage you want to show on the invoice Create a bookmark for the field Usage.UOM How to create a bookmark:https://community.zuora.com/t5/Zuora-CPQ/Cannot-use-the-same-mergefield-outside-of-table/m-p/21674#!/%23M1497 Create a IF (thanks Yong) and use as operator the bookmark {IF «Usage.UOM» = "Letter" "" ""} CUT the usage table (actually outside the IF command and PASTE it to the "then" part of the IF command. For 3.: my UOM is letter, but it is probably different for other cases or you might to expand the condition by "Or" commands. The screenshot does not show the perfect fomat, but here I only describe the way. Kind regards Thomas

Thoeff · ‎07-22-2019

Hello Outthere, has anyone experience with printing Girocodes on Zoura invoices? Kind regards Thom

Thoeff · ‎06-26-2019

Dear all, I am looking for your experience and ideas ... SITUATION: We are a multi entity I want to use 1 inoivce template per unit. This should cover all kind of subscriptions, one-time, recurring, usage. So we have customers with recuring subscriptions and customers with usage subscriptions. The table with the usage details/summary should only be visible when there is a usage. I made this happen see attached screenshot / file, but the header for the table is repeatet line by line. I tried several ways to build the table but I am not happy with the result. QUESTION: Anyone here who had the same issue and solved it? Kind regards Thomas

Thoeff · ‎06-17-2019

Hi Yong, sorry for my late reply and thanks for your idea, which is probably a good one. Only issue I see ... We would need to pay Zuora fees for sales we didn't made with the Zuora tool .... But ... thinking forward ... do what you suggest with price 0,00 for all contracts an do ammendment for the next invoice date. I will try. Kind regards Thomas

Thoeff · ‎06-17-2019

Little update ... sometimes you need to switch back Zuora to English (US) / English before the upload ... don't aks me why ...

Thoeff · ‎06-17-2019

Hi, this is not a request, just a how-to-do when it comes to uploads like customers, subscriptions directly in Zuora. So just want to note my learnings: We had issues uploading name containing special charakters, like ä, ö , ü, ... because Zuora did not recognize. Happy to get your feedback for solutions easier to use. -> How to upload fields with special characters: 1. Switch your Zuora to Profil German 2. Select Zuora language German 3. Switch your windows to English (United States) 4. Download the template from Zoura 5. enter your data to the template 6. replace all special characters by coding ö to Ã¶ ü to Ã¼ and so on complete list found www.i18nqa.com/debug/utf8-debug.html 7. Save your csv 8. Upload to Zuora DONE Kind regards Thomas

Thoeff · ‎05-23-2019

Dear all, I am adding a "old" subscription to Zuora. The Subscription contains 1 timer products and recurring. The subscription is from 2018 or sooner and was invoices in the past by an other system. If I enter this contract with the old dates, Zuora wants to invoice. A catch up bill run does not help/work, since already other subscription on the specific account are invoiced by Zuora. I can not "activate" the "old" subscription with current activation dates, because the 1 timers would be invoiced again by Zuora. Anybody with an idea out there? Kind regards Thomas

Happy Business Starts Here

Vision

Products

Zuora Central Platform

Products

Zuora Marketplace

Solutions

By Industry

By Role

Customers

Resources

Resources

Subscribed

Support

Company

Re: Syntax error in formula

Re: Syntax error in formula

Syntax error in formula

Re: related prices

related prices

Re: Invoice Template: Invoice Delivery Preference Conditional

Re: Add usage table to invoice if and only if usage is invoiced

Girocode

Add usage table to invoice if and only if usage is invoiced

Re: Add an "old" subscription / contract

Re: Handle Umlaute / special characters in Zuora

Handle Umlaute / special characters in Zuora

Add an "old" subscription / contract