Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
Time entry/timebill integration from OpenAir to NetSuite not working
After NS moved us to a new data center Aug 18, we have issues with vendor timebill integration from OA to NS.
After some digging I confirmed that if I manually export a vendor timesheet from OA to NS everything works as it should (time entry goes to NS, creates corresponding time record on NS, a custom script runs to create a linked JE, then NS sends the NS time entry ID back to OA) and the timesheet is marked as exported in OA.
However, when the OA NetSuite Integration script runs as scheduled (or I manually start the integration) with the checkbox to include Time Entries checked, approved un-exported OA vendor timesheets do not export to NS as they should. To make matters worse, the OA time entries do export to NS and corresponding NS time records are created, BUT the custom script that creates a linked JE is not created, and the NS time entry ID is not sent back to OA. Because of this last point, the time entries are exported to NS every time scheduled OA NS integration runs.