Skip to main content

Workday Financials GL(Revenue)

Zuora

Workday Financials GL(Revenue)

This feature is in the Early Adopter phase. We are actively soliciting feedback from a small set of early adopters. If you want to join this early adopter program, submit a request to Zuora Global Support.

The Revenue GL Connector for Workday Financials is a pre-built capability that automates the transfer of revenue journal accounting entries and posts the journals into Workday’s general ledger. This connector will streamline your financial processes, reduce manual errors, and help you go live faster. 

Key Features of Workday Financials GL (Revenue)

  • Self-serve configuration UI from Integration Hub
  • User Defined field mapping
  • On-demand and scheduled execution
  • Summary logs and email notifications
  • Grouping criteria selection for the Revenue accounting entries
  • User-defined journal accounting batch size
  • Ability to run the GL connector directly from Revenue Transfer Accounting UI
  • Supports both summary and detailed posting (up to 2.5M Journal Entries)
  • Supports multi-company/multi-currency journal posting 

Prerequisites 

Ensure the following conditions are met for the Revenue to Workday GL connector.

  • Supports Revenue Release version 37.017.05.0 or higher
  • Supports OneID as the authentication type

Configuring Zuora Revenue and Workday Financials

You are required to configure Zuora Revenue and Workday Financials. The following flow diagram outlines the steps involved in configuring and executing the Revenue GL connector for Workday Financials. 

WDAY-GL-Configurationflow.png

Configurations in Zuora Revenue

Navigate to Setup > Application > Profiles  and enable the following profiles in Zuora Revenue to configure the connector.

Profiles  Description/steps 

WEB_SERVICE_ENABLED 

Enables Zuora Revenue to update the status of the Transfer Accounting Batch from READY TO TRANSFER state to TRANSFERRED state. 

This profile is required for the connector to work to post Revenue accounting journal entries into Workday GL.

Complete the following mandatory fields to enable this profile:

  • Type TRANSFER in the Profile Category field.
  • Type WEB_SERVICE_ENABLED in the Profile Name field.
  • Select System in the Profile Level drop-down field. 
  • Toggle the System Level Value radio button to Yes.
  •  Select Checkbox in the Profile Type drop-down field. 

ENABLE_ZR_CONNECTORS 

Enabling the Integration Hub Marketplace in the Zuora Revenue Navigation Menu UI allows you to run the Workday GL connector directly from the Transfer Accounting UI. This profile also allows you to group accounting entries based on your selection criteria. 

Complete the following mandatory fields to enable this profile:

  • Type ENABLE_ZR_CONNECTORS in the Profile Name field.
  • Select System in the Profile Level drop-down field. 
  • Type WDAY_GL in the System Level Value field.
  •  Select Text in the Profile Type drop-down field. 

TA_SUB_BATCH_SPLIT_SIZE 

Enables Zuora Revenue to split a Journal Accounting Batch into multiple smaller chunks of accounting entries. This is a mandatory profile to be set up. 

Complete the following mandatory fields to enable this profile:

  • Type TA_SUB_BATCH_SPLIT_SIZE in the Profile Name field.
  • Select System in the Profile Level drop-down field. 
  • Type a value between 1 - 10000 in the  System Level Value field.

If the value is left blank, the connector execution fails.

  •  Select Number in the Profile Type drop-down field. 

Configuring GL Interface in Zuora Revenue

With version 37.17.05.0,  as an admin, you can select the grouping criteria of the accounting entries by turning on/off the toggle for the fields configured in the GL Interface Setup. The journal accounting entries are grouped into smaller sub-batches based on this grouping criteria.

Complete the following steps to configure GL Interface in Zuora Revenue:

  1. Navigate to Setup > Application > Interface Setup
  2. Click GL Mapping.
  3. Toggle the Enabled button to Yes for Accounted Dr and Accounted Cr Interface Field Name. 

You must configure these fields to post journal entries with amounts in functional currency and to avoid failure of journal accounting batch creation after enabling the connectors.

  1. Toggle the Enabled button to Yes for Accounting Date Interface Field Name. 
  2. Click Save.

Run Transfer Accounting in Zuora Revenue

