Netsuite Connector Issue

[SHQNY]

Hi! I've encountered a strange issue in the my Hubspot > Netsuite sync, and I'm hoping someone can help me figure out a solution.

We have the sync set up so that once a Deal is marked as Closed-Won in Hubspot, it is pushed into Netsuite as an Opportunity - Won record. However, when the data is pulled into Netsuite, all of the dates entered in the Hubspot Deal show up as the day prior in Netsuite. For example, if a deal has an event date listed as 11/01/2024 on the deal record, the Opportunity record created in Netsuite will display the event date as 10/31/2024.

I have checked, and both accounts are set to the same time zone, so I don't think that is the problem. Any ideas or suggestions on how to fix this issue, or additional settings I should invesigate? 

[tmcginnis · Accepted solution]

@Jnix284 - is the Netsuite Date field a DateTime or just a date picker? HubSpot's Close Date is datetime. When those are mapped to date pickers (without the time) it'll default to midnight UTC, the day before.

[SHQNY]

Switching all of the fields to DateTime properties seemed to do the trick! Thank you for the suggestion!

[tmcginnis]

@SHQNY - great news! Glad it worked out. Happy to help! 🙂

[tmcginnis · Accepted solution]

@Jnix284 - is the Netsuite Date field a DateTime or just a date picker? HubSpot's Close Date is datetime. When those are mapped to date pickers (without the time) it'll default to midnight UTC, the day before.

[Jnix284]

Thank you @tmcginnis you're awesome, I forgot that DateTime mapped to Date Picker does this!

@SHQNY I saw your reply that both properties are custom fields that are Date Picker only, are you not using the default HubSpot Closed Won Date property?

Based on the DateTime to Date Picker conversion issue and it being so similar to what you're encountering, I feel like there has to be a connection somehow. Can you dig deeper into the custom property in HubSpot to make sure it's not a DateTime property?

[SHQNY]

We do use the default HubSpot Closed Won Date property, and it is actually syncing correctly to Netsuite.

However, since we are selling an Event space, we needed to include the date the event will take place on the Deal record, so we created a custom Date Picker field. In Netsuite, we created a similar feild (also a Date Picker) on Opportunity records. So while the Closed Won Date is coming through to the Opportunity in Netsuite correctly, the Event Date is showing up as the date prior.  

I hope this clarifies the issue! 

Do you think switching them all to Date Time feilds would fix the issue? 

[Jnix284 · Accepted solution]

@SHQNY I think it would definitely be worth testing the DateTime property to see if you can get it to sync the correct date information.

[SHQNY]

The feilds that aren't lining up are custom feilds in both Netsuite and Hubspot, and both are date pickers.  

[Jnix284]

This is quite strange @SHQNY, happy to help see if someone I know has any ideas.

@christopher-RVO @tmcginnis have either of you run into any issues where Netsuite is showing dates as the day prior to the date in HubSpot (e.g. HubSpot close date is 11/1/2024, Netsuite shows 10/31/2024) or know someone else at A8 who's worked closely with Netsuite that might have insight?