NetSuite Import (Sales Order) fails cause of mapped date field (API SuiteApp SuiteScript 2.x)

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

Hey Tyler. Thanks for all the assistance. Hopefully the patch fixes some of the issues.

I got it to work with 1.0. @tylerlamparter thanks for your help!

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.

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

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

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

@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

*assuming all goes according to plan

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?

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

Hi @tylerlamparter, it was my first tried, exactly as I used to do with SuiteScript 1.0

But this is the error:

@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