You can run the transfer accounting process to create a batch of journal accounting entries. The connector requires at least one transfer accounting batch to be in READY TO TRANSFER state.

Transfer accounting batches that are created before version 37.17.05.0 must be regenerated to group the accounting entries and split the accounting journal batch into sub-batches based on the chunk size configured.

Complete the following steps to regenerate a Journal Accounting batch:

  1. Navigate to Accounting > Transfer Accounting.
  2. Click the Regenerate icon.
  3. Select Rebuild and Generate File.
  4. Click Save.

The accounting Journal Batch re-generation will apply to the GroupBy selection configured in the Revenue GL Interface and the Journal Batch will be internally split into multiple chunks based on the value set up in the TA_SUB_BATCH_SPLIT_SIZE profile.

Configuring WorkDay Financials

Before you can connect your Zuora tenant to your Workday ERP, you must have the accurate Workday Connection settings configured.  

Retrieving your Workday Financials credentials

Complete the following steps to retrieve your host and tenant name:

  1. Login and access your Workdays’ console.
  2. Type Public Web Services in the search bar and press Enter.
  3. Click on the applicable filters in the Web Service column to access Financial Management.
  4. Click the icon next to the Financial Management.
  5. Navigate to Web Service > View WSDL.
  6. Search for the address location in the WSDL file to find the URL with the host and tenant names. 

 Creating the Workday ISU for Zuora

An Integration System User (ISU) must be created and maintained in the Workday environment for the connector to work and authenticate.

Complete the following steps to create an ISU) for Zuora:

  1. Login and access your Workdays’ console with your administrator credentials.
  2. Type Create Integration System User in the search bar and press Enter.
  3. Complete the following fields with applicable values:
  • User Name
  • New Password
  • Password Rules
  • Select the Do Not Allow UI Sessions radio button. 
  1. Click OK.

Creating a Workday Security Group and assigning your ISU

After creating an ISU, you need to assign the user to a Workday Security Group similar to User Roles in Revenue.

Complete the following steps to Workday Security Group and assign your ISU:

  1. Login and access your Workdays’ console with your administrator credentials.
  2. Type Create Security Group in the search bar and press Enter.
  3. Select Integration System Security Group (Unconstrained) from the Type of Tenanted Security Group drop-down field.
  4. Type ISSG_Zuora in the Name field.
  5. Click OK to access the Edit Integration System Security Group (Unconstrained) section.
  6. Type ISU_Zuora in the Integration System Users field.
  7. Click OK.

Assigning domain security policy permissions

You must assign domain security policies after creating Workday Security Group. Complete the following steps to assign  domain security permissions:

  1. Login and access your Workdays console with your administrator credentials.
  2. Type Integration System Security Group in the search bar and press Enter.
  3. Navigate to ISSG > Security Group > Maintain Domain Permissions for Security Group.
  4. Click on the Related Actions button.
  5. Determine the permissions required for the Workday setup. 

The permissions listed below cover all of the standard Zuora fields. If a customer requests an extended field from a Zuora-supported Workday data object through data mapping, appropriate permissions must be updated to enable Zuora to access the field.

Security Permissions for Accounting Journal Features

Domain Security Policy Permissions

Operation

Domain Security Policy

Domain Security Policies Inheriting Permission

Functional Areas

Put Only

Process: Journals (NEW)

Process: Journals - Cancel

Financial Accounting

Put Only

Process: Journals - Core

 

Financial Accounting

Get Only

Integration Build

 

Integration

Get Only

Set Up: Maintain Custom Worktags

 

Common Financial Management Worktags

 

Business Process Security Policy Permissions

Business Process

Initiating Action

Functional Areas

Accounting Journal Event

Import Accounting Journal (WS Background Process)

Financial Accounting

Configuring Workday Financials GL (Revenue)

You can find the Revenue GL connector for Workday Financials published in Zuora Integration Hub -> Marketplace and launch the connector UI.

If you’re a customer with Zuora Billing - Zuora Revenue OTR integration, then you can access the Integration Hub -> Marketplace either from Billing Tenant or Revenue Tenant UI. 

If you’re a Zuora Revenue customer, then you can access the Integration Hub -> Marketplace within Revenue UI.

