About irachamreddy

irachamreddy · ‎04-17-2017

@Jyoti_Sinha You are correct. The issue is because of muti currency. How do I disable other currencies apart from USD? Thank You!

irachamreddy · ‎04-14-2017

It will be great if we can show in the invoice what are the product features offered to the customer. At present we don't have the ability to add product features to the default invoice template and ' New Subscription Created' default email template as well. As part of our requirement, we need to show product features in the invoice and email as well. But we are unable to achieve this. Email template is being with simple plain text. It will be great if we can add some images/ colors to the background.

irachamreddy · ‎04-13-2017

@Emmanuel Thank you! How do I query for it when I consider it as a single text? Meaning, Product-1: Make = "BMW,Lexus.Volkswagen,Ford,KIA" Product-2="BMW,Ford,Hyundai,Honda" I may want to find all the products that are applicable to BMW and Ford. In general, using SQL we can write a query like "select * from products where Make like '%BMW%Ford%' ". Q1. what is the best way to achieve this type of scenario's in Zuora? I think only leading or trailing % is allowed in Zuora. Q2. Using the API https://rest.apisandbox.zuora.com/v1/action/query we can retrieve the entire product catalog. Say, I want to retrieve the entire product catalog whose Make is 'BMW' or 'Ford' etc. How do I achieve this? Individually getting a product, product rate plan, rate plan charges and associated features is being a big headache. Thank You!

irachamreddy · ‎04-13-2017

@Viktor Passing one value may not help us. Dealer can create various prepaid maintenance plans in their porta which are in turn converted to products in Zuora. He may say that, a particular plan is applicable to only certain vehicle makes and models. In that scenario, we should be able to accept mutiple values to the Make and Model year fields.

irachamreddy · ‎04-13-2017

@Viktor Below is the input that I am passing to create product via API. Now, I need to pass Make as well which can have one/multiple values. I am not sure on how to pass it. { "Description":"PPM", "EffectiveEndDate":"2066-03-27", "EffectiveStartDate":"2017-03-27", "Name":"PPM", "Category": "Base Products", "AllowFeatureChanges": true, "DealerId__c": "1111" }

irachamreddy · ‎04-13-2017

@Viktor Thank you for the reply. Basically, I should be able to select mutiple values to the single field. Say, I have a custom fieldd of type Make as below. Here, I can have 1/more values assigned to 'Make'. Make = {'BMW', 'Volkswagen', 'Ford'} or BMW I have aded this field to the product. While creating the product via API, how do I pass this in the input? Regards, Indira.R

irachamreddy · ‎04-12-2017

I need to add a custom field, say Vehicle Make, to the products fields. In the front end, the field is of type muti select picklist. By creating a custom field of type Picklist, I am able to select only one option. How do achieve this? How do I send this field to the API?

irachamreddy · ‎04-12-2017

I would like to know the way to add product features to the default invoice template. I need to add the product features to the 'New Subscription Created' default email template as well.

irachamreddy · ‎04-11-2017

Is there a possiblity of knowing the taxes on product price in prior? During the customer enrollment to a specific product, we need to display the tax as well along with the product price in order summary. How can we get to know the tax price before subscribe call? Is there any API which returns me the tax price ? Sample screen is attached.

irachamreddy · ‎04-06-2017

