About Goutham

Goutham

Solution As part of the Order Metrics migration, a new Amendment Type of "Composite" will appear in the Subscription to represent the Subscription creation. The below ZOQL query will fetch the Account and Amendment type detail "select SubscriptionVersionAmendment.type, SubscriptionVersionAmendment.ID, SubscriptionVersionAmendment.code, Account.AccountNumber from Subscription" Where the SubscriptionVersionAmendment.type provides the cancellation/composite type for an amendment.

Goutham

Problem Using the ZOQL Export API to get a list of recent amendments, and also the account they are associated with. However, for cancellation and composite amendments, I cannot get the account Id/name, or subscription id/name. Is there any way to get the account information from a cancellation/composite amendment, via ZOQL?

Goutham

Solution It is observed in this request that Tenant time zone is set as Pacific(PST) and the workflow is scheduled to execute daily at 11 PM EST. due to the time zone difference the effective date is set as previous date during the task execution User was suggested to use the below modified liquid code set for the effective date and it worked {{ "now" | date: "%Y-%m-%d %H:%M:%S %Z" | timezone: "%Y-%m-%d %H:%M:%S %Z", "%Y-%m-%d %H:%M:%S %Z", "Pacific Time (US & Canada)" | date: "%Y-%m-%d"}}

Goutham

Problem Customer built a workflow to add a credit card fee, as part of which a debit memo is created and an electronic payment is created. This workflow is scheduled to execute daily at 11 PM EST. We have observed an issue with setting effectiveDate in CreatePayment call to Data.Workflow.ExecutionDate. Hence it was updated to "2019-01-30 11:11 UTC". But, when the workflow execution gets delayed due to some issue the effective date remains same as previous day due to which the Create Payment API fails with error: "message" : "For electronic payment, effective date should be today's date or the payment should fail."

Goutham

We observe difference in custom field column name behaviour between AQUA and ZOQL as mentioned in the example below Example Describe call - /apps/api/describe/subscription <name>AutoRenew__c</name> <label>Auto Renew 1</label> please find the test results below Test Query - SELECT AutoRenew, AutoRenew__c, Account.Id, BillToContact.Id, DefaultPaymentMethod.Id, ParentAccount.Id, SoldToContact.Id, SubscriptionVersionAmendment.Id FROM Subscription ZOQL Response AQUA Response ZOQL export returns the column name directly from the describe call <name> Whereas both Stateful and Stateless AQUA mode returns the column name available in <label> Note: If the report is exported through Data source it will return the column name available in <label>

Goutham

User created custom field Auto Renew with API name AutoRenew__c, Since we already have a standard field Auto Renew in subscription AQUA results has Duplicate column names Question: Why the AQUA report is not displaying columns with API name while Zoql report does

Goutham · ‎02-09-2019

Solution What you have observed is by design, because there are two types of Profiles in Zuora, one is Default profile and the other is new communication profile which is especially for the end users. The Bill Run, Payment Run, Data Source Exports and Import notifications are present in default profile and once activated, it will send notifications to Zuora users within the organization. The new communication profile is customizable, they are designed for your end customers meaning it can be configured at Customer Account level and are intended to be sent to your end customers. This is the reason why new Communication Profile will not inherit all the notifications/emails available in the default profile. https://knowledgecenter.zuora.com/CF_Users_and_Administrators/Notifications/B_Viewing_Profiles

Goutham · ‎02-09-2019

Problem After creating new Communication Profiles, I noticed that some OOTB callouts/notifications are missing when editing the newly created Comm Profiles. The callout/notifications that I am specifically missing is "Payment Run Completion | Completed Status". This notification cannot be added through the UI since it is not in the Related Event list. Default Profile: New communication Profile:

Goutham · ‎02-09-2019

Solution: Currently Source and SourceID available via SOAP query, but not available under REST API call. Also, we can obtain the Source field through export, in the Knowledge center article fields mentioned as This field is in controlled release and they can be generated through Data source export. Reference (https://knowledgecenter.zuora.com/DC_Developers/G_SOAP_API/E1_SOAP_API_Object_Reference/Invoice)

Goutham · ‎02-09-2019

Issue: User not able to get the field 'Source' during a REST API call in Invoice, please find the query below, https://rest.zuora.com/v1/action/query { "queryString" : "SELECT ID,Source,Status FROM Invoice where ID = '2c92a0076390d4590163978cdc5a6d29'" } The response only shows ID and Status but not source { "records": [ { "Status": "Posted", "Id": "2c92a0076390d4590163978cdc5a6d29" } ], "size": 1, "done": true

Happy Business Starts Here

Vision

Products

Zuora Central Platform

Products

Connect Marketplace

Solutions

By Industry

By Role

Customers

Resources

Resources

Subscribed

Support

About

Re: Get the account information for composite amen...

Get the account information for composite amendmen...

Re: Workflow- For electronic payment, effective da...

Workflow- For electronic payment, effective date s...

Re: AQUA and ZOQL returns different column names

AQUA and ZOQL returns different column names

Re: New Communication Profile Limitations

New Communication Profile Limitations

Re: Source field not available in the Invoice Reco...

Source field not available in the Invoice Record f...