Articles in this section

Troubleshoot Square – NetSuite sync errors

Saikumar Rachamalla
Updated

This article covers known errors that can occur when syncing data between Square and NetSuite, including the cause of each error and steps to resolve it.

Error: Invalid Field Value NaN/NaN/NaN for trandate

Flow: Square Order to NetSuite Cash Sale

Error message:

Failed to add Square Order# ********. Failed to create, update/transform record because You have entered an Invalid Field Value NaN/NaN/NaN for the following field: trandate

Error code: invalid_fld_value

Cause: The flow cannot parse the date format from the Square order JSON. This occurs when the date field mapping does not include the correct format and timezone settings.

Resolution:

  1. In integrator.io, open the Square – NetSuite integration app tile.
  2. Go to Flows > Order.
  3. Next to the Square Order to NetSuite Cash Sale flow, select Edit Mappings. The Post Cash Sale to NetSuite import mappings open.
  4. In the mapping rules, find the closed_at field (Square) mapped to the date field (NetSuite).
  5. Select Edit to open the Settings for that mapping.
  6. In the Date format dropdown, select YYYY-MM-DDTHH:mm:ssZ.
  7. In the Time zone dropdown, select the timezone that matches your Square account.
  8. Select Save & close.
  9. In the integrator.io Dashboard, find the failed flow run and select Retry.

Related to