Employees (Vendors) Import Workflow

The Employees (Vendors) import workflow lets you:

Create new vendor records in NetSuite first and then import them into SuiteProjects Pro as employee records.
Update vendor records in NetSuite and use the NetSuite <> SuiteProjects Pro integration to update the corresponding employee record in SuiteProjects Pro.

You can also use the Vendors (Vendors) import workflow to import NetSuite vendor records into SuiteProjects Pro as vendor records. Both workflows can be used in conjunction. Additional setup is required to enable the Vendors (Vendors) import workflow, if the Employees (Vendors) import workflow is already enabled. See Setting up the Vendors (Vendors) Import Workflow.

Important:

NetSuite is the primary application for vendor records. Changes made to employee records in SuiteProjects Pro after the initial import are not exported back to NetSuite.

For information about workflow specific settings impacting this workflow, see Employees (Vendors) Import Workflow Settings.

For information about field mapping definitions for this workflow, see Employees (Vendors) Import Field Mapping Definition.

Requirements and Downstream Dependencies

Matching NetSuite vendor records and SuiteProjects Pro employee records must exist before you can export expense reports from SuiteProjects Pro to NetSuite as vendor bills.

Using the Vendors (Vendors) and Employees (Vendors) import workflows in conjunction enables you to import vendor bills or purchase orders from NetSuite into SuiteProjects Pro as purchase orders, which requires matching vendor records in both applications and to export expense reports from SuiteProjects Pro to NetSuite as vendor bills, which requires the associated employee record in SuiteProjects Pro being matched with a vendor record in NetSuite. See POs (Vendor Bills) Import Workflow, POs (Purchase Orders) Import Workflow and Expense Reports (Expense Reports) Export Workflow.

When using the Vendors (Vendors) and Employees (Vendors) import workflows in conjunction, use the SuiteProjects Pro: User or Vendor [custentity_oa_user_or_vendor] field on the vendor record in NetSuite to determine whether the vendor should be imported into SuiteProjects Pro as a vendor or as an employee (user).

Note:

You can only set the SuiteProjects Pro: User or Vendor [custentity_oa_user_or_vendor] on the vendor record in NetSuite if the following conditions are all met. The field is read-only otherwise.

The Expense Report – Vendor Bill Integration box is checked in the integration preferences.
Either the Vendor Bill to SuiteProjects Pro PO Integration box or the Enable SuiteProjects Pro Purchase Integration box is checked in the integration preferences.
The Export to SuiteProjects Pro [custentity_oa_export_to_openair] box is checked on the vendor record.

For more information about setting integration preferences, see Configuring Integration Preferences and Terminology Preferences in NetSuite.

Supported Features

Workflow Settings

Filters

Advanced Mapping

Real-Time

SuiteProjects Pro Within NetSuite

Monitored Fields

Check mark

Run the integration manually, use a scheduled integration run to create or update the SuiteProjects Pro employee record after you create or update the vendor record in NetSuite. See Running the Bulk Import and Export Integration on Demand and Scheduling the Integration to Run Automatically.
Setup the real-time integration to create or update the SuiteProjects Pro employee record when the Vendor form is saved in NetSuite. See Configuring Real-Time Record Import from NetSuite into SuiteProjects Pro.
View and edit the SuiteProjects Pro employee record from the NetSuite UI using the SuiteProjects Pro Within NetSuite (SuiteProjects Pro NetSuite Single Sign-On Integration) feature. See Enabling Access to SuiteProjects Pro From Within NetSuite.

Setting up the Employees (Vendors) Import Workflow

Use the following steps to set up the workflow.

To set up the Employees (Vendors) import workflow in NetSuite

(Optional) To mark new vendor records for export to SuiteProjects Pro by default:
1. In NetSuite, do one of the following:
  - Go to Setup > Company > General Preferences (Custom Preferences), if you are using the SuiteScript 1 versions of SuiteProjects Pro SRP Integration (Bundle ID 369637) bundle scripts.
  - Go to Customization > Lists, Records and Fields > Records > [View list forSuiteProjects Pro: Integration Settings] > [View SuiteProjects Pro Integration Settings Record] , if you are using the SuiteScript 2 versions of SuiteProjects Pro SRP Integration (Bundle ID 369637) bundle scripts.
2. Check the Export Vendors by Default box.
After you enable this preference, the Export to SuiteProjects Pro [custentity_oa_export_to_openair] box is checked by default when a user creates a new vendor record. Users with the relevant permissions can clear the box on individual records if required.

To set up the Employees (Vendors) import workflow in SuiteProjects Pro

In SuiteProjects Pro, go to Administration > NetSuite Connector.
Click the Tips button then NetSuite Connector Administration.

The NetSuite Connector administration form appears.
Check the Employees (Vendors) box under the Imports section.
Click Save then Close.
Go to Administration > NetSuite Connector > Mapping.
Click New workflow then Employees (Vendors).
Click Employees (Vendors) in the list of integration workflows.
Review the workflow settings impacting this workflow. For more information, see Employees (Vendors) Import Workflow Settings.
Modify the field mapping definition table for the Employees (Vendors) import workflow as required. See Mapping SuiteProjects Pro Fields and NetSuite Fields and Employees (Vendors) Import Field Mapping Definition.
Click the switch next to the workflow name to activate or to deactivate the workflow.
Click Save.
(Optional) Add the Employees (Vendors) import workflow to a workflow group and schedule it to run automatically. See Scheduling the Integration to Run Automatically.