Configure Workday Financials GL (Billing)
Configuring Workday Financials GL (Billing) involves the following tasks.
Authenticating your Zuora and Workday environments
Complete the following steps to authenticate your Zuora and Workday environments:
- Navigate to Marketplace > Integration Hub.
- Search and select Workday Financials GL (Billing).
- Click Authentication.
- Turn on the Enable Integration toggle to activate the connector.
- Enter appropriate values for the following fields in the Workday Authentication section.
- Get Username: ISU_Zuora_Get@{tenant name}; For example, ISU_Zuora_Get@zuora_dpt1
- Get Password
- Put Username: ISU_Zuora_Put@{tenant name}; For example, ISU_Zuora_Put@zuora_dpt1
- Put Password
- Workday Environment URL
- Enter the Client ID and Client Secret for the Zuora client in the Zuora Authentication section. For more information on how to generate Client ID and Client Secret, see Create an OAuth Client for a User.
- Click Test Connection to validate your authentication details.
- Click Save.
Establishing the Connector field mapping
After successful authentication, you can optionally extend the default field mappings between the source and the target fields. The source fields provide a list of fields from the Zuora journal entry, journal entry item, and accounting code objects. The target fields provide a list of fields from the Workday Standard Journal object.
Complete the following steps to map the fields:
- Navigate to Marketplace > Integration Hub.
- Search and select Workday Financials GL (Billing).
- Click Field Mapping.
- Click the Edit Mappings button.
- Click the + icon.
- Choose the applicable source field and map it to the corresponding target field of the Workday journal.
You can map both standard and custom fields from source to target, such as work tags, cost centers, or custom work tags. - Click the Refresh icon to dynamically refresh the list of fields in the source and target menus upon any field changes in the Zuora or Workday journal object.
By default, the connector posts and submits journals in Workday and does not create journals in draft mode. If you want to manually approve journal postings, you will need to create a constant with the value 'False' and map it to the Auto_Complete target field.
Using Constants
Complete the following steps to specify constants:
- Navigate to Marketplace > Integration Hub.
- Search and select SAP GL (Billing).
- Click Field Mapping.
- Click the Edit Mappings button.
- Click the Open the Expressions Wizard icon.
- In the Expressions Wizard, select Constant.
- Enter a constant value.
- Click the Submit button.
- Click Save Mappings.
Creating value mappings
Complete the following steps to create value mappings:
- Click Field Mapping.
- Click the Edit Mappings button.
- Click the Open the Expressions Wizard icon.
- In the Expressions Wizard, select Value Mapping.
- In the Expressions Wizard, select a source field and create your value mapping.
- Click the Submit button.
- Click Save Mappings.
Configuring default values
If you have a source field that may contain a null value, you may specify a default value to use instead. To configure default values to be used when a source field is null, complete the following steps:
- Click Field Mapping.
- Click the Edit Mappings button.
- Enter a default value in the Enter Default Value field.
- Click Save Mappings.
Specifying custom target fields
If you have configured one or more custom fields in SAP, you may create field mappings for them by manually entering their names. To specify custom target fields, complete the following steps:
- Click Field Mapping.
- Click the Edit Mappings button.
- Enter the name of the target custom field.
Use the dot operator to specify the custom field. For example, JournalEntries.{custom_field_name}.
- Specify a source field or a constant.
- Click Save Mappings.
Initiating a dry run
Before attempting your first transfer to the accounting operation, you can initiate a dry run to verify if your settings and field mappings are configured as required. This process executes the field mappings and generates output for any journal entries for any journal runs awaiting transfer to accounting. This operation can result in more than one dry run job.
Complete the following steps to initiate a dry run:
- Click Field Mapping.
- Click the Initiate a Dry Run button.
- Click the Jobs tab.
- Click the View button for the Dry Run job, or jobs, you have created.