Proposal summary
This proposal covers the scope of import Timesheet.
Requirement
Neutrinos would like to import timesheets from a third-party system to Netsuite.
Our Solution
The requirement can be achieved by importing the timesheets from a third-party system to Netsuite.
Jobin and Jismi will provide a Timesheet Import template and a saved import mapping
- For Timesheet import, there are some mandatory fields that must be filled in the import template.
- The mandatory fields for import time track entries are Employee, Date, Duration and Location.
- Convert the file to CSV format and add one additional column External ID for future update.
- The Required fields are marked with (Req), this needs to be mapped, so this must be entered on the File for import.
Risks
- If the file contains incorrect characters or the mandatory fields are not filled, then it may lead to import failure.
- The date format, Duration(Time) must be in netsuite supported format.
- Only NetSuite fields that can be edited on the user’s preferred form for the record type are available for import mapping.
- There is a limit of 25,000 records per imported file.
- Need to import the records periodically by the neutrinos team itself by creating the import file by referencing the data from a third party system. There will not be any assistance for importing timesheets from Jobin and Jismi.