# NetSuite Import (Sales Order) fails cause of mapped date field (API SuiteApp SuiteScript 2.x) **URL:** \ **Category:** Integrator.io\ **Tags:** script, error-handling, import, debug, netsuite\ **Created:** [April 4, 2023, 5:51pm UTC](https://connective.celigo.com/t/netsuite-import-sales-order-fails-cause-of-mapped-date-field-api-suiteapp-suitescript-2-x/492 "2023-04-04T17:51:40Z")\ **Posts on this page:** 12\ **Page:** 2
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [April 13, 2023, 1:13pm UTC](https://connective.celigo.com/t/netsuite-import-sales-order-fails-cause-of-mapped-date-field-api-suiteapp-suitescript-2-x/492/21 "2023-04-13T13:13:44Z")
@mikebranch @stefanlindner @davidgollom for now, you probably should use SuiteApp 1.0 if you run into one of these issues. We are working on patch for some of these issues and I'll let you know when we have an eta for it. Appreciate your patience here. ---
**Author:** ![davidgollom](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/davidgollom/32/6605_2.png) [@davidgollom](https://connective.celigo.com/u/davidgollom)\ **Post date:** [April 13, 2023, 2:02pm UTC](https://connective.celigo.com/t/netsuite-import-sales-order-fails-cause-of-mapped-date-field-api-suiteapp-suitescript-2-x/492/22 "2023-04-13T14:02:54Z")
Hey Tyler. Thanks for all the assistance. Hopefully the patch fixes some of the issues. ---
**Author:** ![mikebranch](https://avatars.discourse-cdn.com/v4/letter/m/4491bb/32.png) [@mikebranch](https://connective.celigo.com/u/mikebranch)\ **Post date:** [April 13, 2023, 4:45pm UTC](https://connective.celigo.com/t/netsuite-import-sales-order-fails-cause-of-mapped-date-field-api-suiteapp-suitescript-2-x/492/23 "2023-04-13T16:45:50Z")
I got it to work with 1.0. @tylerlamparter thanks for your help! ---
**Author:** ![kristynamachasverako](https://avatars.discourse-cdn.com/v4/letter/k/b9e5f3/32.png) [@kristynamachasverako](https://connective.celigo.com/u/kristynamachasverako)\ **Post date:** [April 18, 2023, 9:31am UTC](https://connective.celigo.com/t/netsuite-import-sales-order-fails-cause-of-mapped-date-field-api-suiteapp-suitescript-2-x/492/24 "2023-04-18T09:31:53Z")
Hello @tylerlamparter, we are facing the similar issue with the Date and Date/Time fields imported via Celigo Suitescript 2.x NetSuite connector after switching from Suitescript v1. Can I ask you if there was any progress on the bug fixing recently? According to NetSuite documentation for a setValue method there is a change of Date and Date/Time object requirements to post the Javascript Date() instead of a string what was a case for Suitescript v1. However I don't see the method even declared in the payload for the date fields in the request what might be a potential issue beside the changed Date value formatting requirements. ---
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [April 20, 2023, 8:04pm UTC](https://connective.celigo.com/t/netsuite-import-sales-order-fails-cause-of-mapped-date-field-api-suiteapp-suitescript-2-x/492/25 "2023-04-20T20:04:51Z")
@kristynamachasverako @mikebranch @davidgollom259 looks like a patch should come in a week or so for date issue and issue when your data is grouped at the source into rows vs records. Confirming with PM on date, but figured I'd give you an update. ---
**Author:** ![stefanlindner](https://avatars.discourse-cdn.com/v4/letter/s/779978/32.png) [@stefanlindner](https://connective.celigo.com/u/stefanlindner)\ **Post date:** [April 21, 2023, 2:10am UTC](https://connective.celigo.com/t/netsuite-import-sales-order-fails-cause-of-mapped-date-field-api-suiteapp-suitescript-2-x/492/26 "2023-04-21T02:10:12Z")
Hi @Tyler Lamparter, thanks for the update - looking forward to have the new version. :) Btw. is there any kind of newsletter or so to get informed about new releases of the SuiteApp? In the regular email for IO upgrades I didn’t see any information acc. SuiteApp changes or did I miss something? Thanks and regards Stefan ---
**Author:** ![stephenbrandt](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/stephenbrandt/32/6891_2.png) [@stephenbrandt](https://connective.celigo.com/u/stephenbrandt)\ **Post date:** [April 21, 2023, 3:01am UTC](https://connective.celigo.com/t/netsuite-import-sales-order-fails-cause-of-mapped-date-field-api-suiteapp-suitescript-2-x/492/27 "2023-04-21T03:01:01Z")
Hi, @stefanlindner. All Celigo NetSuite integration bundle updates are timed with the regular six-week release cycle, and you can find their release notes in their own "What's new" section: [NetSuite integration bundles](https://connective.celigo.com/hc/en-us/sections/13349696991515-NetSuite-integration-bundles). They're typically not that newsworthy, containing bug fixes and support for additional record and subrecord types. And they're also not that timely, since the pre-SuiteApp version needs to be installed into customer accounts over weeklong phases. For a bug fix-only patch, we haven't communicated the status in the past, and we'll take your request under advisement, at a minimum announcing the release in the Community. ---
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [April 27, 2023, 4:29pm UTC](https://connective.celigo.com/t/netsuite-import-sales-order-fails-cause-of-mapped-date-field-api-suiteapp-suitescript-2-x/492/28 "2023-04-27T16:29:22Z")
@stefanlindner @davidgollom259 @kristynamachasverako @mikebranch patch was deployed today for date issue. Let us know how it goes! Grouped data issue is pushed to May release\* along with several others, but the date issue was the most pressing. [https://docs.celigo.com/hc/en-us/articles/14852364987163-Celigo-platform-2023-4-5-maintenance-release-notes](https://docs.celigo.com/hc/en-us/articles/14852364987163-Celigo-platform-2023-4-5-maintenance-release-notes) \*assuming all goes according to plan ---
**Author:** ![alanreyes](https://avatars.discourse-cdn.com/v4/letter/a/97f17d/32.png) [@alanreyes](https://connective.celigo.com/u/alanreyes)\ **Post date:** [May 25, 2023, 9:08pm UTC](https://connective.celigo.com/t/netsuite-import-sales-order-fails-cause-of-mapped-date-field-api-suiteapp-suitescript-2-x/492/29 "2023-05-25T21:08:58Z")
Hi , I´m having exactly the same error, I tried the dateFormat and different configurations but nothing works, does the patch was deployed? does the issue have a solution? ![5301043caa20740200000001-fcd134812781452795357174ef3a4710.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/d/ddce78fa5a0d7c078e4ebcc141b211a919f25a79.png) ![5301043caa20740200000001-970944290e5d407089641d594e5d3102.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/0/0e47c1f8354f2778ca5be3b4aa2bcd58c6cfe2e2.png) ---
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [May 25, 2023, 9:14pm UTC](https://connective.celigo.com/t/netsuite-import-sales-order-fails-cause-of-mapped-date-field-api-suiteapp-suitescript-2-x/492/30 "2023-05-25T21:14:38Z")
@alanreyes patch was deployed so now don't use handlebars and instead use the native date formatting options under the settings wheel on that field mapping. ---
**Author:** ![alanreyes](https://avatars.discourse-cdn.com/v4/letter/a/97f17d/32.png) [@alanreyes](https://connective.celigo.com/u/alanreyes)\ **Post date:** [May 25, 2023, 9:28pm UTC](https://connective.celigo.com/t/netsuite-import-sales-order-fails-cause-of-mapped-date-field-api-suiteapp-suitescript-2-x/492/31 "2023-05-25T21:28:24Z")
Hi @tylerlamparter, it was my first tried, exactly as I used to do with SuiteScript 1.0 ![5301043caa20740200000001-89780040ab25416b81fd5f19f6a011f2.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/0/01fe9cae07507951a5d4f05c0417421d67ebe35c.png) ![5301043caa20740200000001-23474ab41a304bc581e9991e7666f835.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/8/8b82c8f1ca898adde9e21144be2dc4db46de1124.png) But this is the error: ![5301043caa20740200000001-c88628efa3e64807b702438eea486457.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/4/4d1212cb535d1619bcb98c34e97a5d7a79e23465.png) ---
**Author:** ![christelep](https://avatars.discourse-cdn.com/v4/letter/c/3be4f8/32.png) [@christelep](https://connective.celigo.com/u/christelep)\ **Post date:** [June 2, 2023, 3:04pm UTC](https://connective.celigo.com/t/netsuite-import-sales-order-fails-cause-of-mapped-date-field-api-suiteapp-suitescript-2-x/492/32 "2023-06-02T15:04:17Z")
@alanreyes could you try removing the 'Date Format' field? I was having this issue just now and was able to get it working this way. ![5301043caa20740200000001-788c344c4fa9424e92dbb09f41ab1e16.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/f/f735c6742cbf20d80784d0545260c3c40b9a7026.png) ![5301043caa20740200000001-471ae0469e3f4b1fa1c84b39aee6240c.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/b/b64b558b29452beefa89f767fbcb578eccba1595.png) [Previous page](https://connective.celigo.com/t/netsuite-import-sales-order-fails-cause-of-mapped-date-field-api-suiteapp-suitescript-2-x/492.md?page=1)