Skip to main content

Integration Queue Errors

Overview

Zone Employee Portal manages its synchronization tasks via an intelligent queue. As an Administrator, you can view these tasks and manage/fix any failed tasks. It is good practice to have NO failed tasks in your Integration Queue.

To access the Integration Queue:

  1. Log into Zone Employee Portal as an Admin

  2. From the menu, select Administration > Integration Queue

  3. Clicking a failed task will present detailed information and actions that can be performed with it (see Integration Queue Task and Possible Actions below)

Use the Delete Record or Delete Task buttons with caution as this may result in data being erased from Zone Employee Portal, NetSuite or both. Data deleted in this way may not be recoverable!

 

Error List

The following list covers most of the integration errors we have seen. Most errors are actually being thrown by NetSuite, meaning that some changes made in Zone Employee Portal will not have made their way into NetSuite. Please use the table below to find your error and following the steps in the 'Possible Resolution' column.

Use the Delete Record or Delete Task buttons with caution as this may result in data being erased from Zone Employee Portal, NetSuite or both. Data deleted in this way may not be recoverable!

Error

Description

Possible Resolution

INVALID_LOGIN_ATTEMPT

Invalid login attempt

Zone Employee Portal is unable to log into NetSuite using the integration details configured. More than likely, someone has disabled the login (Employee/User) previously setup in NetSuite.

  1. In NetSuite, check that the integration employee record is:

    1. Active

    2. Has Access enabled

    3. Has the correct role assigned (e.g. Administrator).

  2. Additionally, in NetSuite, check that the Integration for is enabled (Setup > Integrations > Manage Integrations).

  3. The Integration Queue will automatically retry any failed INBOUND tasks.

  4. If you need to update the integration credentials stored in Zone Employee Portal then follow the instructions here.

INVALID_FLD_VALUE
You have entered an Invalid Field Value 918428 for the following field: entity

NetSuite is rejecting the value entered for the specified field. E.g. Employee with NetSuite Internal ID 251 is not valid.

  1. In NetSuite, check that the Employee (e.g. internal ID 251) is:
    - Active,
    - Not Terminated

  2. Retry the failed sync task in Zone Employee Portal

  3. (optional) Mark the Employee as Inactive again in NetSuite.

INVALID_FLD_VALUE
You have entered an Invalid Field Value 918428 for the following field: entity

NetSuite is rejecting the associated Employee (e.g. 918428) for the Expense Report being created/updated.

  1. In NetSuite, check that the Employee (e.g. internal ID 251) is:
    - Active,
    - Not Terminated

  2. Retry the failed sync task in Zone Employee Portal

  3. (optional) Mark the Employee as Inactive again in NetSuite.

INVALID_FLD_VALUE
You have entered an Invalid Field Value 251 for the following field: acctcorpcardexp

NetSuite is rejecting the Credit Card (e.g. ID 251)account associated with the employee entering an Expense Report.

  1. In NetSuite, ensure that the Credit Card account is
    - Active, and
    - Linked to the same Subsidiary as the Employee.

  2. Fix the above in NetSuite, and Retry the failed sync task in Zone Employee Portal.

INVALID_FLD_VALUE
You have entered an Invalid Field Value 3 for the following field: currency

NetSuite is rejecting the Currency (e.g. ID 3) associated with one of the lines entered on an Expense Report.

  1. In NetSuite, ensure that the Currency record is active.

  2. Retry the failed sync task in Zone Employee Portal.

INVALID_FLD_VALUE
You have entered an Invalid Field Value 758 for the following field: customer

NetSuite is rejecting the Customer or Project (e.g. ID 758) associated with a line on an Expense Report being created/updated.

  1. In NetSuite, ensure that the associated record (e.g. Customer or Project with ID 758) is:
    - Active, and
    - Linked to the same Subsidiary as the Employee
    - Setup to allow linking to an Expense

  2. Retry the failed sync task in Zone Employee Portal.

INVALID_FLD_VALUE
You have entered an Invalid Field Value 20 for the following field: category

NetSuite is rejecting the Expense Category (e.g. ID 20) associated with one of the lines entered on an Expense Report.

  1. In NetSuite, ensure that the Expense Category (e.g. ID 20) is:
    - Active, and
    - Linked to the same Subsidiary as the Employee
    - The associated Account is active

  2. Retry the failed sync task in Zone Employee Portal.

INVALID_RECORD_TYPE
Record Type [allowancetype] is unknown

NetSuite does not recognise the record type being created or updated.

  1. Zone Employee Portal has likely been misconfigured, in NetSuite re-run the Setup assistant.

  2. Check any associated/custom Zone Employee Portal Permission Record.

  3. Retry the failed sync task in Zone Employee Portal.

INVALID_SYNC_DATA
empToResource: Cannot find employee for [{"value":"<RECORD_ID>", "text":"<RECORD_NAME>"}]