@Jyoti_Sinha Sorry for the late reply. Price update worked :) Thank you for that. My question on RatePlanChargeTier still exists and it is confusing me a lot. I have created a Product with only one RatePlan. I have executed the following queries to get the price. Procedure-1: POST https://rest.apisandbox.zuora.com/v1/action/query ========== ProductId - {"queryString":"SELECT id from Product where name='xxxxxx'"} ProductRatePlanId - {"queryString":"SELECT id from ProductRatePlan where ProductId =' xxxxxx '"} ProductRatePlanChargeId - {"queryString":"SELECT id from ProductRatePlanCharge where ProductRatePlanId='xxxxxx'"} ProductRatePlanChargeTierId - {"queryString":"SELECT id from ProductRatePlanChargeTier where ProductRatePlanChargeId='xxxxxx'"} -- Here I have got only one Id in the response Update the price: { "type": "ProductRatePlanChargeTier", "objects": [{ "Price": 351.00, "Id":"2c92c0f95ad9c24d015addf33b090b12" }] } Procedure-2: ========== Tried to get the ProductRatePlanChargeId using Datasource by using Product name as a query filter. I am attaching the export result file here. Wonder why I have 5 rows. Product Rate Plan Charge Tier: ID Product Rate Plan Charge Tier: Price Product Rate Plan Charge Tier: Starting Unit Product Rate Plan Charge Tier: Tier Product: ID Product: Name Product Rate Plan: ID Product Rate Plan: Name Product Rate Plan Charge: Bill Cycle Day Product Rate Plan Charge: Bill Cycle Type Product Rate Plan Charge: Billing Period Product Rate Plan Charge: Billing Period Alignment Product Rate Plan Charge: Billing Timing Product Rate Plan Charge: Charge Model Product Rate Plan Charge: Charge Type Product Rate Plan Charge: ID Product Rate Plan Charge: List Price Base Product Rate Plan Charge: Name Product Rate Plan Charge: Number Of Period Product Rate Plan Charge: Revenue Recognition Trigger Product Rate Plan Charge: Tax Code Product Rate Plan Charge: Tax Mode Product Rate Plan Charge: Taxable Product Rate Plan Charge: Trigger Event 2c92c0f85b4237e6015b441427d250af 270 1 2c92c0f95b424512015b4411c1c24812 KIA Care Plus 2c92c0f85b4237e6015b4412762a4a7f Annual Plan subscription start day Two Years Align to Subscription Start In Advance Per Unit Pricing Recurring 2c92c0f85b4237e6015b441427d150ae Billing Period 2 Year Charge Z-Tax Code Tax Exclusive TRUE Upon Service Activation 2c92c0f85b4237e6015b441427d250b0 0 1 2c92c0f95b424512015b4411c1c24812 KIA Care Plus 2c92c0f85b4237e6015b4412762a4a7f Annual Plan subscription start day Two Years Align to Subscription Start In Advance Per Unit Pricing Recurring 2c92c0f85b4237e6015b441427d150ae Billing Period 2 Year Charge Z-Tax Code Tax Exclusive TRUE Upon Service Activation 2c92c0f85b4237e6015b441427d250b1 0 1 2c92c0f95b424512015b4411c1c24812 KIA Care Plus 2c92c0f85b4237e6015b4412762a4a7f Annual Plan subscription start day Two Years Align to Subscription Start In Advance Per Unit Pricing Recurring 2c92c0f85b4237e6015b441427d150ae Billing Period 2 Year Charge Z-Tax Code Tax Exclusive TRUE Upon Service Activation 2c92c0f85b4237e6015b441427d250b2 0 1 2c92c0f95b424512015b4411c1c24812 KIA Care Plus 2c92c0f85b4237e6015b4412762a4a7f Annual Plan subscription start day Two Years Align to Subscription Start In Advance Per Unit Pricing Recurring 2c92c0f85b4237e6015b441427d150ae Billing Period 2 Year Charge Z-Tax Code Tax Exclusive TRUE Upon Service Activation 2c92c0f85b4237e6015b441427d250b3 0 1 2c92c0f95b424512015b4411c1c24812 KIA Care Plus 2c92c0f85b4237e6015b4412762a4a7f Annual Plan subscription start day Two Years Align to Subscription Start In Advance Per Unit Pricing Recurring 2c92c0f85b4237e6015b441427d150ae Billing Period 2 Year Charge Z-Tax Code Tax Exclusive TRUE Upon Service Activation

irachamreddy · ‎03-27-2017

Thank You @bolaurent How do I use this in my code?

irachamreddy · ‎03-26-2017

I am using https://rest.apisandbox.zuora.com/v1/action/subscribe API to create account and for subscription. I set the "InvoiceDeliveryPrefsEmail" to true. Invoices are not getting emailed to the customers automatically. May I know if there is any configuration in order to make the invoice to be delivered automatically after the API execution? Thank You!

irachamreddy · ‎03-26-2017

@Jyoti_Sinha I have only one RatePlan with only one recurring charge.

irachamreddy · ‎03-24-2017

@Yolanda Thank You so much. I appreciate that. Instead of exporting to a file, is there a way to get the results of the query into response directly like how we get from the API https://rest.apisandbox.zuora.com/v1/action/query Datasources are helping in a great manner to retrive the data by combing the tables but the same is not achievable through https://rest.apisandbox.zuora.com/v1/action/query as it is not supporting joins. Many a times, we need to join the tables and retrive the result. Say, to update the price of a product - we may first need to get the Id of product and based on that ProductRatePlan Id and again ProductRatePlanCharge - ProductRatePlanChargeTier. If we have some solution like datasource then we may get the result in a single query Thank You!

irachamreddy · ‎03-24-2017

@Jyoti_Sinha @Viktor To give you some more information, I just did export of RatePlanChargeTier data source based on product name. The result of the same is below, ProductRatePlanChargeTier.Id ProductRatePlanChargeTier.Price 2c92c0f95ad9c24d015addf33b090b13 0 2c92c0f95ad9c24d015addf33b090b14 0 2c92c0f95ad9c24d015addf33b090b15 0 2c92c0f95ad9c24d015addf33b090b16 0 2c92c0f95ad9c24d015addf33b090b12 399 I would like to understand why there are other columans with 0 price? Thank You!

irachamreddy · ‎03-24-2017

@Viktor Thank you! But you may ignore this as I have already got response.

irachamreddy · ‎03-24-2017

@Viktor Here is below: { "ProductRatePlanChargeId": "2c92c0f95ad9c24d015addf33b090b11", "Id": "2c92c0f95ad9c24d015addf33b090b12", "CreatedById": "2c92c0f85ab26970015ac8347f106b00", "CreatedDate": "2017-03-17T13:26:29.000-07:00", "UpdatedDate": "2017-03-24T07:26:41.000-07:00", "StartingUnit": 0, "Currency": "USD", "EndingUnit": 0, "PriceFormat": "Flat Fee", "Price": 399, "Tier": 1, "UpdatedById": "2c92c0955ab279d4015ac81e574e1908" }

