Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview

MyPay manages its synchronisation tasks via an intelligent queue. As an Administrator, you can view these tasks and manage/fix any failed tasks. It is good practise to have NO failed tasks in your Integration Queue.

To access the Integration Queue:

  1. Log into MyPay 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)

Note

Use the Delete Record or Delete Task buttons with caution as this may result in data being erased from MyPay, 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 MyPay 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.

Note

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

Error

Description

Possible Resolution

(s)

INVALID_LOGIN_ATTEMPT

Invalid login attempt.

MyPay 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 MyPay then follow the instructions here.

INVALID_FLD_VALUE
You have entered an Invalid Field Value

251

918428 for the following field:

employee

entity

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

  • Check that the associated record is not inactive in NetSuite (e.g. Employee with internal ID 251).

  • Check that there is no filtering for the specified field. (e.g. Project Task field on Time records)
    1. In NetSuite, check that the Employee (e.g. internal ID 251) is:
      - Active,
      - Not Terminated

    2. Retry the failed sync task in MyPay

    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 MyPay

    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 MyPay.

    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 MyPay.

    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 MyPay.

    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 MyPay.

    INVALID_RECORD_TYPE
    Record Type [allowancetype] is unknown

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

    1. MyPay has likely been misconfigured, in NetSuite re-run the Setup assistant.

    2. Check any associated/custom MyPay Permission Record.

    3. Retry the failed sync task in MyPay.

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

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

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

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

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

      Code Block
      {
        "is_mypay_exclude": {
          "name": "formulatext",
          "formula": "NVL2({vendor.internalid}, 'T', 'F')",
          "type": "text"
        }
      }

    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 MyPay.

    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 MyPay, on the affected Expense Report, reset/reselect the correct Employee and/or Customer

    3. Retry the failed sync task in MyPay.

    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 MyPay, 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 MyPay 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 MyPay, 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 MyPay 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 MyPay Next Approver field is as follows:
      CASE {nextapprover.id} WHEN '-1' THEN {custbody_mypay_next_approver.id} ELSE {nextapprover.id} END

    3. In MyPay, 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 MyPay, 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 MyPay 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 MyPay 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 MyPay, 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 MyPay Tag per transaction record.

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

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

    3. In MyPay, 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 MyPay Retry the task.

    • Alternatively, in MyPay 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.

    1. Click the Revert from NS button on the associated task in MyPay 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 MyPay, 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 MyPay.

    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 MyPay, 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 MyPay.

    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 MyPay, 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 MyPay, 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 MyPay database.

    1. First, in MyPay and NetSuite, ensure that the data is already there.

    2. In MyPay, click the Retry button.

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

    Anchor
    task_actions
    task_actions
    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 MyPay (INbound) or from (OUTbound) MyPay.

    • Record: The MyPay Record Type and MyPay 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 data and time that the task was last executed/run.

    • Attempts: The number of times that MyPay 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 MyPay / NetSuite.

    • NS push payload: The raw data that MyPay is sending to NetSuite.

    • MyPay record: The raw record as extracted out of MyPay’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)

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

    Note

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

    Actions available:

    Depending on the Direction, Action and overall state of the MyPay/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 MyPay 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 MyPay and then creates a sync Task to delete the record from NetSuite.