Currently the datasource export of Currency field on Account object returns the Currency Description (Ex."US Dollar"). This should either return the Currency ISO code (so that it is consistent with the API and reports export, which provides the currency ISO code), or there should be another field available for Currency ISO code.
... View more
See more ideas labeled with:
Status:
New Idea
Submitted on
07-12-2019
02:23 PM
Submitted by
Stephanietang
on
07-12-2019
02:23 PM

How do you report on emails that have bounced?
... View more
Status:
Under Consideration
Submitted on
08-24-2016
03:00 PM
Submitted by
ashimshock
on
08-24-2016
03:00 PM

For downstream systems, we need to pull the list/base price information from data exports, while starting at the Invoice Item and IIA level. While you can join to the product rate plan charge table, you cannot pull any pricing information. We would need base price info, in addition to any volume or tiered price information. This is currently a gap for performing downstream calculations in revenue recognition tools.
... View more
See more ideas labeled with:
Hey guys, we would appreciate it very much if Zuora gets the ability to run reports on the attached files in subscriptions or other database objects. Would be very helpful in analyzing for ex. all subscription without any attached contract or all accounts without a valid SEPA direct debit mandate or something else. The only way to filter it out at the moment is to create a custom field and enter it manually there for all objects. This is very impracticable in the daily business and not a really good solution for everyone. We would also appreciate it if Zuora gets more logic into the custom fields, like formulas or rollups, like in Salesforce for ex. Best regards, Matthias
... View more
See more ideas labeled with:
Status:
Under Consideration
Submitted on
01-13-2016
11:26 AM
Submitted by
Zuora-Community
on
01-13-2016
11:26 AM

There is an obvious operator missing from the filters in the export data sources functionality.
While it is possible to filter a list by a LIKE operator, there is no NOT LIKE operator. Thus if I want to export all subscriptions that start with "NF" I can do a filter "LIKE NF%" but if I want all the other subscriptions i.e. the ones that don't start with NF, I don't have a way of doing that.
So, can we please have a NOT LIKE operator on the filters...
... View more
Hello!
I often run reports to check for erreurs... and usually everything goes fine, and hence the reports just come empty. When errors do occur, the report lists the items I should double check or fix.
Today, there's no way NOT to send empty reports... which in my situation would be useful...
That's would be a good addition I believe, a checkbox 'Only send if no empty' r something similar...
Thanx!
-e
... View more
Customer has raised the enhancement request that there should be the ability to get an 'Average Days Outstanding' figure from Reporting rather than having to export data and do the calculation themselves or rely on the 'Aging Buckets' currently in the system. This development would be a useful metric for tracking and forecasting.
... View more
See more ideas labeled with:
Status:
Under Consideration
Submitted on
01-13-2016
11:26 AM
Submitted by
Zuora-Community
on
01-13-2016
11:26 AM

Feature Request: Allow ability to combine different data source objects together freely
Reference Number: DE9569
Business Need: Current behavior is that export ZOQL has pre-joint objects, some customers want the ability to combine them in a way as they want and do not want to be limited by those pre-joint objects.
... View more
Status:
Under Consideration
Submitted on
04-06-2016
05:58 PM
Submitted by
vmanie
on
04-06-2016
05:58 PM

The MRR (As of Day) Trend report is great, except that it pulls MRR on the first day of each month (unless I pull 1 month at a time). Can this be adjusted to pull on the last day of each month for the designated range instead of the first day? This would be extremely helpful, and I can't imagine it would take a lot to make this change.
... View more
Status:
Coming Soon
Submitted on
03-24-2016
12:28 PM
Submitted by
TraciLowry
on
03-24-2016
12:28 PM

Zuora should have a way to report in a base currency with pre-defined exchange rates (e.g. aging report in US dollars, converting Canadian dollar invoices into US dollars for report purposes). At this time, there is a third party offering some client's don't need. We need a static.
... View more
would be great to have reporting to audit all communications/notifications sent from Zuora. thanks!
... View more
Status:
Coming Soon
Submitted on
05-08-2017
10:57 AM
Submitted by
LColeborn
on
05-08-2017
10:57 AM

We would like to be able to customise the MRR (Contracted) Reports to add in product information - SKU/rate plan charges etc in order for us to get a deeper understanding & visibility of revenue & churn by product. This will also help with our supplier bill reconciliation and product profitability understanding.
So by month we would know the start MRR, the end MRR, the gains and losses for each product with each customer within the month.
The link between Account and product already exists via different data sources but cant be added into this report as it stands
... View more
See more ideas labeled with:
Status:
Under Consideration
Submitted on
04-07-2017
03:38 AM
Submitted by
peterwalsham
on
04-07-2017
03:38 AM