irachamreddy · ‎03-23-2017

I am trying to update product price using the API https://rest.apisandbox.zuora.com/v1/action/update { "type": "ProductRatePlanChargeTier", "objects": [{ "price": 351.00, "Id":"2c92c0f95ad9c24d015addf33b090b12" }] } Price is getting updated to 0. Is there anything wrong with the approach that I am following? Thank You! Regards, Indira.R

irachamreddy · ‎03-23-2017

I would like to know the way to access various datasource from REST API. The URL, the way to pass filter criteria & the required fields selection.

irachamreddy · ‎03-23-2017

@monique Did you get a chance to look at my request?

irachamreddy · ‎03-20-2017

@monique Thank You. I could see many accounting periods (month wise until 2018) created under Finance - Accounting Periods. How does these are going to help me? During the rateplan charges create, I have mentioned to capture the revenuw under 'Subscription Revenue'. Where can I verify this? Is this the manual task everytime to distribute the revenue? Thank You!

irachamreddy · ‎03-20-2017

Hi, Using the API https://rest.zuora.com/v1 /action/subscribe I performed the following in a single call, Created an account Created contact Created CC payment method Created an invoice for the subscription Applied the first payment to a subscription If I look at the revenue schedule, the colled amount (excluding taxes) is going under 'Unrecognized Revenue'. Even in the other scenarios the same is happening. Is there any configuration to set to make the revenue to be recognized? While creating the product rate plans, I configured the following Revenue Recognition Rule: Recognize upon invoicing Recognized revenue: Subscription Revenue

irachamreddy · ‎03-18-2017

Great! Thank you for the clarification. How does it impacts the rate plan charges when we renew it? Say, I have a product with 2 different rate plan charges. 1. 'Annual' billing period with price of $150 2. 'Quarter' billing period with price of $20 Contract starts on 04/01/2017 Initial Term - 12 months Renewal Term - 6 months Auto Renew - Yes When the contract starts on 04/01/2017, we will charge customer $170. After the initial term ends, renewal will begin on 04/01/2018. How much the customer will be charged in this scenario? Thank You!

irachamreddy · ‎03-17-2017

How does the 'Renewal Term' actually works? In the scenario below, I have created annual product. What if I mention Renewal Term as 6 months?

irachamreddy · ‎03-17-2017

I am trying to do the entire subscription process using APIs. 1. I created product using https://rest.apisandbox.zuora.com/v1/object/product 2. Added rate plan to it using https://rest.apisandbox.zuora.com/v1/object/product-rate-plan Now, I am unable to find APIs 1. To add charges to the rate plan 2. To add product features to the product 3. To create new product feature. I am seeing the APIs only for retrieve and delete. I am able to create new feature from UI 4. To run bill to a single customer account I am referring to the link https://www.zuora.com/developer/api-reference/ How do I get the Id of account/product object? Each time do I need to retrieve entire accounts / product catalogs and get the id by looping through the result? Is it not possible to get the id by name? How do I get to know the list of all APIs and acceptable all input parameters for each of it? Thank You, Indira.R

irachamreddy · ‎03-16-2017

I would like to know the better usage of the following fields, 1. Initial term 2. Renewal Setting 3. Renewal Term 4. Auto Renew My requirement is: 1. Annual Product with 1 year subscription and ends after that 2. Annual Product with for ever subscription 3. Annual Product with 1 year subscription - should be renewed for next 2 years which means 2 times renewal While creating the product - Rate Plans - Rate Plan Charges (Recurring Charges / Period), I have given the following values List Price - 150 USD / Billing Period Trigger Condition - Upon Service Activation End Date - Align to Subscription End Date Billing Period - Annual Billing Time - In Advance Billing Day - Subscription Start Day Billing Period Alignment - Align to Subscription Start Now, while adding the subscription to account I have given the following values 1. Whose subscription should end after 1 year Initial term - 1 Year Renewal Setting - Renewal with specific term Renewal Term - 1 year Auto Renew - No 2. Subscription for ever Initial term - 1 Year Renewal Setting - Renew To Evergreen Auto Renew - Yes 3. Subscription for renewal Initial term - 1 Year Renewal Setting - Renewal with specific term Renewal Term - 3 years Auto Renew - Yes Are my configurations correct? How the renewal term actually works? What is the configuration that I need to set to automatically charge the customer during his renewal?

irachamreddy · ‎03-14-2017

Hi, I am new to Zuora billing system and we will be using it for our subscription marketing. I have experience in other billing systems like Oracle I am in the process of exploring Zuora system and I did the following so far, 1. Created test account in https://apisandbox.zuora.com. Here I could create new account, add subscription, run the bill and generate the invoice. 2. I installed cURL in windows and by using the same I invoked REST API calls. I tried sample exercises like querying for a product, creating customer account, subscription, upgrading a subscription and canceling a subscription. Now, how do I go ahead with the actual development? I found some code base in different languages Java, C# and PHP. How do I setup the environment? Install the database? Start with the actual implementation? How do I view the datamodel in the database? Thank You!

Happy Business Starts Here