Configure the UKG Pro to NetSuite Integration Guide

Configure the UKG Pro to NetSuite Integration Guide

UKG Pro to NetSuite Integration

Using Integration Studio Designer (powered by Informatica Cloud) and Integration Events, you can configure integrations to automatically update NetSuite when your UKG Pro general ledger is run.

To use this solution, you must have access to a NetSuite user that has Web Services enabled and has access to Informatica Cloud. For information on configuring Informatica Cloud to access your data, review the Get Started with Integration Studio Designer guide available in the UKG Community Library.

Informatica Cloud, provides in-depth documentation for the NetSuite integration. Access Informatica's documentation for the NetSuite connector titled at the following URL: https://community.informatica.com/docs/DOC-4340.

Before configuring your integration with NetSuite, it’s important to review and understand the setup of UKG Pro’s GL distributions and NetSuite’s journal entries. Mapping data from UKG Pro is easier if the results of UKG Pro's GL distributions match the NetSuite account.

Note

For this integration, NetSuite recommends a maximum 1,000 journal line items for import.

NetSuite Integration Configuration Steps

There are four main tasks to complete to configure the UKG Pro to NetSuite Integration.

  • Step 1: Prepare NetSuite for integration:
    • Sync UKG Pro GL codes with NetSuite codes via .CSV import.
  • Step 2: Complete configurations in Informatica Cloud to define how GL data is to be sent from UKG Pro to NetSuite:
    • Configure the UKG Pro and NetSuite connections.
    • Migrate the GL for Migration data mapping from the UKG Informatica Cloud organization to your suborganization.
    • Configure the GL for Migration data mapping to meet your needs.
    • Create the GL mapping configuration task.
  • Step 3: Configure UKG Pro to activate the NetSuite integration:
    • Configure NetSuite Settings.
    • Subscribe to the General Ledger Integration Event and attach the GL mapping configuration task.
  • Step 4: Run the first GL and monitor the NetSuite integration.
Note

These main tasks cover how to integrate your UKG Pro GL data with NetSuite. You can also configure UKG Pro employee demographic data to integrate with NetSuite. There is a pre-configured data mapping available to help you configure this integration as well. Refer to the Configure Data Mapping for Netsuite Employee Demographic Integrations job aid for configuration steps.

NetSuite .CSV File Import

To sync data between UKG Pro and NetSuite, NetSuite must be able to match UKG Pro IDs and codes with its own IDs and codes. You can associate UKG Pro codes with NetSuite codes via NetSuite’s .CSV import functionality.

Examples of data that may need to be synced between the two systems include GL Chart of Accounts, employee IDs, and location codes.

There are four steps required to use the .CSV import functionality to sync the NetSuite Chart of Accounts to the UKG Pro Base Accounts

  • Step 1: Export the Base Account codes from UKG Pro.
  • Step 2: Export the Chart of Accounts from NetSuite.
  • Step 3: Create the .CSV file that specifies how the codes from UKG Pro match the codes in NetSuite.
  • Step 4: Import the .CSV file into NetSuite.

These steps cover how to create the .CSV to sync the data for the NetSuite Chart of Accounts. You can create and import additional .CSV files as needed (for example, for Employee IDs and Locations Codes).

Export the Base Accounts from UKG Pro

To create the .CSV file for import into NetSuite, you must export the related Base Accounts from UKG Pro.

Navigation:UKG Pro > Menu > System Configuration > Business Rules

  1. From the Business Rules page, search for and select the GL Rules business rule.
  2. Select the Export to Excel (*xls) button to export the Base Accounts to Excel.
    Export to Excel GL Rules

Export the Chart of Accounts from NetSuite

To create the .CSV file for NetSuite, you must export the Chart of Accounts from NetSuite.

Navigation:NetSuite

  1. From NetSuite, navigate to the Chart of Accounts page.
    Note

    On the Chart of Accounts page, ensure that the internal ID of each account appears. If this column is not present, navigate to Home > Set Preferences. Check Show Internal IDs.

  2. Select the Excel icon to export the Chart of Accounts to Excel.
    Excel Icon on NetSuite Chart of Accounts Page

