Integration Queue Errors

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 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 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:

   { "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.