Additional record mapping or filter configuration is required to integrate the template’s exports and imports with your Concur and NetSuite apps.
Note that all of your flows are disabled when first installed. After configuring the flows, you may enable them in your Flows dashboard or in Flow Builder with the Off/On toggle button. then run or schedule each flow.
Concur company to NetSuite customer
This integration flow syncs a Concur company as a NetSuite customer.
Applies to
- Concur Expense (Enhanced) – NetSuite Quickstart integration template
- Concur Expense (Best Practice) – NetSuite Quickstart integration template
Flow details
- Export source: Concur
- Import destination: NetSuite
- Built-in export: Get Concur company – get a company from Concur
- Built-in import: Import NetSuite customer – add or update a customer into NetSuite with configured custom field as the lookup identifier
Setup instructions
- Add subsidiary mapping to Import NetSuite customer.
- Configure mapping for Individual and Address Book: Replace All Lines in Import NetSuite customer.
Concur expense reports to NetSuite expense reports (Best Practice)
This integration flow syncs Concur expense reports as NetSuite expense reports for Standard Concur accounts by payment batch.
Applies to
- Concur Expense (Best Practice) – NetSuite Quickstart integration template
Flow details
- Export source: Concur
- Import destination: NetSuite
-
Built-in export: Get Concur payment batches – get all payment batches that are in open status from Concur
- Built-in preSavePage hook: ConcurPaymentrequestextractpro.js – parse links to batch files
- Built-in import: Import Concur payment batch – close the payment batches of Concur
- Built-in lookup: Get Concur payment batch file – get all payment batch files from Concur
- Built-in import: Import NetSuite expense reports – add (or ignore) expense reports into NetSuite with Exp. Rept. # as the lookup identifier field
Before you begin
The NetSuite Employee FirstName and LastName and the Concur User FirstName and LastName should be the same.
Setup instructions
- Configure static mapping for Category and Currency in Import NetSuite expense reports.
- Add subsidiary mapping to Import NetSuite expense reports.
- Configure the dynamic map for Employee (Name) in Import NetSuite expense reports.
Concur expense reports to NetSuite expense reports (Enhanced)
This integration flow syncs Concur expense reports as NetSuite expense reports for Professional Concur accounts by the Extract Method.
Applies to
- Concur Expense (Enhanced) – NetSuite Quickstart integration template
Flow details
- Export source: Concur
- Import destination: NetSuite
-
Built-in export: Get Concur extract definition details – get Concur extract definition details for expense
- Built-in preSavePage hook: ConcurExpenseReport.js – parse links to job files
- Built-in lookup: Get Concur extract files by job ID – get extract files from Concur
- Built-in import: Import NetSuite expense reports – add (or ignore) expense reports into NetSuite with Exp. Rept. # as the lookup identifier field
Before you begin
- The NetSuite Employee FirstName and LastName and the Concur User FirstName and LastName should be the same.
- Add the Definition ID field for the Expense to NetSuite.
Setup instructions
- Configure static mapping for Category, Department, Location, and Currency in Import NetSuite expense reports.
- Add subsidiary mapping to Import NetSuite expense reports.
- Configure the dynamic map for Employee (InternalId) in Import NetSuite expense reports.
Concur expense report images to NetSuite expense report images
This integration flow stores concur expense report images into NetSuite as expense report images for Professional and Standard Concur accounts.
Applies to
- Concur Expense (Best Practice) – NetSuite Quickstart integration template
- Concur Expense (Enhanced) – NetSuite Quickstart integration template
Flow details
- Export source: Concur
- Import destination: NetSuite
- Built-in export: Get Concur expense reports – get all expense reports from Concur that have been created since this flow last ran
- Built-in lookup: Get Concur expense report details by report id – get expense report details from Concur by report id
- Built-in lookup: Get Concur expense report image by entry image id – get expense report images from Concur by entry image id
- Built-in file transfer (download): Get Concur expense report image by image url – get all expense report image from Concur by image url
- Built-in file transfer (upload): Import NetSuite images as File Cabinet – add images into NetSuite
- Built-in import: Import NetSuite images into expense reports – attach images into NetSuite expense reports
Before you begin
- Expense reports should be the same in Concur and NetSuite.
- The Concur expense report ID should be stored as a Exp.Rept# in NetSuite expense reports.
Setup instructions
- Configure a dynamic map for Attach To Internal ID in Import NetSuite images into expense reports.
- Configure mapping for Attached Record Type in Import NetSuite images into expense reports according to your Concur setup.
Concur lists to NetSuite departments
This integration flow syncs Concur lists as NetSuite departments.
Lists are custom entities, or records, that you set up in Concur. You can create any corresponding NetSuite departments as lists and then associate them with your expenses. To build a list:
- Sign in to SAP Concur.
- From the Administration menu, select Expense > Expense admin.
- On the Expense admin page, click List management.
- At the List management page, you can add, update, or delete a list.
Applies to
- Concur Expense (Enhanced) – NetSuite Quickstart integration template
- Concur Expense (Best Practice) – NetSuite Quickstart integration template
Flow details
- Export source: Concur
- Import destination: NetSuite
- Built-in export: Get Concur lists – get all lists from Concur
- Built-in lookup: Get concur list item by list ID – get a list item from Concur by list ID
- Built-in import: Import NetSuite departments – add or ignore departments into NetSuite with configured custom field as the lookup identifier
Setup instructions
Configure filter rules in Get Concur lists. (The record.value shown below represents the name of the list created in Concur; the department records are inside the Concur list.)
Concur users to NetSuite employees
This integration flow syncs Concur users as NetSuite employees.
Applies to
- Concur Expense (Enhanced) – NetSuite Quickstart integration template
- Concur Expense (Best Practice) – NetSuite Quickstart integration template
Flow details
- Export source: Concur
- Import destination: NetSuite
- Built-in export: Get Concur users – get all users from Concur
- Built-in lookup: Get Concur Expense user's spend details by ID – get user's spend details from Concur Expense by ID
- Built-in lookup: Get Concur Expense approver by ID – get user (approver) details from Concur Expense details
- Built-in lookup: Get NetSuite employee (manager) details – get employee (manager) from NetSuite using email as identifier
- Built-in import: Import NetSuite manager (employees) – import posts employees (manager) to NetSuite
- Built-in import: Import NetSuite employees – add/update employees to NetSuite.
Setup instructions
Add Subsidiary mapping in Import NetSuite employees.
NetSuite departments to Concur list items
This integration flow syncs NetSuite departments as Concur list items.
Applies to
- Concur Expense (Enhanced) – NetSuite Quickstart integration template
- Concur Expense (Best Practice) – NetSuite Quickstart integration template
Flow details
- Export source: NetSuite
- Import destination: Concur
- Built-in export: Get NetSuite departments – get all departments from NetSuite
- Built-in lookup: Get Concur lists – get all lists from Concur
- Built-in import: Import Concur list items (create) – add or ignore list items into Concur with id as the lookup identifier
- Built-in import: Import Concur list items (update) – update list items into Concur with id as the lookup identifier
- Built-in import: Import NetSuite departments – update departments into NetSuite with id as the lookup identifier
Setup instructions
Configure filter rules in Get Concur lists. (The record.value shown below represents the name of the list created in Concur; the department records are inside the Concur list. See What are Concur lists?, above.)
NetSuite employees to Concur users
This integration flow syncs NetSuite employees as Concur users.
Applies to
- Concur Expense (Enhanced) – NetSuite Quickstart integration template
- Concur Expense (Best Practice) – NetSuite Quickstart integration template
Flow details
- Export source: NetSuite
- Import destination: Concur
- Built-in export: Get NetSuite employees – get all employees from NetSuite that have been modified since this flow last ran
- Built-in lookup: Get NetSuite supervisor details (employee) – get manager's record from NetSuite employees using supervisor ID as an identifier
- Built-in lookup: Get Concur Expense approver – check if approver record is present in Concur Expense users using email as identifier
- Built-in import: Import Concur Expense approver (update) – update the existing user in Concur Expense with manager permissions using managerConcurID field as identifier
- Built-in import: Import Concur Expense approver (create) – create a new record for approver as Concur Expense user
- Built-in lookup: Get Concur Expense user by email – get user from Concur Expense using email as an identifier
- Built-in lookup: Get Concur Expense user spend details by ID – get user roles for existing user in Concur Expense using user ID as identifier
- Built-in import: Import Concur Expense users – add/update users in Concur Expense using the userName as the lookup identifier
Before you begin
The NetSuite department name should be the same as the Concur List item name.
Setup instructions
- Configure hard coded mapping for Active, Value, Type, Entitlements, and CompanyID in Import Concur users.
- Configure static map for CtryCode in Import Concur users.