Versions Compared

Old Version 28

changes.mady.by.user Trevor Vogt

Saved on

compared with

New Version Current

changes.mady.by.user Trevor Vogt

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This page explains the different steps to configure a new Zuora tenant.This page explains the different steps to configure a new Zuora tenant.

Hotel-Spider has 4 tenants:

3 Production tenants:

Tourisoft Sàrl (CH) - 5896

Hotel-Spider Germany GmbH (DE) - 3000206

Hotel-Spider India (IN) - 3000227

3 SANDBOX tenants:

Tourisoft Sàrl (CH) SANDBOX - 13635

Tourisoft GmbH (DE) SANDBOX - 2000392

Hotel-Spider India (IN) - Not configured yet

General information

Zuora has 2 datacenters : 

...

Hotel-Spider CH is hosted in the US Datacenter

Hotel-Spider DE is hosted in the EU Datacenter

Hotel-Spider IN is hosted in the EU Datacenter

...

Tenantbase endpointExtranet
US Productionhttps://rest.zuora.comhttps://www.zuora.com/
US API Sandboxhttps://rest.apisandbox.zuora.comhttps://apisandbox.zuora.com
EU Productionhttps://rest.eu.zuora.comhttps://eu.zuora.com
EU Sandboxhttps://rest.sandbox.eu.zuora.comhttps://sandbox.eu.zuora.com

...

Description
Field LabelAPI NameData TypeRequiredDefault valuePossible valuesRequiredDefault valuePossible valuesDescription
is_viewableis_viewable__cPicklistYES1

1

0

Define if a product can be seen in the V4
max_ratesmax_rates__cPicklistYES1515
100
1000
-1

Max number of V4 rateplans the product allows to have

-1 means it does not apply to this product

max_roomsmax_rooms__cPicklistYES1515
100
1000
-1

Max number of V4 rooms the product allows to have

-1 means it does not apply to this product 

max_productsmax_products__cPicklistYES1515
100
1000
-1

Max number of v4 sellable products the product allows to have

-1 means it does not apply to this product

SortOrderSortOrder__cPicklistYES00
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40		Sort order of the product, for display purpose

...

Field LabelAPI NameData TypeRequiredDefault valuePossible valuesDescription
obj_idobj_id__cText (25)NO

ID of the object for which this rateplan is available

This fields is not used currently

obj_id_classobj_id_class__cPicklistYEShotelwhitelabel

whitelabel

hotel
affiliation

Define the type of V4 object that can see this rateplan

...

Field LabelAPI NameData TypeRequiredDefault valuePossible valuesDescription
bookingChannelIdbookingChannelId__ctext (5)NO

Default booking channel ID applicable for Rate Plan. Used for CRS.
product_typeproduct_type__cText (25)YESFirst valuecrs,pms

airbnb

administrative

callback

channelmanager

spiderbooking

channelmanager,spiderbooking4

crs

crs,pms

wbe

channelmanager,pms

channelmanager,crs

discount

duplicatechannel

fax

gateway

meta

pms

rms

setup

sms

fax

spiderbooking

discount

spiderbooking4

duplicatechannel

wbe

Declare the type of rateplan. This is used for the limitations

SortOrderSortOrder__cPicklist
00
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40		Sort order of the product, for display purpose
isviewableisviewable__cPicklistYES10
1		Define if a rateplan can be seen in the V4
MandatoryMandatory__cPicklistYES00
1

Define if the rateplan is mandatory for a product

This is currently not used

LabelLabel__cPicklistYESFirst valueAdministration
V4Connectivity
Communication
Discount
Commission
Test

For display purpose,

Declare what kind of rateplan this is

IncludedCountriesIncludedCountries__cText (255)YES{"Continent": "ALL"}

JSON that determine which countries can see this rateplan

This is based on the list of Continent, SubContinent and Countries in the V4 database

ExcludedCountriesExcludedCountries__cText (255)YES{}

