The merge field Invoice.CreditMemoAmount can be used on invoices to show the total amount of the credit memos that are applied to the invoice. However, this field is only available to Invoice Settlement users. ... View more

Solved it in the meantime. We use Camel in our backend API and although we sent request in the JSON format, I had to explicitly specify to use the UTF-8 format in the main Camel route to Zuora: .setHeader( CONTENT_TYPE , constant( MediaType . APPLICATION_JSON_UTF8_VALUE )) This fixed our bug. ... View more

Yes I have the same use case as Madalina. If we did not bill usage say for a year or two year we get a long list of zeros for all those period with no usage record from the last invoice with usage. ... View more

SB Payment Service (元 SoftBank Payment Service) にも接続されました https://knowledgecenter.zuora.com/CB_Billing/M_Payment_Gateways/Supported_Payment_Gateways/SoftBank_Payment_Gateway   ... View more

@yamasaki1ma ご購入有難うございます！ ... View more

In Zuora Release 230 (R230), the font "Source Han Serif K" is now newly available. So, I updated this post.   "K" of "Source Han Serif K" means Korean. However, Source Han Serif K's font set includes Japanese. I think "Source Han Serif K Regular" is very nice  ... View more

Hi @stefanomurino   In conclusion, adding "invoiceCollect": false to the request body may be able to prevent errors. That is, change it like this: { "accountKey": "A00000030", "autoRenew": true, "contractEffectiveDate": "2018-07-10", "initialTerm": "12", "initialTermPeriodType": "Week", "invoiceCollect": false, "notes": "Test POST subscription from z-ruby-sdk", "renewalTerm": "3", "renewalTermPeriodType": "Week", "subscribeToRatePlans": [ { "chargeOverrides": [ { "billCycleDay": "5", "billCycleType": "SpecificDayofMonth", "billingPeriodAlignment": "AlignToCharge", "billingTiming": "IN_ARREARS", "description": "This is rate plan charge description", "number": "TestCharge", "price": 12.01, "productRatePlanChargeId": "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX", "triggerDate": "2018-07-10", "triggerEvent": "EUR" } ], "productRatePlanId": "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX" } ], "termType": "TERMED" }   If "AR Settlement" is enabled, something restrictions apply when creating Payment. (Sorry, I do not know the concrete contents about this "restrictions")   By default, the Create Subscription call has the invoiceCollect field set to true. In this case, when you call this API, Zuora creates Invoice and Payment at the same time. If invoiceCollect is set to false, Payment will not be created.   I can not verify this because my tenant has not enabled the "AR Settlement" function. Please tell us the results you tried.   Note: Recently, the "AR Settlement" function was renamed as "Invoice Settlement". https://knowledgecenter.zuora.com/AA_Whats_New/R_Previous_Releases/23_2018_New_Features/L_Release_Notes_for_Zuora_Release_228%2C_July_2018 ... View more

Hi @prayos   You are asking three questions. I will reply to them in order.   Note: I show you how to use the Data Source function of the UI instead of using the API. If you want to query these via the API, you will be using Export ZOQL. To learn how to execute Export ZOQL via the API please refer to the following link: https://knowledgecenter.zuora.com/DC_Developers/M_Export_ZOQL 1. How to find Payment related to Refund In order to find a Payment related to Refund object, you need to search the RefundInvoicePayment object. When you create Refund for Payment, Zuora creates RefundInvoicePayment at the same time. https://knowledgecenter.zuora.com/DC_Developers/G_SOAP_API/E1_SOAP_API_Object_Reference/Refund#Non-Referenced_Refunds > A RefundInvoicePayment object is created when you create a Refund object. This object ties the Refund object to the associated InvoicePayment object.   You can know RefundId and PaymentId by setting RefundInvoicePayment object as base. Select "Refund Invoice Payment" as Data Source: Select Payment.Id and Refund.Id. CSV:   Note: There is a constraint that the PaymentId field of the Refund object can not be queried directly. It can be confirmed since there is no "Query" string here. https://knowledgecenter.zuora.com/DC_Developers/G_SOAP_API/E1_SOAP_API_Object_Reference/Refund     2. How to find Refund for Credit Balance Refund object has a SourceType field. This field contains the string "Payment" or "CreditBalance". https://knowledgecenter.zuora.com/DC_Developers/G_SOAP_API/E1_SOAP_API_Object_Reference/Refund > SourceType > Specifies whether the refund is a refund payment or a credit balance.   So, in order to find Refund for Credit Balance, execute Data Source function under the following conditions:   Note: If Refund is created for CreditBalance, no RefundInvoicePayment object is created.   3. PaymentId was removed from Refund I think, PaymentId has not been removed from Refund.   If such action is taken, it will be listed in API Changelog. https://community.zuora.com/t5/Developers/API-Changelog/gpm-p/18092   Also, you can check the fields of the object using the describe call. https://www.zuora.com/developer/api-reference/#tag/Describe I confirmed the field of Refund object. It has PaymentId field. ... View more