Create the .CSV Import File for NetSuite

The .CSV import file defines how the data from UKG Pro relates to the data from NetSuite.

Navigation:Excel

  1. Open the Excel files from UKG Pro and NetSuite.
  2. Using the data from each Excel spreadsheet, create a .CSV file that has at least two columns:
    • The first column should contain the Chart of Accounts Internal IDs from NetSuite.
    • The second column should contain the matching UKG Pro Base Accounts (considered the External IDs).
    • Include a third column for the associated UKG Pro GL Account number. This column is optional but recommended.
    Important

    For ease of field mapping later, we recommend using the following column headers:

    • InternalID - Header for the NetSuite Chart of Account IDs.
    • ExternalID - Header for the UKG Pro Base Accounts.
    • Number - Header for the UKG Pro GL Account Number. While not required, adding the Number column enables the GL Account Number to appear in NetSuite after the .CSV file is imported.
  3. Save the Excel file as a CSV (comma delimited) file.
    CSV for NetSuite Import

Import the .CSV file into NetSuite

Once the .CSV import file is created, you are ready to import the file into NetSuite.

Navigation:NetSuite

  1. In NetSuite, navigate to the Import CSV page.
  2. From the Import Type drop-down list, select Accounting.
  3. From the Record Type drop-down list, select Chart of Accounts.
  4. From the CSV File(s) section, use the Select button and browse to the .CSV file.
    NetSuite Import CSV Page
  5. Select Next. The Import Options page appears.
  6. From the Data Heading section, select Update.
    NetSuite Import Options
    Note

    You can choose Add or Update if you are importing UKG Pro Base Accounts that do not have a corresponding NetSuite Chart of Accounts record or if you are configuring the Chart of Accounts for the first time.

  7. Select Next. The Field Mapping page appears.
  8. Verify the field mapping in the center of the page. The mapping should be complete if you used the InternalID, ExternalId, and Number headers in the .CSV file. If you used different headers, map each field by dragging the header from the Your Fields column to the center column. Then, drag the corresponding NetSuite field from the NetSuite Fields column to the center column.
    NetSuite Field Mapping page
  9. Select Next. The Save Mapping & Start Import page appears.
  10. From the Import Map Name field, enter the import map name.
    NetSuite Save Mapping and Start Import page
    Note

    Do not enter a Script ID.

  11. Select Save & Run.
  12. Navigate to the Chart of Accounts page in NetSuite to verify the import. The UKG Pro Base Accounts appear in the Number column to indicate that the import was successful.
    Chart of Accounts after Successful .CSV Import

NetSuite Integration Connections

To integrate UKG Pro and NetSuite, you must configure an UKG Pro connection and a NetSuite connection.

  • UKG Pro - Establishes a secure connection between Informatica and UKG Pro
  • NetSuite - Establishes a secure connection between Informatica and NetSuite.
IS_ConnectionTest_Success

Once these connections are established, you attach these connections to the data mappings to define how the data from UKG Pro is to flow to NetSuite.

Create the UKG Pro Connection

Create the UKG Pro connection from the Connections page of Informatica Cloud. The connection is necessary to extract data from UKG Pro and holds the connection information for a specific endpoint.

Important

The Informatica secure agent must be installed on your designated server before you create the UKG Pro connection.

You should also have the following information before beginning this task:

  • Service Account user name and password
  • Customer API Key
  • User API Key associated with the Service Account
  • Location of the installed secure agent