Currently the reporting options only allow for Calendar Year and Calendar Quarter. Financial Year and Financial Quarter options would also be extremely useful. We end up creating many reports by month, exporting to spreadsheets and then manually summing over the financial year and quarter periods. Financial periods in reporting would remove a lot of this extra manual work! Related to request for " Biannual / Half Year option for reporting - not just Year or Quarter " https://community.zuora.com/t5/Reporting-Ideas/Biannual-Half-Year-option-for-reporting-not-just-Year-or-Quarter/idi-p/12942
... View more
Status:
Under Consideration
Submitted on
01-13-2016
11:26 AM
Submitted by
Zuora-Community
on
01-13-2016
11:26 AM

I've already submitted this as a request. It's logged under PMT-1751
Summary of the enhancement? Data is not stored consistently in Zuora. A field that has a NULL value in it when the record is created will be changed to empty string '' when that record is updated via the Zuora UI even if that field's value isn't explicitly being changed.
What is the business problem? The problem with this data inconsistency is that ZOQL treats NULL and '' as distinct values (which is fine, although Salesforce treats them as the same in SOQL). We have custom integrations with Zuora that use the SOAP API to make ZOQL calls and it makes it difficult to find records in the Zuora database when we are looking for records with "empty" values (NULL or ''). Since the ZOQL language is also limited with it's ability to use AND and OR statements together we end up having to make 2 separate calls. One to find records meeting a certain criteria and with a NULL value in a particular field and then another almost identical call but with '' in that particular field.
What is the business impact? We have to implement inefficient code to find the records we are looking for.
Is there a workaround or is the customer blocked? If there is a workaround, what is it? Is the customer willing to apply this workaround? The workaround currently is to have two different ZOQL calls.
What is the proposed solution (if available)? A solution would be to treat NULL and '' as the same value in ZOQL queries (or perhaps have that be an option to choose in the QueryRequest) or to preserve NULL values when records are edited through Zuora UI.
... View more
Status:
Under Consideration
Submitted on
01-13-2016
11:26 AM
Submitted by
Zuora-Community
on
01-13-2016
11:26 AM

Feature Request: Add the ability to query MRR of a past day
Status: Currently being reviewed by our Product Management
Reference Number: PMT-1317
Business Need: Currently Zuora can only support getting "Today's MRR" with the query like "RatePlanCharge: ((Subscription.Status = 'Active' and RatePlanCharge.EffectiveStartDate <= '2013-05-20') and RatePlanCharge.EffectiveEndDate >= '2013-05-20') ". Customer wants the a bility to query Zuora for MRR in the past, not only for MRR of the day. And at any level, from invoice item up to account level or Zuora instance level. Because according to our customers, MRR is a key metric and it is essential to be able to analyze it over time, not just today's snapshot. C ustomers expect that such metric information is part of Zuora's core capabilities.
... View more
Status:
Under Consideration
Submitted on
11-01-2016
04:23 AM
Submitted by
peterwalsham
on
11-01-2016
04:23 AM

There are multiple reporting features where you can choose to group by time period. A Biannual / Half Year option between Year and Quarter would be great. Use cases include: Reports where there is too much variation at quarterly level, but an annual grouping would not give enough detail Sales or Customer Success targets that are measured twice a year
... View more
Status:
New Idea
Submitted on
08-23-2019
03:24 PM
Submitted by
Stephanietang
on
08-23-2019
03:24 PM

We currently have the option for 'Invoice: Last Emailed Sent Date," can we also have a field for: First Emailed Sent Date? I want to be able to identify when invoices were first sent from a Bill-run. Let me know if there are any work arounds.
... View more
Status:
Under Consideration
Submitted on
01-13-2016
11:26 AM
Submitted by
Zuora-Community
on
01-13-2016
11:26 AM

Include USD, currency conversion date, and home currency, to the out of the box Aging report. The client needs an aging report that includes both the home currency of the account as well as the USD amount (since they track everything in USD at the GL level).
... View more
Status:
Under Consideration
Submitted on
03-24-2017
06:33 AM
Submitted by
twest
on
03-24-2017
06:33 AM

I see the Staus field in the Product Page w/in the Product Catalog. I can even sort the product catalog on this field values (active or cancelled). So, this should be added to reporting. The start/end dates are a way, but not as straight forward
... View more
Status:
Under Consideration
Submitted on
03-22-2017
11:43 AM
Submitted by
skennedy
on
03-22-2017
11:43 AM

how do you manage people who are subscribed to reports? specifically - if they leave the company - how can i easily see a list of all reports that that person was subscribed to, so i can then remove them from the sceduled report.
... View more