Netsuite Sync Error | Invalid date value must be M/D/YYYY

Overview

Ramp has received the following error message from your Accounting Provider NetSuite:

Invalid date value (must be M/D/YYYY)

OR

Reimbursement Sync Error "Invalid date value (must be M/D/YYYY)

What does this mean?

This means that ramp_restlet.js file in customer environment is not up to date. This file needs to be updated to sync successfully.

How do I resolve this error?

Please follow these steps to resolve this error from NetSuite:

FOR THE MULTI-SUBSIDIARY RESET (ONE WORLD)

  1. Navigate to Customization > SuiteCloud Development > Installed SuiteApp List and take the Uninstall action on the Ramp Integration

  2. Navigate to Customization > Scripting > Script Deployments, Edit the customdeploy_ramp_restlet and do the Delete action from the Edit screen if it wasn't removed with the SuiteApp.

  3. Navigate to Customization > Scripting > Scripts, check if the Ramp API restlet was cleaned up by Step 1 (if it still exists, try to delete it) if it wasn't removed with the SuiteApp.

  4. At this point, it should be in a fresh state to re-do the setup instructions.

FOR THE SINGLE SUBSIDIARY RESET

To locate delete all records they created as part of the manual setup, or rename them and/or mark them as inactive where it is not possible to delete them:

    1. Get rid of the ramp_receipt_url
  2. Head to Customization -> lists -> transaction body fields
  3. Locate ramp receipt url
  4. Change ID and name
  5. Rename Ramp Accountant Role (and set it as inactive if possible)
  6. Go to Setup → Users/Roles → Manage Users
  7. Locate "Ramp Accountant Role"
  8. Click Edit role
  9. Rename the role and set as inactive if possible
  10. Rename restlet script
  11. Navigate to Customization → Scripting → Scripts
  12. Find the ramp restlet script and click on it
  13. Rename the script

Raw error message: Invalid date value (must be M/D/YYYY) for your technical team.