Navigation:Informatica Cloud > Administrator > Connections

  1. From the Connections page, select New Connection. The New Connection page appears.
    • Enter a unique name for the connection in the Connection Name field.
    • Enter an optional description in the Description field, if desired.
    • From the Type drop-down list, select UKG Pro (UKG). The UKG Pro Connection Properties section appears. UKG Pro Connection
  2. From the Runtime Environment drop-down list, select the name of the server where you installed the Informatica Cloud Secure Agent.
  3. At the Password and UKG Pro User Name fields, enter the UKG Pro Service Account password and username.
  4. At the Service Host Name field, enter the service host name. The service host name is your company UKG Pro domain. The format of the domain is service$.ultipro.com, where $ is a numerical value. You can find the service host name in the web service endpoints from the Web Services page in UKG Pro (Menu > System Configuration > Security > Web Services).
    Note

    When you enter the service host name, do not include the "http://" from the endpoint path found on the Web Services page.

  5. At the Customer API Key field, enter your customer API key.
  6. At the User API Key, enter your user API key. (Be sure to enter the User API key associated with the Service Account.)
  7. From the Application Module drop-down list, select the applicable application module. For most general UKG Pro integrations, select HR, Payroll, Talent, Benefits.
    UKG iPro Connection with Configured Properties
    Note

    The application modules are explained as follows:

    • The HR, Payroll, Talent, Benefits application module is used to extract HR, Payroll, Talent, and Benefits data, including integrations triggered by an Integration Event.
    • The Integration Events application module is only used to extract a list of completed UKG Pro Events on-demand.
    • The Other application module is used for Time Management integrations.
  8. Select Test to test the new connection for UKG Pro. A status message appears to let you know if the connection is valid.
    Note

    Verify that the secure agent is active and running before you test the connection.

  9. Select Save to save the new connection.

Create the NetSuite Connection

To move data to NetSuite from UKG Pro using Informatica Cloud, you need to create and configure a connection to NetSuite in Informatica Cloud.

To begin, log in to Informatica with the credentials provided to you from UKG.

Important

The Informatica Secure Agent must be installed on your designated server before you can create the NetSuite Connection.

You should also have the following information before beginning this task:

  • Location of the installed secure agent.
  • NetSuite account login information (this web services account must be granted access to Transactions > Make Journal Entry.)
  • NetSuite account number

Navigation:Informatica Cloud > Administrator > Connections

  1. From the Connections page, select New Connection. The New Connection page appears.
    • Enter a unique name for the connection in the Connection Name field.
    • Enter an optional description in the Description field, if desired.
    • From the Type drop-down list, select NetSuite (Informatica Cloud). The NetSuite Connection Properties section appears.
      Note

      If the NetSuite (Informatica Cloud) type does not appear in the Type drop-down list, submit a support case.

  2. From the Runtime Environment drop-down list, select the name of the server where you installed the Informatica Cloud Secure Agent.
  3. At the Username and Password fields, enter the username and password for your NetSuite account.
  4. At the Service URL field, the production URL for NetSuite appears. If you wish to configure this connection for a NetSuite testing sandbox, manually enter the URL for the sandbox environment.
  5. At the Account field, enter the NetSuite account information. The account is located on the Web Services Preference page in NetSuite (Setup > Integration).
  6. Select Test Connection to test the new connection for NetSuite. A status message appears.
    Note

    Verify the Informatica Cloud Secure Agent is active and running before you test the connection. If the connection test fails, consult the Troubleshoot Your NetSuite Integration job aid in the UKG Community Library.

  7. Select Save to save the new connection.

Import Data Mappings for NetSuite Integrations

The pre-configured GL for Migration and EE Demographics for Migration data mappings can be used in your NetSuite integration.

These pre-configured data mappings are located in our Informatica Cloud organization. Submit a case to request credentials to access the data mappings. We will provide you with a username and password, enabling you to import the data mappings to your Informatica Cloud suborganization.