JSON that determine which countries can not see this rateplan

This is based on the list of Continent, SubContinent and Countries in the V4 database

...

Billing period

Billing Rules

Set your company's Billing Policies.


Enable credit back for removing or canceling one time charges?
Yes
Bill recurring charges for partial month (with monthly based billing periods)?
NoYes
Bill recurring charges for partial week (with weekly based billing periods)?
NoYes
Bill usage charges for partial month (with monthly based billing periods)?
NoYes
Bill usage charges for partial week (with weekly based billing periods)?
NoYes
When prorating a month, assume 30 days in a month or use actual days?
Use actual number of days
When prorating periods greater than a month, prorate by month first, or by day?
Prorate by month first
Support bill run auto-post?
Yes
Default bill run to auto-post?
No
Include invoices with negative totals in the Account Balance (included associated Debit Memos)?
Yes
Include usage from child accounts when billing?
No
How should errors be handled when generating multiple invoices for a single account via bill run?
Terminate processing of all invoices
Preserve snapshot of bill-to and sold-to contacts when billing documents are posted?
No
Invoice Past End-of-Term when Auto-Renew is OFF?
Yes: deprecatedNo
Invoice Past End-of-Term when Auto-Renew is ON?
Yes: deprecatedNo
Calculate taxes using information from Customer Account of:
Invoice owner
Zuora Tax rounding rule for inclusive tax calculation
Round net amount
When service period of an invoice item crosses multiple tax rate period, it will generate:
Multiple Tax Items


...

Enable Charge Types / Models

Enable Charge Types

Use the checkbox below to indicate if your organization uses usage-based charges in its pricing



Select
Name
YES
Usage-Based Pricing


Enable Charge Models

Use the checkboxes below to indicate the charge models that your organization uses in its pricing



Select
Name
YES
Flat Fee Pricing
YES
Per Unit Pricing
YES
Overage Pricing
YES
Volume Pricing
YES
Tiered Pricing
YES
Tiered with Overage Pricing
YES
Discount-Fixed Amount
YES
Discount-Percentage


Manage Billing Document Configuration

Manage Invoice Rules and Templates

Go to Settings > Billing > Manage Invoice Rules and Templates

The templates are setup in the following way:

  1. Per tenant (different template for Sàrl vs. GmbH)
  2. template for Hotels
  3. template for Whitelabels
  4. Per language:
    1. Sàrl:
      1. EN (default)
      2. DE
      3. ES
      4. FR
      5. NL
    2. GmbH:
      1. DE

To modify a template, click on the template name to download the existing word file (make sure to save a copy of the original and save the modified version under the latest version number, i.e. _v6). A folder with all templates exists under C:\Tourisoft\Accounting and Finance - General\Zuora. Make sure to save latest modifications there as backup.

Add the corresponding templates by clicking on "edit", select the template and save it. Use the preview function with existing customer data (to reflect reality) to make sure the latest modifications do not return errors.

The templates IDs will then need to be extracted from this page. Click on show ID:

Refer to the database section to store the template IDs in the v4.

Invoice prefix & Numbering

Go to Settings > Billing > Prefix & Numbering

Tourisoft Sàrl: INV

Tourisoft GmbH: RE

...

As per request of certain customers, net0 has been added (upon receipt)

Setup Taxation Code

https://knowledgecenter.zuora.com/CB_Billing/J_Billing_Operations/L_Taxes/A_Z-Tax/C_Load_Tax_Rates

use the import file (CSV) TaxRates_Import_File.csv

...

  • German VAT (19%) - insert 0.19 in column G under Germany

Tourisoft India Private Limited

  • Haryana State (where Legal entity is located) - 9% CGST + 9% SGST
  • Rest of states 18% GST


Payment Settings

Customize Payment Methods

...


ActiveNameAccounting Code



ACH


Cash


Check

Credit Card


PayPal


Wire Transfer


Debit Card


CC Reference Transaction

Bank Transfer


Other


