BeyondERP.Newsletter
Menu

Setup page · System administration

Integration configuration

A setup page where you enter the Azure Storage connection string that Finance uses to import the general ledger transactions produced by the Ceridian Dayforce payroll integration.

Used by
Data management administrator, Information technology manager
Business process
Administer system features
Menu item
PersonnelIntegrationConfiguration
Main table
PersonnelIntegrationConfiguration
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you enter the Azure Storage connection string that Finance uses to import the general ledger transactions produced by the Ceridian Dayforce payroll integration.
What you do hereUse this page to import the payroll integration's general ledger transactions into Finance from an Azure Storage account.
ExampleFor example, an existing V1 Dayforce customer enters the connection string of the storage account that receives the payroll results, tests the connection and sets the integration to Yes, so the payroll general ledger transactions are imported into BEAT by a scheduled batch job.
Integration configuration page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Step by step, with screenshots

Set up Integration configuration1 screen

Use this page to import the payroll integration's general ledger transactions into Finance from an Azure Storage account.

  1. Screen 1

    Review the integration configuration

    Go to System administration > Setup > Integration configuration

    1. Enter the Azure storage account connection string
    2. Select Test connection
    3. Turn on Enable Finance and Operations integration with Azure Storage account
    4. Select Save
    Review the integration configuration (zoomed on the outlined fields)
    Show the full screenReview the integration configuration
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to System administration > Setup > Integration configuration.
  2. Enter the connection string of the Azure storage account that receives the payroll data.
  3. Test the connection.
  4. Set Enable Finance and Operations integration with Azure Storage account to Yes.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Azure storage account connection stringThe connection string of the Azure storage account Finance imports the payroll general ledger data from.Microsoft Learn

Common errors and fixes

MessageWhat to do
The payroll general ledger transactions aren't importedTest the connection string, check that Enable Finance and Operations integration with Azure Storage account is Yes, and check that the Payroll integration export data project exists and its batch job runs. Microsoft Learn

Test checklist

  1. Enter the connection details and test the connection.
  2. Set Enable payroll integration to Yes.
  3. In Data management, check that the Payroll integration export project exists.
  4. Check that the scheduled batch job runs and the general ledger transactions can be imported from the Azure Storage account into Finance.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Integration configurationUse this page only if you're an existing V1 Dayforce integration customer; new customers work with their payroll provider on API-based payroll integrationLearn states the Dayforce V1 integration is only available for existing Ceridian Dayforce customers on the V1 integration with Human Resources.Which payroll integration should the company use?Running the integration on mshr entities without turning off row version change tracking. Learn says to ask Microsoft support to enable the DMFDisableSqlRowVersionCtForCDSVirtualEntity flight first.Test: Payroll ledger data is imported

Feature management and licence

Licence or add-inOn this system the page opens for Information technology manager and Data management administrator. Only existing customers on the V1 Dayforce integration use this page; new customers work with their payroll provider on API-based payroll integration. No Feature management feature needs to be turned on for this page.

Microsoft Learn

Solution architect

5Design impact

Can it be undoneReversible: Connection settings and the export frequency can be changed at any time. Microsoft Learn
If you change it laterThis integration is only for existing customers on the V1 Dayforce integration; new customers work with the payroll provider on API-based payroll integration. Microsoft Learn
Technical architect

6Technical

Menu itemPersonnelIntegrationConfiguration Checked in Dynamics 365
FormPersonnelIntegrationConfiguration Checked in Dynamics 365
TablePersonnelIntegrationConfigurationShown as “Personnel integration configuration” in Record infoChecked in Dynamics 365
Who can open itPrivilegesMaintain integrations from Human Resources to Finance and Operations PersonnellIntegrationConfigurationMaintainDuties PersonnellIntegrationConfigurationMaintain
2 security rolesData management administrator DataManagementAdministratorInformation technology manager SysServerITManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itInformation technology manager SysServerITManagerData management administrator DataManagementAdministratorGive people one of these roles. On this system, 2 roles can open this page.Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, Edit, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=PersonnelIntegrationConfiguration
Data migrationLoad order: Integration configuration has no data entity in Data management, so it can't be loaded from a file or a configuration template. Enter the Azure storage account connection string by hand in each environment and test the connection.Checked in Dynamics 365
Everyone

8Sources