Navigation:Informatica Cloud > Data Integration > Explore

  1. At the Explore drop-down list, select Projects if it is not already selected.
  2. From the Projects page, select the Default folder.
  3. From the Default pane, select the mappings you wish to import and select the Actions menu for that mapping. For NetSuite general ledger integrations, make sure you select the GL for Migration data mapping. For NetSuite employee demographic integrations, make sure to also select EE Demographics for Migration.
    Informatica - Export/Import Mappings
  4. From the Actions menu, select Export. The Export Assets pop-up page displays. You can change the information in the Job Name field, as applicable.
  5. Select Export.
  6. From the Data Integration page menu, select My Jobs.
  7. At the My Jobs drop-down list, select Export to view the exported mapping.
    Informatica Exports
  8. Select the link the Instance Name column, as applicable. The Job Properties page displays.
  9. Select the link in the Export File field to download the exported mapping.
  10. From the Data Integration page menu, select Explore.
  11. At the Explore drop-down list, select Projects if it is not already selected.
  12. From the Projects page, select Import. The Import Assets page displays.
  13. From the Import Assets page, select Choose File to locate and select the exporting mapping file.
  14. Select Open. The Import Assets page displays.
    Informatica - Import Mapping
  15. Select Import.
  16. From the Data Integration page menu, select My Jobs.
  17. At the My Jobs drop-down list, select Import to view the imported mapping.
  18. Navigate to the Mapping page (Data Integration > Explore > Projects > select folder > select mapping) to edit the data mappings for your NetSuite integration.

Configure the GL For Migration Data Mapping

The Mappings feature of Informatica Cloud enables you to define how the GL data should move from UKG Pro to NetSuite.

You can create a new GL data mapping; however, UKG provides data mappings that you can use. After you migrate the GL for Migration data mapping to your suborganization, these steps guide you through configuring the data mapping to meet your needs.

Note

Currently, NetSuite does not import UKG Pro component company identifiers as external IDs. If you are a OneWorld customer, running separate GLs for specific component companies, identify the NetSuite Subsidiary Internal ID for each component company before beginning. Then, you can edit the expression in the GL for Migration data mapping to identify the subsidiary.

To identify the InternalID for the subsidiary in NetSuite:

1. From NetSuite, use the search functionality to search for Subsidiaries.

2. From the Subsidiaries page, note the Internal ID for each component company.

Navigation:Informatica Cloud > Data Integration > Explore

  1. At the Explore drop-down list, select Assets.
  2. At the All Assets drop-down list, select Mappings.
  3. From the Mappings page, select the GL for Migration mapping. The pre-configured shapes appear in the canvas.
    NetSuite_General_Ledger Data Mapping Canvas
  4. From the canvas, select the source shape, UKG Pro_GL. The Properties panel appears below the canvas.
    Note

    Drag the divider bar up to increase the height of the Properties panel, if desired.

  5. From the Properties panel, select the Source tab. An error message appears because the source does not have an assigned connection yet.
  6. Select OK to acknowledge the error.
  7. From the Connection drop-down list, select your UKG Pro connection. The Source Type and Object fields are configured for you. Additionally, the parameter in the Query Options section is configured to filter the data based on the specific general ledger that is run (identified by the RunID key).
  8. Select the Fields tab to review the fields and related metadata coming from UKG Pro.
  9. From the canvas, use the EnterAFilterHere shape to filter the data coming from UKG Pro.
    Note

    If UKG Pro contains account numbers in the GeneralLedgerAccount field that should not be passed to NetSuite, you can configure a Simple filter condition to prevent that account from being included in the integration.

    For example, GeneralLedgerAccount !=(Not equals) NOGL or any other account number that should be filtered out.

    Filter for GL
  10. From the canvas, select the CommonExpressions shape. This shape contains expressions that can be used define subsidiaries and to break complex GL account codes from the UKG Pro GeneralLedgerAccount field into multiple fields for field mapping. Refer to UKG Pro Business Rules (GL Segment Sequence and GL Rules) to understand the GL Segment sequence structure.
  11. From the Properties pane, select the Expression tab. The pre-configured expressions appear.
  12. Edit, add, or delete expressions, as needed.
    Note

    The Subsidiary expression is a common expression to edit. To define your subsidiaries:

    • Select the subsidiary expression link.
    • At the Expression field, replace the value with the component company's InternalID from NetSuite and select OK.
  13. From the canvas, select the target shape, NetSuite_JE.
  14. Select the Target tab from the Properties panel. An error message appears because the target does not have an assigned connection yet.
  15. Select OK to acknowledge the error.
  16. From the Connection drop-down list, select your NetSuite connection. The Object, Child Object, and Operation fields are configured for you.
  17. Select the Target Fields tab to view the fields included in the target.
  18. Select the Field Mapping tab.
  19. Drag the Incoming Fields on the left to the Target Fields on the right to map the UKG Pro fields to the NetSuite fields.

    By default, the following fields are mapped:

    Target Fields (NetSuite) Incoming Fields (UKG Pro) Description
    Memo Description Description
    JournEntry_tranDate PayPeriodEndDate Transaction date
    JournalEntry_subsidiaryInternalId Subsidiary Component company identifier
    JournalEntry_memo JournalEntry_Memo Payroll plus the period end date
    JournalEntry_externalId RunID Unique identifiers for the specific journal entry posting
    debit DebitAmt Debit amount
    credit CreditAmt Credit amount
    account_ExternalId Segment1 The UKG Pro and NetSuite IDs that define the Chart of Account/Base Account
    Note

    You may need to create a .CSV file to tell NetSuite how UKG Pro codes are to be synced. For example, to map the Chart of Accounts in NetSuite to GL Account Codes in UKG Pro, you must create and upload a .CSV file to NetSuite. If additional code-driven data is needed, the codes must be defined and imported into NetSuite via .CSV, as well (for example, to match a specific organization level from UKG Pro to Departments in NetSuite).

    If you have custom fields in NetSuite that do not appear, check role and field/object settings in NetSuite. Then, navigate to the Target Fields tab of the NetSuite_JE shape. Select the Synchronize icon near the top right of the Fields table. If the custom fields do not appear after synchronization, consider creating a CustomFields.ini file. Refer to the Informatica Cloud NetSuite Connector Guide for additional instructions.

  20. Select Save and Close. The mapping appears on the Mappings page. A validation will be completed and you can view the status of the validation from this page.

