Anyone have any tips for how to map to a NetSuite ...
# integrationsa
AI1
04/20/2023, 5:07 PMAnyone have any tips for how to map to a NetSuite date field in Celigo when creating an Invoice transaction. I’ve tried using handlebars and also Date formats in the Mapping tool but I just keep getting Invalid date format (must be M/D/YYYY). Not sure where else I can reformat dates
m
mightyd3
04/20/2023, 6:37 PMIf you don't submit a date, it should utilize today's date. Have you attempted to simply hardcode a date to figure out which date format is accepted, first?
mightyd3
04/20/2023, 6:40 PM{{dateFormat "MM/DD/YYYY" [myDateField] "M/D/YY"}} this handlebar will update a date field format from m/d/yy to mm/dd/yyyy. You can play around with it for your format needs.
a
AI1
04/20/2023, 6:41 PMDo you need the quotes around the formats?
m
mightyd3
04/20/2023, 6:42 PMYes
a
AI1
04/20/2023, 6:52 PMStill get the same error
m
mightyd3
04/20/2023, 6:52 PMerror if hardcoded?
mightyd3
04/20/2023, 6:53 PMor error if date not mapped?
a
AI1
04/20/2023, 6:53 PMNo if I use the handle bar with my date field
AI1
04/20/2023, 6:54 PM{{dateFormat “YYYY-MM-DDTHHMMSS” received_date “M/D/YYYY”}}
m
mightyd3
04/20/2023, 6:57 PMNeeds to be the opposite.
mightyd3
04/20/2023, 6:57 PMAssuming you are converting the hourminutesecond time into M/D/YYY
mightyd3
04/20/2023, 6:57 PM{{dateFormat “M/D/YYYY” received_date “YYYY-MM-DDTHHMMSS”}}
a
AI1
04/20/2023, 7:01 PMStill get the same error
m
mightyd3
04/20/2023, 7:01 PMYou should play with the developer playground in Celigo to get it right.
t
Tyler Lamparter
04/20/2023, 7:23 PMProbably need to set your import to SuiteApp 1.0 for now. See thread here: https://docs.celigo.com/hc/en-us/community/posts/14259950323995-NetSuite-Import-Sale[…]use-of-mapped-date-field-API-SuiteApp-SuiteScript-2-x-?page=1
Patch looks to be about a week out
m
mightyd3
04/20/2023, 7:35 PMThat thread certainly answers that.
a
AI1
04/20/2023, 7:36 PMGot it to work
Had to use THHmmss instead of THHMMSS
AI1
04/20/2023, 7:40 PM@mightyd3 thanks for the help. Got me on the right track
AI1
04/20/2023, 7:53 PMNow just need to figure out my timezone problems. I can’t tell what time zone my source data is in plus what time zone Celigo is using when sending callls with {{lastExportDateTime}} in them. It seems like everything is a few hours off to me 🤷♂️
m
mightyd3
04/20/2023, 7:58 PMI believe that is set in the Time Zone settings in the 'my account' section.
a
AI1
04/20/2023, 8:00 PMSo if I set my settings in my Celigo account to Central time
Put my source data is in pacific time Celigo will do the conversion for me?
If the last exported time was 10:00am CST it will look for dates after 8:00am Pacific in my source data?
t
Tyler Lamparter
04/27/2023, 4:30 PMDate formatting issue is fixed https://docs.celigo.com/hc/en-us/articles/14852364987163-Celigo-platform-2023-4-5-maintenance-release-notes
Tyler Lamparter
04/27/2023, 4:31 PMAs for the other questions, the lastExportDateTime is set in UTC by default and your account level profile setting has nothing to do with changing that. If you need to reformat to another timezone, you can use dateFormat handlebar expression
10 Views