Hi @kcavanaugh, @Yolanda   > we can just type in 'All Account Contacts' to that cc field? There is 'All Account Contacts' as picklist option of CC fileds of Email Template.   By the way, I think that this issue has already solved. I tested it under the following conditions. As a result, e-mail arrived at All Contact email addresses. - Account has 3 Contacts: "Bill To", "Sold To", other one.   - All Contacts have different Work Email from each other. - Invoice Posted Email Template:   - "To Email": "All Account Contacts"   - "CC Email": "Bill To Contact" ... That is, I am not using Workaround. - and, Click "email invoice" button on Invoice detail page.   - Check the box "Use Email Template Setting" ... View more

Hi @nickpriest   The endpoint (catalog/product/{product-id}) found by @kazuki   is also discussed in Idea below. Let's Vote! https://community.zuora.com/t5/Subscriptions-Ideas/Make-the-product-catalog-API-official-v1-catalog-product-id/idc-p/23498 ... View more

I hope this end point will be public! With "Get product catalog" it is possible to get Product/Plan/Charge/Tier with a single call. However, this call takes time if the number of Product is large. It is useful if we can only acquire specific Product's Plan/Charge/Tier. ... View more

Add Tips:   Check the Amendment Type on the Subscription page In the Version field of the Subscription page, the links to Amendment that has been applied are displayed. You can see Amendment's Type and Contract Effective Date by putting mouse cursor on these links. This is useful when you want to track a specific Amendment but a lot of Amendments are applied to one Subscription.   Track Bill Run from Invoice Tracking Invoice from Bill Run is easy. This is because the links to Invoice are displayed on the Bill Run page. Sometimes we want to track from Invoice to Bill Run. That way is written in this Post: https://community.zuora.com/t5/Billing-Payments/how-to-identify-which-Bill-Run-generated-a-specific-invoice/m-p/21332 ... View more

Hi @zhengye1!   I think that Suspend is not available in your Tenant. How to check whether Suspend is available on your Tenant: Log in to the Sandbox UI. Go to Subscription page. Click "more" in the upper right and check whether there is a link "Suspend".   If you can not see this link on your Tenant:   Suspend (and Resume) is one of the functions called Limited Availability (LA). https://knowledgecenter.zuora.com/DC_Developers/G_SOAP_API/E1_SOAP_API_Object_Reference/Amendment > - Suspend a subscription (This feature is in Limited Availability.) > - Resume a subscription (This feature is in Limited Availability.)   LA is deactivated by default. In order to activate LA, you need to ask Global Suppot. ... View more

Hi @sapatel!   Yes, ZOQL is also supported in REST API. It can be executed like SOAP's query method.   Information on the REST API is summarized in the Developer Center. The Developer Center's API Reference is the main instructions. The "Query" section in this will be useful for you.   If you are going to try the REST API, a tool called "Postman" is recommended. If you have never used Postman, you should watch the following wonderful video: https://community.zuora.com/t5/SME-Sessions/Best-Practice-API-How-to-Use-Postman/gpm-p/22031   An example of using the REST API to get the IDs of all Subscriptions is as follows:   We can write ZOQL as value of the "queryString" in the request body. ZOQL grammar is exactly the same in both SOAP and REST. ... View more

