Our company has integrated with Netsuite using the RESTlet interface. Everything is working fine except for one thing: when we go to create or save a SalesOrder in Netsuite, all of the date fields default to today if we pass in a blank date value.
Here's an example: When we save a SalesOrder and add Items, the Item-level records have the fields RevRecStartDate and RevRecEndDate. On our end, the values we are mapping to those fields in NS are subscription term start and end dates. Some products in our system are open-ended and, therefore, do not have term start/end dates set -- they are left blank. When we sync this data to NS via the RESTlet interface, those blank term start/end dates are mapped to RevRecStartDate and RevRecEndDate. But, when we look at the SO created in NS afterwards, those fields default to today.
I've tried passing NULL values instead of blank (''), I've tried not sending those fields to NS if they're blank, and I've tried all zeroes. I cannot get those date fields to remain blank in NS. And although I'm specifically talking about just the RevRec date fields, this same problem applies to ALL date fields in our SO, even custom date fields we added.
Any thoughts/ideas on how to get this to work? It may seem trivial, but our Finance department has built all of their workflows off these dates, so having them match our internal when blank is vital to us. Any help is appreciated!
PS -- We previously used the Netsuite SOAP webservices, and that worked fine with blank dates. A month ago we switched to the RESTlet webservice, hoping it'd be better, but now we're having trouble with the dates.