Zone Employee Portal cannot find the employee specified by the record being synced. This is typically a Vendor that has been linked on a Time record.

Zone Employee Portal does not support linking Time records to Vendor records (only Employees). Possible resolutions include:

  1. In NS, ensure that the “Exclude from Zone Employee Portal” checkbox is marked on all Timebill records that are not associated to an Employee.

  2. In NS, Adding/Changing the Fields Definition on the Zone Employee Portal Record Permission record for Time. For example:

NEXUS_REQD
No tax agency defined for subsidiary: subsidiary HEADQUARTERS is not linked to nexus <COUNTRY>

Tax has been mis-configured for a subsidiary in NetSuite.

  1. In NetSuite, fix the associated Subsidiary/Tax configuration.

  2. Retry the failed sync task in Zone Employee Portal.

INVALID_COMBINATION_OF_ENTITY_AND_SUBSIDIARY
Invalid combination of entity and subsidiary

NetSuite is rejecting the Expense Report because the selected Employee and Customer(s) do not belong to the same subsidiary.

  1. In NetSuite, ensure that the relative Subsidiary, Employee and Customer records are setup correctly.

  2. In Zone Employee Portal, on the affected Expense Report, reset/reselect the correct Employee and/or Customer

  3. Retry the failed sync task in Zone Employee Portal.

TRANS_UNBALNCD
Transaction was not in balance. Total = -450.0

The Expense Report being created/updated is not in balance. NetSuite does not allow negative expense reports.

  1. In Zone Employee Portal, edit the Expense Report to ensure that it positive and then retry the failed sync task.

  2. Alternatively, if you’d like to delete the Expense Report then as an Admin in Zone Employee Portal find the associated task in the Integration Queue and click the Delete Record button.

EXPENSE_PROCESSED
Expense Report 278277 has been paid and cannot be updated or deleted.

The associated Expense Report has already been paid in NetSuite so it can no longer be updated.

  1. In Zone Employee Portal, Click the Revert from NS button on the associated task in Integration Queue.

INVALID_KEY_OR_REF
Invalid account reference key 111 for subsidiary 5.

Expense account setup incorrectly in NetSuite

  1. In NetSuite, ensure that the relative Subsidiary, Account and Expense Category records are setup correctly.

INVALID_KEY_OR_REF
Invalid custbody_mypay_next_approver reference key -1.

The Zone Employee Portal Next Approver field on the Expense Report is being set to an invalid value in NetSuite. This is likely caused by an incorrect workflow.

  1. In NetSuite, locate the offending Workflow.

  2. Ensure that the FORMULA for setting the Zone Employee Portal Next Approver field is as follows:
    CASE {nextapprover.id} WHEN '-1' THEN {custbody_mypay_next_approver.id} ELSE {nextapprover.id} END

  3. In Zone Employee Portal, click Retry on the associated task in the Integration Queue.

INVALID_FLD_VALUE
You have entered an Invalid Field Value 254 for the following field: custrecord_pr_psd_sub_type

NetSuite is rejecting the selected Allowance Type for the Allowance being created/updated.

  1. In NetSuite, ensure that the relative Pay Component Sub Type (e.g. ID 254) is:

    1. Active

    2. Set to Show in ESS

    3. Has the correct Subsidiaries selected

  2. In Zone Employee Portal, Retry the Integration Queue Task.

USER_ERROR
This time cannot be edited or deleted because it has already been invoiced to the customer.

NetSuite is rejecting changes to the Time record because it has already been invoiced to the customer.

  1. Click the Revert from NS button on the associated task in Zone Employee Portal Integration Queue

POSTED_TIME_ENTRIES_CANNOT_BE_MANIPULATED
Time entries that have been already posted cannot be manipulated before unposting.

NetSuite is rejecting changes to the Time record because it has already been posted.

  1. Click the Revert from NS button on the associated task in Zone Employee Portal Integration Queue

_1_2_IS_UNDER_CONSTRUCTION

Project <PROJECT_NAME> is under construction!

NetSuite is rejecting the Time record because the associated Project is misconfigured.

  1. In NetSuite, check that the Project is correctly configured to allow Time entry.

  2. In Zone Employee Portal, Retry the failed Integration Queue Task.

NOT_IMPLEMENTED
Currently only one tag of 'NS Custom' category can be exported but there are: CATEGORY_1,CATEGORY_2

NetSuite does allow more that one Zone Employee Portal Tag per transaction record.

  1. In NetSuite, ensure that the associated Employee only has one Zone Employee Portal tag selected.

  2. Wait a few minutes for Zone Employee Portal to update the information for the Employee.

  3. In Zone Employee Portal, Retry the failed Integration Queue Task.

