It looks like the only way to examine uploaded forex rates is via API, and by a custom call at that (query does not work).
Please let Zuora users examine uploaded forex rates.
currently when we introduce a new product and rate plans etc. Product Managemnt just prices it out in USD. So we have to then look up the current exchange rate to get the EUR, GBP an CAD prices and then we set up the rate plans and charges etc.
And then 6 months from now - the sales team is quoting in EUR. and if you were to do the conversion back to USD - it wouldn't match the list price in USD.
And then again say the purchase isn't made for another month or so, the XE rate is yet again different then what was used when the product was introduced, when it was actually billed.
So basically there are 3 conversions going on - when the product is created, whenthe product is quoted, and when the prouct is billed.
It's kind of painful, each month when the exchange rate is updated in the system - to them make all the adjsutments on the products as well. the only way i know is to export the product catalog, adjust the pricing and reimport.
Option A. when the exchange rates are updated in the system - that it then also updates the pricing on the rate plans.
Option B. only have pricing in USD. and then give the option on the quote or something to convert at the time to other currency - using the most recent conversion rates in the system. and when then quote is sent to ZBilling - it keeps the same rate, that i was quoted on.
** Our cusotmers want to see quotes in EUR, GBP etc.
Scott Weinberg - Quickbase
Mar 21, 04:57 PDT
Is there a way to run the Revenue Detail report that is provided in the Accounting Period section on a full year basis, or for a selected period, rather than just per month?
WSDL support for Finance related custom fields in WSDL, currently such fields are not added to the WSDL automatically. Requires workaround of adding the fields into the WSDL manually.
We were informed that the "Download Summary Tab Information" in the Accounting Period will be soon phased out. Is there a way to request that this be retained in our production tenant? We find this to be more concise and useful plus it gives us a clear representation/snapshot of the monthly movements in the Accounting Period. The exported "Journal Entry Item" report/extract has too many details and I don't think the numbers are reconciled with the figures as presented by the "Download Summary Tab Information" in the Accounting Period.
Thanks and hope this can be considered.
We need to run the Trial Balance Report in Zuora every Tuesday at 5:30am AEST. Since we perform the activities out of India, we have to log in early just to run this report. Also, it takes a long time to generate the report when we initiate it from India (refer ticket (#87843) & (#87945)).
Hence the request is to have an enhancement to be able to auto schedule this report at a specified time at a specified frequency.
Please help us by adding this feature to the Zuora interface.
Want to be able to close the current accounting period and run a trial balance on the closed accounting period at the start of the new accounting period.
For example: the on June 1st 12:01am the accounting period for May will be closed and the trial balance for May will be run.
This way finance teams will not have to wait on the trial balance being calculated at the crucial month end period.
Support NetSuite Revenue Recognition Templates for Zuora Discount Charge Models
Currently, Zuora does not provide the option to set up a revenue recognition rule that allows for the use of the model "Monthly Recognition over time" to recognize one-time charges over the life of a subscription. The only option that enables the proper revenue recognition of one-time charges over the life of a subscription is to use of the "Daily Recognition over time" model. This model does not allow for a smoothed revenue option. I have spoken with other Zuora users & all are in agreement that this is a critical option that is missing. In order to achieve the desired revenue recognition model, we are spending countless hours redistributing revenue each month, negating the purpose of the productivity tool that we had expected from the software. I strongly urge you to consider updating your "Monthly Recognition over time" to include the option to set the Recognition Term End Date to Subscription End Date.
Feature Request: Make additional Account and Invoice fields available on the AR Aging Datasource
Reference Number: DE7928
1. Provides additional reporting information regarding account and invoice data
2. Current design requires that two reports be run then combined to pull relevant account data (such as credit balance)
3. Multiple reports required to create a detailed AR aging at the invoice level
In Europe, VAT is reported into separate GL accounts for each country and sometimes product type.
Zuora is limited to assigning a single accounting code for all VAT.
Ability to assign multiple accounting codes for VAT tax‰Û¡ÌÝÌÏ
Ability to assign accounting codes at Tax Rate level.
Currently the invoice API only allows the transferred to accounting field to be set to Yes, Ignore, Error, or Processing.
We need the limitation to be removed, so that we can also set the field back to No.
Once this is removed, we will be better able to reprocess records in case of failure.
Ability to run a report that calculates monthly catch up revenue for our use in analyzing fluctuations in revenue and to track any late subscription renewals.
For example, let's say a client is up for renewal on 1 Feb, but we don't come to an agreement until April. Because we already closed the books on Q1 revenue, we have to account for "catch up" of Feb/Mar for that client. Zuora's rev rec would show 3x the normal monthly recognition for that Sub.
The finance team of our organization require that the amount generated by the report "Invoice Payments Processed Successfully" less the amount generated by "Refunds Processed Successfully" should always match the Subtotal Invoices of the Trial Balance. I opened a ticket to review that topic but the answer was "PM doesn't find a need to make changes to accounting period summary or account period balances. However, we do have a Product Feedback forum where you can post your feature request"
The thing is Accounts Receivable don't make sense to our business case and we don't want it to be reflected in Trial Balance at least.
Feature Request: Rev Rec fields not available in the RatePlanCharge object
Reference Number: DE7633
The RevRecCode and RevRecTrigger fields are not available in the RatePlanCharge object in the API. These fields are available in the ProductRatePlanCharge and the InvoiceItem objects. -- This prevents any changes from being made to the Rev Rec values through the API.
1 Summary of the enhancement?
Allow rate calculation for volume based rate plans to be based on the aggregate of the quantities of all child accounts.
2. What is the business problem?
We use volume based recurring pricing models.
Our enterprise customers want to aggregate the total quantity subscribed to across the enterprise in order to calculate the appropriate volume pricing level, but have separate charges for each department.
e.g. if we have volume pricing levels for up to 100 widgets at $10 per widget;
100 to 200 widgets at $7 per widget for all widgets.
If company has department A with 50 widgets, department B with 90 widgets, they want to receive an invoice with all quantities priced at $7 per widget (which would be the recurring price if departments A and B's volume was combined), but separate line items for department A ($7 x 50) and department B ($7 x 90).
What is the business impact?
Without this ability, we have to bill such clients outside of Zuora. Which leads to manual work on our side, and of course removes our biggest customers from being billed through Zuora, which impacts the use of the Zuora reports, etc (and of course reduces Zuora's revenue based on our billing)
What is the proposed solution?
For child accounts, when defining a subscription, allow the selection of a subscription from the parent account. Quantity is reported in the child accounts, but the billing quantity is aggregated for all child accounts sharing the same subscription; the appropriate rate calculated; and the apportioned amount applied to the child account subscriptions. (The child account could be an informational invoice, of zero dollar, to avoid double billing.)
Feature Request: ability to cancel 'out of term' subscriptions from locked accounting periods that do not initiate any invoices or impact any financial data.
Reference Number: DE10714
Business Need: cannot manage accounts that should be closed because the subscription cannot be cancelled.
My bussiness has generates a high volume of invoices each month. $0 invoices due to usage is causing lots of noised for reconciliatin between the two systems. I would like the an option to supress $0 invoices posting to Netsuite.