Create the Mapping Configuration Task for General Ledger

The mapping configuration task is the integration task that you will attach to the Integration Event in UKG Pro. When the event occurs, this integration task is triggered automatically in Informatica Cloud and the data from UKG Pro is sent to your target.

Navigation:Informatica Cloud > Data Integration > New > Tasks > Mapping Task > Create

  1. At the Task Name and Description fields, enter a task Name and optional description (for example, NetSuiteGeneralLedger).
  2. At the Location field, select Browse to select a project or folder for the mapping task.
  3. From the Runtime Environment drop-down list, select the location of the installed secure agent.
  4. At the Mapping field, select the Select button to select the configured data mapping.
  5. At the Explore drop-down list, select Assets.
  6. At the All Assets drop-down list select Mappings and select the data mapping previously created.
  7. Select the Select button. The data mapping appears in the Mapping Image section.
  8. Select Next.
  9. From the Source Parameters Details section, verify that the connection is UKG Pro and verify that applied filters are correct. For example, the filter for NetSuite General Ledger should be: RunId eq 'PARAM_US_RUNID'.
  10. Select Next to navigate to the Schedule step where you can enter the e-mail notification options for this task, if desired.
    Tip

    We do not recommend using e-mail notifications until after the integration is tested. After testing is complete, return to this step and complete the following:

    • Select the Use Custom Email Notification Options for this Task radio button.
    • Enter the e-mail addresses of the individuals who should receive Failure, Warning, and Success notifications from Informatica Cloud.
    Schedule Step of the Mapping Configuration Task
  11. Select Save.
  12. Select Finish. The Mapping Configuration task appears. This task can now be attached to an Integration event in UKG Pro.
    Important

    It may take up to five minutes for newly added tasks to appear for selection in UKG Pro Integration Events.

NetSuite Settings

System administrators must enable the NetSuite Integration status from the NetSuite Settings page.

The setting is OFF by default. When the Integration Status is configured as YES, the NetSuite Integration section is available from the Process General Ledger page (Menu > Administration > Reporting > General Ledger).