Hi @lisaluque!   The simplest solution is to remove "Amendment.Type is not equal to 'Remove a Product'" from the filter. This allows you to pick up RatePlan that has just been migrated and has not yet been amended.   But I guess what you want to do is as follows: You want to pick up RatePlan which has not been amended before. If RatePlan has been Amended, you only want to pick up RatePlan other than "Remove a Product". If so, you should create a filter like this:   I referred to the following link: https://community.zuora.com/t5/Billing-Payments/How-to-find-all-latest-charges-of-active-subscriptions/m-p/14736/highlight/true#M818 ... View more

Hi @lisaluque!   > We are wanting to run a report which pulls in all billing adjustments with a certain description. Which data source and filters would you recommend? In Zuora, the Invoice Item Adjustment (IIA) Object plays the role of "billing adjustments". IIA is created to lower the price of already posted Invoice. In order to pull IIA Object (and Joined Objects), you should use Invoice Item Adjustment Data Source.   However, an IIA Object does not have a "Description" field. Instead, the IIA Object has a "ReasonCode" field:   You can not write a free memo in the "ReasonCode" field, but you can create a pull-down choice from Payment Setting. Username > Payments > Configure Reason Codes   For example, to pull IIA where ReasonCode is "Incorrect Charge" you should create a report like this:   ----   > If I do a data sources export I have one result return. If I try to create a report using the rate plan data source and the same fields and filters there are no results found. Please tell me which fields and what kind of filters you tried to pull. ... View more

Thanks yamasaki1ma, that was an error! But there was a bigger error which I have figured out. I was encoding the query as JSON but using normal parameters otherwise. It seems nessesary to encode the entire request as JSON. So, this seems to work:   var reqJson = new {   format = "csv",   version = "1.0",   queries = new object[] {     new {     name = theName,     query = theQuery,     type = "zoqlexport"   } } }; request.RequestFormat = DataFormat.Json; request.AddBody(reqJson); var response = client.Execute(request); ... View more

Hi @Bharath!   Direct answers are listed on the following links: https://knowledgecenter.zuora.com/BB_Introducing_Z_Business/Policies/Concurrent_Request_Limits#Limitation_on_Invoice_PDF   > When generating an invoice PDF, if the maximum number is exceeded, an error message is generated. This is consistent with Zuora hanging when you hit the View Pdf button.   Considering your use case, the number of Subscription lines (not the number of InvoiceItem lines) may be the cause of hanging. ... View more

Oh wow...even I didn't know this, haha!  Thanks for that tip @yamasaki1ma.  It'll make it easier for me to check up on all of you 8-) ... View more

@julesamos Even though Zuora doesn't support this functionality now, you should put your use case in the Idea section for Subscriptions.  SUBSCRIPTIONS IDEAS  Other members might have a similar business use cases and with enough votes, Zuora could consider implementing the idea.   I like the idea.  I'm fairly certain we would take advantage of the functionality. ... View more

Hello!   Actually, I was ok on the 6th... and why we have 6 in these 4 scenarios.   My question is really, why do we bill till the 5th of *MAY* in these scenarios? Why MAY? It's 2 months after worth of billing... why 2 months???   Remains a mystery to me...   -e ... View more

Hello Thank you,   Sorry i didn't get back to you earlier. The subject was deprioritized at the time by the business, and just came back in scope.   I have tested and added some modifications: Conditional display of the service period for recurring charges only and not one time The problem is that i only need the : Amount column The subtotal but WITHOUT TAX Total without TAX . In my country the Tax is usually calculated at the end  only. Is there a merge fied allowing to have these informations please?   Thank you. ... View more