Authenticating your Zuora Revenue and Workday Environments

Complete the following steps to authenticate your Zuora Revenue and Workday environments:

  1. Navigate to  Integration Hub -> Marketplace within Zuora Revenue’s UI.
  2. Click Zuora Revenue Connectors for Workday Financials (GL)
  3. Click Authentication.
  4. Complete the following fields in the Workday Authentication section.
  •     Username
  •     Password
  •     Workday Tenant URL
  1.  Complete the following fields in the Revenue Authentication section.  

  • User Name 
  • Password
  • Role Name
  • Client Name
  • Revenue Tenant Host URL
  1. Toggle the Enable Integration button to activate the connector. 

Note: You can click Test Connection to check your authentication.

Configure Email Notifications

The Revenue GL connector can send email notifications after the connector execution is completed.

Complete the following steps to configure emails:

  1. Navigate to  Integration Hub -> Marketplace within Zuora Revenue’s UI.
  2. Click Zuora Revenue Connectors for Workday Financials (GL)
  3. Click Authentication.
  4. Click the Setting icon.
  5. Enable the Email settings toggle field. 
  6. (Optional) Select Warnings and Success.
  7. Click Add Email to add recipients.
  8. Click Save

Connector Field Mapping

After successful authentication, you can define the field mapping between the source and the target fields based on your needs. The Zuora Source fields provide a list of fields from the Zuora Revenue GL Interface object, and Workday Journal Target Fields provide a list of fields from the Workday Standard Journal Object.

Complete the following steps to map the fields:

  1. Navigate to  Integration Hub -> Marketplace within Zuora Revenue’s UI.
  2. Click Zuora Revenue Connectors for Workday Financials (GL)
  3. Click Field Mapping.
  4. Click the + icon. 
  5. Choose the applicable Revenue source field and map it to the corresponding target field of the Workday Journal. 

You can map both the standard and custom fields from Source to target Workday Journal fields, for example, WorkTags, Cost Centers, and Custom WorkTags.

  1. Click the Refresh icon to dynamically refresh the list of fields in source and target menus upon any fields changes in Zuora Revenue GL Interface object  or Workday Journal Object.
  2. Map the Auto_Complete flag accordingly if the business process validations configured in the Workday system for journal approvals are to be processed or skipped.  

By default, the connector posts and submits the journals in Workday and will not create journals in Draft mode.

Executing the Workday Financial GL (Revenue)

After defining the field mapping, you can set up the connector for execution. Running the connection from the connector UI will pick and process all the Journal accounting batches in the READY TO BE TRANSFERRED state. The connector will post the revenue journals concurrently. You also run the GL connector directly from the Revenue’s Transfer accounting UI against each Journal accounting batch.

Complete the following steps to execute the connector:

  1. Navigate to  Integration Hub -> Marketplace within Zuora Revenue’s UI.
  2. Click Zuora Revenue Connectors for Workday Financials (GL)
  3. Click Execution.
  4. Select the applicable mode from the Execution Mode drop-down field.
  • On-Demand - Allows you to run the connector immediately. 
  • Scheduled - Allows you to schedule the connector execution.
  1. Click Run.

If one or more posting of journals fails during the execution, the connector will cancel the other posted journals without resulting in partial posting problems. You are required to submit a new execution in such scenarios.

You can execute the GL connector directly from the Transfer accounting UI for each Accounting Journal Batch. You must enable the Enable_ZR_Connectors profile and use WDAY_GL in the System Level Value field to do this

Only batches in the READY TO TRANSFER state will have the Run GL Connector button. The Accounting Journal Batch has been introduced with a new status called Posting in Progress. This intermediate status applies only when a GL connector is enabled and triggered directly from the Transferring Accounting UI.

Complete the following steps to Run GL Connector from Transfer Accounting UI:

  1. Navigate to Accounting > Transfer Accounting.
  2. Click the Run GL Connector button.
  3. Click Confirm.

Validate Journals in Workday

After a connector is executed, you will receive an email notification with a file containing details of the connector execution status, the field mappings applied for the execution, and details of the Journals posted into Workday GL.