If GL Tasks have not been configured from Integration Studio yet, an informational message appears in the NetSuite Integration section.

Additionally, when Integration Status is configured as YES, the NetSuite - Journal Entries link appears in the Things I Can Do section of the Process General Ledger page. This link provides users with single sign-on access to NetSuite. This link can be secured to specific roles in Role Administration.

Important

In order for users to have single sign-on access to NetSuite from the NetSuite – Journal Entries link of the Process General Ledger page, single sign-on settings must also be configured in NetSuite and the user must have appropriate permissions in NetSuite.

Configure NetSuite Settings

You must enable the Integration Status on the NetSuite Settings page to enable the NetSuite Integration section and the NetSuite - Journal Entries link in the Things I Can Do section on the Process General Ledger page (Menu > Administration > Reporting > General Ledger).

The settings are OFF by default. You must have your NetSuite Account ID number available when you enable the integration status.

Navigation:UKG Pro > Menu > System Configuration > Application Connections > NetSuite

  1. From the NetSuite Settings page, select Edit.
  2. Select the Integration Status slider button to change the Integration Status from NO to YES.
  3. At the NetSuite Account Id field, enter a valid account number.
    Note

    You can find the NetSuite Account ID on the Web Services Preferences page of NetSuite (NetSuite > Setup > Integration > Web Services Preferences).

  4. Select Save.

Subscribe to the Integration Event for NetSuite

For the NetSuite integration configuration, you must subscribe to the NetSuiteGeneralLedger event from the Integration Events page in UKG Pro.

You can subscribe to an event before or after you configure the mapping configuration task in Informatica Cloud; however, the integration tasks cannot be attached to events until they are configured in Informatica Cloud.

Navigation:Menu > Administration > Integration Studio > Integration Events

  1. From the Integration Events page, select the NetSuiteGeneralLedger link from the Event Name column. The selected event link page appears.
  2. Select Edit to add or remove a subscription to an event.
  3. Select the Subscribed slider button to change the Subscribed value from NO to YES.
  4. In the Attached Tasks section, check the box next to the NetSuite task that has been configured in Informatica Cloud.
    Note

    If the task has not been configured in Informatica Cloud yet, you can save and return to this page at a later time to attach the configured task. It can take up to five minutes for a newly added Informatica task to appear in UKG Pro.

  5. Select Save.
    Subscribe to the NetSuiteGeneralLedger Integration Event
  6. Select Back. The Integration Events page appears with a green check mark in the event's Subscribed column. The Attached Tasks column displays the task attached to the event. Now, when a user processes the general ledger and chooses to send the data to NetSuite, the data will be sent to NetSuite automatically.
    Note

    To receive notifications if UKG Pro fails to connect to Informatica Cloud (and Informatica Cloud does not receive the request to trigger the task), navigate to the Event Notifications page. Select Edit and enter the e-mail addresses of the individuals who are to receive the error e-mail.

Send General Ledger Data to NetSuite

Once the NetSuite integration configuration is complete, users can choose to send the GL data to NetSuite from the NetSuite Integration section of the Process General Ledger page.

Navigation:Menu > Administration > Reporting > General Ledger

  1. From the NetSuite Integration section of the Process General Ledger page, check the Post General Ledger box.
  2. From the GL Tasks Name drop-down list, select the applicable NetSuite task.
    NetSuite Integration Section on the Process General Ledger Page
  3. Complete the other sections, as needed.
  4. Select Run. UKG Pro creates the GL data and runs the applicable standard reports. Additionally, the NetSuiteGeneralLedger event calls the attached integration task and runs it in Informatica Cloud. The task sends the data to NetSuite automatically.

Monitor the NetSuite Integration

Monitoring and reporting integrations between UKG Pro and NetSuite can be helpful when troubleshooting unsuccessful integrations. Each application (UKG Pro, Informatica, and NetSuite) includes their own monitoring tools.

