Pre-requsites

Create a new role

  1. Create a new role in NetSuite using the following values.
FieldValue
NameWork 365
IDWork365
Center TypeEnter a value of your choice
Employee restrictionsNone – no default
Accessible SubsidiariesALL
Two Factor Authentication requiredNot required
Duration of trusted devicePer Session
  1. Apply the following permissions to the 'Work 365' role.
Record TypePermissionLevel
Transactions
Find TransactionView
InvoiceFull
Invoice Sales OrdersFull
Sales OrderEdit
Item FulfillmentCreate
Fulfill OrdersEdit
Lists
AccountsView
ClassesView
CurrencyView
CustomersFull
DepartmentsView
Employee RecordsView
EmployeesView
ItemsFull
LocationsView
Tax RecordsView
Tax SchedulesView
VendorsView
Setup
Accounting ListsView
CRM ListsView
Customer StatusFull
SOAP Web ServicesFul
  1. Save the role record & reopen it.
  2. Note the ID of the record from the URL.
  3. Assign the role to the integration user.

Create a custom field for Transaction Lines

Work 365 tracks the changes in NetSuite by storing the CRM record IDs of linked records. In order to achieve this, a new filed should be created on the Transaction Line record.

  1. Navigate to Customization -> List, Records & Fields -> Transaction Line Fields -> New
  2. Enter values for the following fields:
FieldValue
LabelWork 365 Reference
ID_work365_txnline_reference
TypeFree-Form Text
Store ValueYes
Applies ToChoose Sale Item
  1. Under Access -> Role, add the Work 365 Role created in Step #1.
    • Access Level = Edit
    • Level for Searching/Reporting Edit
  2. Save the record

Configuring the NetSuite Connector

  1. Open the Work 365 Integrations area by navigating to Administration → Admin Hub → Integrations → Add new
  2. Find the NetSuite connector under the Accounting Systems area and click the Create button.

General Section

FieldDescription
NameA name by which to identify this connector
EnvironmentThe target NetSuite environment type. When connecting to a production NetSuite endpoint, choose Production; for non-production endpoints use Sandbox
UsernameThe user id / login name of the integration user
PasswordThe password of the integration user

Properties Section

FieldDescription
Account IDThe account id associated with your NetSuite tenant. This is usually found in the URL when you login to NetSuite.
Role IDThe ID of the 'Work 365' role created as part of the pre-requisite stage.

Upon entering these fields, click on the Save button. This will redirect back to the connector page. Find and reopen the NetSuite connector that was just created.

FieldDescription
Default Income AccountIncome account to be used when creating new products in NetSuite.
Default Tax ScheduleTax Schedule to be used when creating products in NetSuite.
Default DepartmentNetSuite department used when creating invoice and invoice lines.
Default ClassThe default NetSuite classification when creating invoice and invoice lines.
Map Products usingDetermines which field in NetSuite should be used to map Products to Work 365. The Product ID field is used in Work 365 and maps to the field in NetSuite that is chosen in this selection.
Write In ProductThe default NetSuite product to which Work 365 invoice lines without Products are synced.
Enable BiDirectional SncKeeps the Work 365 invoice in sync with the NetSuite invoice. If true, pulls the invoice data back from NetSuite after sync. This allows any plugins in NetSuite (such as taxation) to perform their computations and the invoice in Work 365 is then updated with the net result of these computations. Note that this pull occurs only once, immediately after the sync. Changes made to NetSuite invoice at a later stage will not be synced.
Create Sales Order Linked InvoicesWhen true, links the NetSuite invoices to Sales Orders in NetSuite. For this option to work, the NetSuite Sales Order reference must be specified on the Billing Contract.
Set Invoice Line Description fromProvides options on how the invoice line description in NetSuite is set.

Payment Terms Mapping

This section provides a mechanism to map payment terms between Work 365 & the NetSuite environment being configured.

Product Class Mapping

This section provides a mechanism to map product classes between Work 365 & the NetSuite environment being configured.