Accounting Codes for Payments and Refunds can be configured inFinance Settings: Configure Accounting Codes.


Payment Gateways

Tourisoft Sàrl:

Name
Gateway
Active
Actions
Adyen Gateway
Adyen
Image Modified
[Edit] Default
My Hateway   Image Modified
Test Gateway
Image Modified
AdyenCHF
Adyen
Image Modified

At Adyen, specific API user accounts must be created and connected with to Zuora (to create Adyen doc)

...

Configure Aging Balance Settings

Bucket
Name
From (days past due)
To (days past due)

1




2




3




4




5



Configure Accounting Codes

...

Configure Accounting Rules

Accounting Rules


Image Modified
Allow blank Accounting Codes

Image Modified
Allow Subscription and Amendments to be created in a closed Accounting Period

Image Modified
Allow Usage to be created in a closed Accounting Period

Image Modified
Allow Revenue Schedules to have negative amounts in the Open-Ended Accounting Period


Setup Profiles, Notifications and Email Templates

...

Configure Revenue Event Types


Label
System ID
Active
Actions
Accounting Period(s) Created
AccountingPeriodsCreated__z
Image Modified
[Edit]   
Invoice Cancelled
InvoiceCancelled__z
Image Modified
[Edit]   
Invoice Item Adjustment Cancelled
InvoiceItemAdjustmentCancelled__z
Image Modified
[Edit]   
Invoice Item Adjustment Created
InvoiceItemAdjustmentCreated__z
Image Modified
[Edit]   
Invoice Posted
InvoicePosted__z
Image Modified
[Edit]   
Revenue Distributed
RevenueDistributed__z
Image Modified
[Edit]   


Manage Revenue Recognition Rules

Revenue Recognition Rule
Recognition Model
Active
Actions
Monthly recognition over time
Billing - Monthly recognition over time
Image Modified
[Edit]   [Deactivate]
Recognize upon invoicing
Billing - Full recognition upon invoicing
Image Modified
[Edit]   [Deactivate]

To be elaborated as we connect to potential ERPs?

Configure Segments

Segments


Object
Field
Segment Name
System ID
Actions
Account
Market__c
Account Market
AccountMarket__s
[Edit]   [Remove]


Additional Configurations


Image Modified
Discount segment value
Image Modified
Invoice owner segment value
Image Modified
Revenue owner segment value

Configure GL Segmentation Rules

by default AccountMarketSegment

to be furhter developped

Manage Chart of Accounts

Accounting Code Name
Accounting Code Type
Active
Actions
Accounts Receivable
Assets: Accounts Receivable
Image Modified
Bank
Assets: Cash
Image Modified
Cash
Assets: Cash
Image Modified
Credit Card
Assets: Cash
Image Modified
Customer Cash on Account
Liabilities: Customer Cash on Account
Image Modified
Deferred Revenue
Liabilities: Deferred Revenue
Image Modified
Sales Tax Payable
Liabilities: Sales Tax Payable
Image Modified
Callback Authentication Revenue
Revenue: Sales Revenue
Image Modified
Central Reservation System Revenue
Revenue: Sales Revenue
Image Modified
Direct Subscription Revenue
Revenue: Sales Revenue
Image Modified
Discounts
Revenue: Sales Discounts
Image Modified
FAX Notification Revenue
Revenue: Sales Revenue
Image Modified
Negotiated Contracts Revenues
Revenue: Sales Revenue
Image Modified
SMS Authentication Revenue
Revenue: Sales Revenue
Image Modified
White Label Revenue
Revenue: Sales Revenue
Image Modified
Write Off
Expenses: Bad Debt
Image Modified

Batch


Bill runs


Charge types

...

Tenant affecation for whitelabels are set in [v4].[dbo].[ZuoraWhitelabelTenant]. This table store the product catalog for a specific whitelabel on a tenant and also declare the default invoice template Id to use


Generic products

Create discount product for subscription

Image Added

Catalog importation

...