After the GL is run, there are multiple places where you can monitor the integration of data between UKG Pro and NetSuite.

  1. From UKG Pro, navigate to Menu > Administration > Integration Studio > Activity Log to view the status of integration from within UKG Pro.
    • Identify the task. If UKG Pro successfully connected with Informatica Cloud to trigger the integration with NetSuite, a status of Completed appears.
    Activity Log with a NetSuite Integration
    Note

    If an error is received, an error has occurred in UKG Pro and the request to trigger the integration task was not submitted to Informatica Cloud. Submit a ticket with the error ID from the Message column.

    • To receive notifications if UKG Pro fails to connect to Informatica Cloud (and Informatica Cloud does not receive the request to trigger the task), navigate to the Event Notifications page (Menu > Administration > Integration Studio > Integration Events > Event Notifications). Select Edit and enter the e-mail addresses of the individuals who are to receive the error e-mail. Select Save.
  2. From Informatica Cloud, navigate to the Jobs page (Monitor > Jobs) to view the status of the integration task in Informatica. Select Running Jobs to display current running transmission status or select All Jobs to display historical transmissions.
    • To receive Informatica Cloud notifications for all integrations, navigate to Informatica Cloud > Administrator > Organization. Scroll to the Default Email Notifications section and enter the e-mail addresses of the individuals who are to receive the e-mails. Select Save.
    • To receive Informatica Cloud notifications for all integrations, navigate to Informatica Cloud > Data Integration > Assets. Select the specific mapping task. Select Edit. Select the Schedule tab. Scroll to the Notifications section and enter the e-mail addresses of the individuals who are to receive the e-mails. Select Save.
  3. Select the drop-down list to view either Data Integration, Import, or Export jobs.
  4. Select the task's Name link to view the details.
    Monitor Jobs in Informatica
  5. From NetSuite, navigate to Setup > Integration > Web Services Usage Log.
    • Select the Integration drop-down list to filter on your specific integration.
      Note You can also filter by Date Range and Record Type. From the Record Type drop-down list, select either Journal Entry or Employee.
    • Scroll to the right to review the Request and Response columns. The Request XML file displays the transmitted values and their corresponding fields. The Response XML file displays Success or provides the reason for the error.
    • From the Request column, select View to download the Request XML file.
    • From the Response column, select View to download the Response XML file.
      Note You may need to contact your IT team to request applications, such as Notepad or Excel, to read the XML files.
    The errors produced are often searchable in NetSuite Help. Contact NetSuite for assistance in troubleshooting your specific error response. The most common reason for a failed GL integration is an inconsistency in the data reported by the ledger.
  6. From NetSuite, navigate to Transactions > Financial > Make Journal Entries > List. The list of journal entry records appear.
    • From the Quick Sort drop-down list, select Recently Created.
    • Select the entry's View link. The details of the Journal Entry record appears.
    NetSuite Journals Page
  7. Compare the data that displays with the GL reports from UKG Pro.
    NetSuite Credits and Debits
  8. From UKG Pro, navigate to Menu > Administration> Reporting > File Transfers to open the PDF file, GL Summary Distribution <XXX>. This report provides the same data that was migrated from the GL integration.
    • Review output and clear any suspense items.
    • Review data and formatting inconsistencies with the string.
    • Scroll to the bottom of the report and confirm that the NOGL credits and debits are in balance. Check that the total value is in balance.
  9. From NetSuite, run and view the General Ledger (Setup > Integration > Web Services Usage Log).
    • From the Web Services Usage Log, filter on Record Type: Journal Entry.
    • Scroll to the right and view the XML Request.
      Note You may wish to open the file in Excel using the built-in XML tool. It should populate an Excel format of the data transmitted by the integration. Refer to Excel help or contact your IT department for assistance.
    If the payroll and GL report are correct, check the data by confirming that the internal and external IDs are assigned correctly in both UKG Pro and NetSuite. In addition, consider any validation rules in NetSuite specific to your environment. You can also review the integrator’s expressions and rules. For additional assistance, submit an UKG Pro support case. For NetSuite-related errors, contact your NetSuite administrator or search NetSuite Help.