Time Entries to Time Entries Custom Export Best Practice

If you are creating a custom export workflow exporting time entries from SuiteProjects Pro to NetSuite, use the guidelines in the following table.

If you are using the custom export workflow in conjunction with the standard workflow for time export, you should use a filter to exclude all SuiteProjects Pro time entries that already have a NetSuite ID from the Time Entries (Time) export workflow to avoid integration errors. For more information about the standard workflow for time export, see Time Entries (Time) Export Workflow.

NetSuite Field	SuiteProjects Pro Field	Notes
`TimeBill.custcol_oa_time_entry_id`	`Task.id`	Read-only Select the NetSuite record ID field `custcol_oa_time_entry_id` when you create the custom export workflow. Using the ID fields specified in this table prevents duplicated time entries from being created in NetSuite by the custom export workflow. See Exporting Records from SuiteProjects Pro to NetSuite Using Custom Workflows.
`TimeBill.internalid`	`Task.netsuite_timebill_id__c`	Read-only Select the SuiteProjects Pro record ID field `netsuite_timebill_id__c` when you create the custom export workflow. Using the ID fields specified in this table prevents duplicated time entries from being created in NetSuite by the custom export workflow. See Exporting Records from SuiteProjects Pro to NetSuite Using Custom Workflows.
`TimeBill.employee`	`#Employee lookup employee lookup=user_id:lookup_table=user:lookup_by=id:lookup_return=netsuite_user_id`	An advanced mapping must be used to look up the SuiteProjects Pro value to be exported to the Employee field in NetSuite. See Advanced Mapping and Filter Notation Reference and Advanced Mappings for Custom Export Workflows.
`TimeBill.item`	`#Item lookup item lookup=category_id:lookup_table=category:lookup_by=id:lookup_return=netsuite_category_id`	An advanced mapping must be used to look up the SuiteProjects Pro value to be exported to the Item field in NetSuite. See Advanced Mapping and Filter Notation Reference and Advanced Mappings for Custom Export Workflows.
`TimeBill.customer`	`#Customer-Project lookup customer lookup=project_id:lookup_table=project:lookup_by=id:lookup_return=netsuite_project_id`	An advanced mapping must be used to look up the SuiteProjects Pro value to be exported to the Customer field in NetSuite. See Advanced Mapping and Filter Notation Reference and Advanced Mappings for Custom Export Workflows.
`TimeBill.hours`	`Task.hours_and_minutes__c`	SuiteProjects Pro uses two separate fields for time entry (hours and minutes), while NetSuite uses a single field (hours). It is not possible to map the time value directly unless you use full hours only for time entry in your company. Instead, you should use a form script to combine the hours and minutes fields into a decimal value and store this value in a custom field in SuiteProjects Pro, and map this decimal time value custom field to the time field in NetSuite. For information about form scripts, see User Scripting.
`TimeBill.isBillable`	`#Always billable unless marked as 'Non-Billable' IF <<END IF (netsuite_billable_time = 'Non-Billable') THEN isBillable 'false' ELSE isBillable 'true' END`	If required, the SuiteProjects Pro custom field NetSuite Billable Time [`netsuite_billable_time`] and an advanced mapping can be used to mark the time entries as billable in NetSuite. See Advanced Mapping and Filter Notation Reference and Advanced Mappings for Custom Export Workflows. Note: The NetSuite Billable Time [`netsuite_billable_time`] is created automatically when you activate the Time Entries (Time) standard export workflow. To show the custom field as columns on the Timesheet grid (Web application UI) or time card properties (Mobile app UI), contact SuiteProjects Pro Support. You will need to provide the internal ID for the NetSuite Billable Time custom field, which you can obtain from the custom field list (Administration > Global Settings > Custom Field), and clear the Hide on data entry forms box in the custom field properties.
`TimeBill.tranDate`	`Task.date`	—

NetSuite Field

Direction

SuiteProjects Pro Field

Notes

TimeBill.custcol_oa_time_entry_id

Task.id

Read-only

Select the NetSuite record ID field custcol_oa_time_entry_id when you create the custom export workflow. Using the ID fields specified in this table prevents duplicated time entries from being created in NetSuite by the custom export workflow. See Exporting Records from SuiteProjects Pro to NetSuite Using Custom Workflows.

TimeBill.internalid

Task.netsuite_timebill_id__c

Read-only

Select the SuiteProjects Pro record ID field netsuite_timebill_id__c when you create the custom export workflow. Using the ID fields specified in this table prevents duplicated time entries from being created in NetSuite by the custom export workflow. See Exporting Records from SuiteProjects Pro to NetSuite Using Custom Workflows.

TimeBill.employee

                    #Employee lookup
employee lookup=user_id:lookup_table=user:lookup_by=id:lookup_return=netsuite_user_id

An advanced mapping must be used to look up the SuiteProjects Pro value to be exported to the Employee field in NetSuite. See Advanced Mapping and Filter Notation Reference and Advanced Mappings for Custom Export Workflows.

TimeBill.item

                    #Item lookup
item lookup=category_id:lookup_table=category:lookup_by=id:lookup_return=netsuite_category_id

An advanced mapping must be used to look up the SuiteProjects Pro value to be exported to the Item field in NetSuite. See Advanced Mapping and Filter Notation Reference and Advanced Mappings for Custom Export Workflows.

TimeBill.customer

                    #Customer-Project lookup
customer lookup=project_id:lookup_table=project:lookup_by=id:lookup_return=netsuite_project_id

An advanced mapping must be used to look up the SuiteProjects Pro value to be exported to the Customer field in NetSuite. See Advanced Mapping and Filter Notation Reference and Advanced Mappings for Custom Export Workflows.

TimeBill.hours

Task.hours_and_minutes__c

SuiteProjects Pro uses two separate fields for time entry (hours and minutes), while NetSuite uses a single field (hours). It is not possible to map the time value directly unless you use full hours only for time entry in your company. Instead, you should use a form script to combine the hours and minutes fields into a decimal value and store this value in a custom field in SuiteProjects Pro, and map this decimal time value custom field to the time field in NetSuite.

For information about form scripts, see User Scripting.

TimeBill.isBillable

                    #Always billable unless marked as 'Non-Billable'
IF <<END
IF (netsuite_billable_time = 'Non-Billable') THEN isBillable 'false' ELSE isBillable 'true'
END

If required, the SuiteProjects Pro custom field NetSuite Billable Time [netsuite_billable_time] and an advanced mapping can be used to mark the time entries as billable in NetSuite. See Advanced Mapping and Filter Notation Reference and Advanced Mappings for Custom Export Workflows.

Note:

The NetSuite Billable Time [netsuite_billable_time] is created automatically when you activate the Time Entries (Time) standard export workflow. To show the custom field as columns on the Timesheet grid (Web application UI) or time card properties (Mobile app UI), contact SuiteProjects Pro Support. You will need to provide the internal ID for the NetSuite Billable Time custom field, which you can obtain from the custom field list (Administration > Global Settings > Custom Field), and clear the Hide on data entry forms box in the custom field properties.

TimeBill.tranDate

Task.date

—