THE_EMPLOYEE_DOES_NOT_HAVE_A_TASK_ASSIGNMENT_ROW_FOR_SPECIFIED_TASK_NOR_RESOURCE_ALLOCATION_FOR_SPECIFIED_PROJECT
The Employee does not have a task assignment row for specified task nor resource allocation row for specified project.

NetSuite is rejecting the Time record because the selected Employee is not allowed to enter time against the selected Project/Task.

  • In NetSuite, edit the associated Project/Task to allow entry for the given employee (e.g. add them to the list of resources) and then in Zone Employee Portal Retry the task.

  • Alternatively, in Zone Employee Portal select a different Project/Task on the Time entry

TIME_ENTRY_NOT_EDITABLE_BECAUSE_CHARGE_HAS_BEEN_CREATED
The time entry is not editable because the associated charge has already been created.

NetSuite cannot edit this time entry as the time entry has already been created in the past

  1. Click the Revert from NS button on the associated task in Zone Employee Portal Integration Queue

THIS_TIME_ENTRY_CANNOT_BE_BILLABLE
This time entry cannot be billable.

NetSuite is rejecting the Time record because it’s set to be billable and the Customer/Project/Task does not allow this.

  • In Zone Employee Portal, change the Time entry to not be billable and Retry the task.

  • Alternatively, in NetSuite, change the configuration of the associated Customer/Project/Task to ensure billable Time is allowed and then retry the Task in Zone Employee Portal.

TIME_ENTRY_DISALLWD
<PROJECT_1> does not allow time entry.

NetSuite is rejecting the Time record because the associated Customer/Project does not allow time entries.

  • In Zone Employee Portal, change the Time entry to a different Customer/Project and Retry the task.

  • Alternatively, in NetSuite, change the configuration of the associated Customer/Project to ensure entering Time is allowed and then retry the Task in Zone Employee Portal.

RCRD_DSNT_EXIST
That record does not exist.

The record being updated does not exist in NetSuite.

  1. Ensure that you are not missing (or do not required) the record in NetSuite.

  2. In Zone Employee Portal, click the Delete Record button.

  3. If the above is not available or fails, then click the Delete Task button.

TIME_ENTRY_CANNOT_BE_POSTED
Time Entry cannot be posted.

The Time record cannot be posted in NetSuite.

  1. In Zone Employee Portal, click the Retry button.

  2. If the Task fails again, click the Revert from NS button.

generalError
SequelizeUniqueConstraintError: Validation error

A possible duplicate has been detected in the Zone Employee Portal database.

  1. First, in Zone Employee Portal and NetSuite, ensure that the data is already there.

  2. In Zone Employee Portal, click the Retry button.

  3. If the Retry fails, click the Delete Record button.

Integration Queue Task and Possible Actions

When viewing an Integration Queue Task then additional information is made available to help you debug the issue.

Information Available:

  • Direction: The direction of the data flow to Zone Employee Portal (Inbound or Outbound) Zone Employee Portal.

  • Record: The Zone Employee Portal Record Type and Zone Employee Portal Record ID.

  • Action: The action being performed by the task (create, update, delete).

  • Queued: The date and time that the task was first queued (e.g. a record was created).

  • Started: The date and time that the task was last executed/run.

  • Attempts: The number of times that Zone Employee Portal has attempted to execute the task. Outbound tasks will automatically retry a maximum of 6 times, after this, manual intervention is required.

  • Error: The error reported by Zone Employee Portal / NetSuite.

  • NS push payload: The raw data that Zone Employee Portal is sending to NetSuite.

  • Zone Employee Portal record: The raw record as extracted out of Zone Employee Portal’s database.

  • NS full response: The raw response from NetSuite from the last execution of the task.

  • NetSuite record: The raw record as currently being returned by NetSuite (if available)

  • Zone Employee Portal Record System Notes: Audit trail of changes pertaining to the record being synced.

Use the Delete Record or Delete Task buttons with caution as this may result in data being erased from Zone Employee Portal, NetSuite or both. Data deleted in this way may not be recoverable!

Actions available:

Depending on the Direction, Action and overall state of the Zone Employee Portal/NetSuite record. The following actions (buttons) may be available.

  • Refresh: Refreshes the Task (similar to using the browser’s refresh button but faster).

  • Previous: Pages through to the previous task in the Integration Queue.

  • Next: Pages through to the next task in the Integration Queue.

  • List: Returns to the List of all tasks in your Integration Queue.

  • Retry: Retries the Task (e.g. executes it again).

  • Revert from NS: Reverts the Record in Zone Employee Portal to whatever it’s state is in NetSuite.

  • Delete Task: Deletes the Task. Do not do this unless you know what you’re doing!

  • Delete Record: Deletes the Record from Zone Employee Portal and then creates a sync Task to delete the record from NetSuite.

Was this article helpful?