Integration Points Exporting SuiteProjects Pro Information to NetSuite

Note:

This help topic is provided for reference only. Integration point tags were used in the legacy advanced settings notation but are no longer required.

When you click Show relevant old advanced mapping in the Tips menu, the popup window shows your filters and field mapping definitions in the legacy advanced settings notation.

The following table lists the integration point you can use to export SuiteProjects Pro records to NetSuite in execution order. The table also indicates the corresponding integration workflow and the equivalent mapping group on the Mapping tab in SuiteProjects Pro.

Use these integration points between a <PUSH> opening tag and a </PUSH> closing tag.
All field mapping information for an integration point in a specific direction must be defined between the opening tag and the closing tag for this integration point. For example, between <OA_CUSTOMER_TO_NS_CUSTOMER> and </OA_CUSTOMER_TO_NS_CUSTOMER>.
The integration workflow must be enabled before you can define custom field mappings and filters for an integration point.
Integration points support field mapping definitions and filters, unless otherwise specified.

Integration Point	Workflow	Mapping Group	Additional information
`OA_CUSTOMER_TO_NS_CUSTOMER`	Customers (Customers)	Customer	—
`PROJECT_TO_JOB`	Projects (Projects)	Project	—
`PURCHASE_REQUEST_TO_PURCHASE_REQUISITION`	Purchase request (Purchase requisition)	Purchase request	Used to export SuiteProjects Pro purchase requests as NetSuite purchase requisitions.
`PURCHASE_REQUEST_ITEM_TO_PURCHASE_REQUISITION_ITEM`	Purchase request (Purchase requisition)	Request item	Used to export SuiteProjects Pro purchase request items as line items on NetSuite purchase requisitions. Does not support filters.
`EXPENSE_REP_TO_EXPENSE_REP`	Expense Reports (Expense Reports)	Expense Report	Can be used to define filters for the EXPENSE_REP_TO_VENDORBILL integration point.
`EXPENSE_REP_TO_VENDORBILL`	Expense Reports (Expense Reports)	Vendor Bill	Used to export SuiteProjects Pro expense reports as NetSuite vendor bill headers. Does not support filters. Can use filters defined for the EXPENSE_REP_TO_VENDORBILL integration point.
`EXPENSE_REP_LINE`	Expense Reports (Expense Reports)	Expense Line	Used to export SuiteProjects Pro receipts as NetSuite expense lines. Does not support filters. This is to prevent inconsistent expense reports in NetSuite and SuiteProjects Pro. DO NOT map the nonreimbursable SuiteProjects Pro field. This would cause significant impact downstream when rebilling expenses on invoices.
`EXPENSE_REP_LINE_TO_VENDORBILL_LINE`	Expense Reports (Expense Reports)	Vendor Bill Line	Used to export SuiteProjects Pro receipts as NetSuite vendor bill lines. Does not support filters.
`EXPENSE_REP_LINE_TAX`	Expense Reports (Expense Reports)	Tax Line	Used to export SuiteProjects Pro receipts as NetSuite tax lines (related to the tax_location table). Does not support filters.
`INVOICE_TO_INVOICE`	Invoices (Invoices)	Invoice	Used to export invoice header information.
`INVOICE_PROJECT`	Invoices (Invoices)	Project	Used to export SuiteProjects Pro project information as NetSuite invoice header information. Requires the One project per invoice Invoices application setting to be enabled (Administration > Application Settings > Invoices > Other settings). Does not support filters.
`INVOICE_LINE`	Invoices (Invoices)	Invoice Line	Used to export SuiteProjects Pro charges as line items on NetSuite invoices. Does not support filters.
`INVOICE_EXPENSE_LINE`	Invoices (Invoices)	Expense Line	Used to export SuiteProjects Pro expense item charges as billable expense lines on NetSuite invoices. Can be used to export SuiteProjects Pro expense item charges created from expense reports exported to NetSuite as expense reports or vendor bills. If an expense charge was created manually in SuiteProjects Pro, it can only be exported to NetSuite if there is a service assigned to it. It will be exported using the `INVOICE_LINE` integration point and will display as a line item (service charge) instead of a billable expense line on the NetSuite invoice. Does not support filters.
`INVOICE_PURCHASE_LINE`	Invoices (Invoices)	Purchase Line	Used to export SuiteProjects Pro product charges as NetSuite line items. Can be used to include purchase item information to the NetSuite line item. Does not support filters.
`INVOICE_BILLABLE_ITEM_LINE`	Invoices (Invoices)	Bill Line	Used to export SuiteProjects Pro product charges as NetSuite billable items lines when SuiteProjects Pro charges are created from NetSuite vendor bill lines imported into SuiteProjects Pro as purchase items. Can be used to export charge information to the NetSuite billable items lines. Used to rebill NetSuite vendor bills to the end customer through SuiteProjects Pro when at least one of the following conditions applies: The NetSuite vendor bill line billable box (custom field) on the Purchase Order form in SuiteProjects Pro is NOT checked — the vendor bill is NOT marked billable in NetSuite. The Disable vendor bill linkage on invoices in NetSuite integration setting is enabled on the NetSuite Connector administration form. Does not support filters.
`INVOICE_PURCHASE_VB_LINE`	Invoices (Invoices)	Vendor Bill Line	Used to export SuiteProjects Pro product charges as NetSuite billable items lines when SuiteProjects Pro charges are created from NetSuite vendor bill lines imported into SuiteProjects Pro as purchase items. Can be used to export purchase item information, including any information from the original NetSuite vendor bill line, to the NetSuite billable line items. Used to rebill NetSuite vendor bills when both the following condition apply: The NetSuite vendor bill line billable box (custom field) on the Purchase Order form in SuiteProjects Pro is checked — the vendor bill is marked billable in NetSuite. The Disable vendor bill linkage on invoices in NetSuite integration setting is NOT enabled on the NetSuite Connector administration form. Must not be used to export SuiteProjects Pro expense item charges created from expense reports exported to NetSuite as vendor bills. Use `INVOICE_EXPENSE_LINE` instead. Does not support filters.
`INVOICE_LINE_TIME_GROUP_BY`	Invoices (Invoices)	Group by Time	Used only together with the Customer POs (Sales Order) import integration workflow and if the Enable charges to map to NetSuite description items workflow setting is enabled. Used to export SuiteProjects Pro time charges (for example, hourly charges) as NetSuite description line items on NetSuite invoices. If the Combine charges by service on invoices workflow setting is enabled, all SuiteProjects Pro time charges, including time charges that are not associated with a sales order, are grouped under one description line item on the NetSuite invoice. Does not support filters.
`INVOICE_LINE_OTHER_TIME_GROUP_BY`	Invoices (Invoices)	Group by Other	Used only together with the Customer POs (Sales Order) import integration workflow and if the Enable charges to map to NetSuite description items workflow setting is enabled. Used to export SuiteProjects Pro other charges (for example, daily charges) as NetSuite description line items on NetSuite invoices. If the Combine charges by service on invoices workflow setting is enabled, all SuiteProjects Pro other charges, including other charges that are not associated with a sales order, are grouped under one description line item on the NetSuite invoice. Does not support filters.
`INVOICE_LINE_FIXED_FEE_GROUP_BY`	Invoices (Invoices)	Group by Fee	Used only together with the Customer POs (Sales Order) import integration workflow and if the Enable charges to map to NetSuite description items workflow setting is enabled. Used to export SuiteProjects Pro fixed fee charges as NetSuite description line items on NetSuite invoices. If the Combine charges by service on invoices workflow setting is enabled, all SuiteProjects Pro fixed fee charges, including fixed feecharges that are not associated with a sales order, are grouped under one description line item on the NetSuite invoice. Does not support filters.
`TIMESHEET`	Time Entries (Time)	Timesheet	Used to export SuiteProjects Pro timesheets as NetSuite time entries
`TIMEENTRY_TO_TIMEBILL`	Time Entries (Time)	Time Entry	Used to export SuiteProjects Pro time entries as NetSuite time entries.
`REVENUE_TO_JOURNAL`	Recognition Transactions (Revenue Recognition Transactions)	Recognition Transaction	Used to export information from SuiteProjects Pro revenue recognition transactions as header information on NetSuite journal entries.
`REVENUE_PURCHASE_TO_JOURNAL`	Recognition Transactions (Revenue Recognition Transactions)	Purchases Revenue Recognition	Used to export information from SuiteProjects Pro revenue recognition transactions as header information on NetSuite journal entries when revenue recognition transactions are created from SuiteProjects Pro purchases revenue recognition rules. Should be used only if you need to export purchase item information to the NetSuite journal entry header (if the `fulfillment_id` field on revenue recognition transactions has a non-null value).
`JOURNAL_LINE`	Recognition Transactions (Revenue Recognition Transactions)	Journal Entry Line	Used to export information from SuiteProjects Pro revenue recognition transactions as journal entry lines on NetSuite journal entries. Does not support filters.
`JOURNAL_LINE_CREDIT_PURCHASE`	Recognition Transactions (Revenue Recognition Transactions)	Credit Purchase Journal Entry Line	Used to export information from SuiteProjects Pro revenue recognition transactions as credit journal entry lines on NetSuite journal entries when revenue recognition transactions are created from SuiteProjects Pro purchases revenue recognition rules. Should be used only if you need to export purchase item information to the NetSuite journal entry line (if the `fulfillment_id` field on revenue recognition transactions has a non-null value). Does not support filters.
`JOURNAL_LINE_CREDIT_PURCHASE`	Recognition Transactions (Revenue Recognition Transactions)	Credit Purchase Journal Entry Line	Used to export information from SuiteProjects Pro revenue recognition transactions as credit journal entry lines on NetSuite journal entries when revenue recognition transactions are created from SuiteProjects Pro purchases revenue recognition rules. Should be used only if you need to export purchase item information to the NetSuite journal entry line (if the `fulfillment_id` field on revenue recognition transactions has a non-null value). Does not support filters.
`JOURNAL_LINE_DEBIT_PURCHASE`	Recognition Transactions (Revenue Recognition Transactions)	Debit Purchase Journal Entry Line	Used to export information from SuiteProjects Pro revenue recognition transactions as debit journal entry lines on NetSuite journal entries when revenue recognition transactions are created from SuiteProjects Pro purchases revenue recognition rules. Should be used only if you need to export purchase item information to the NetSuite journal entry line (if the `fulfillment_id` field on revenue recognition transactions has a non-null value). Does not support filters.
`JOURNAL_LINE_CREDIT`	Recognition Transactions (Revenue Recognition Transactions)	Credit Journal Entry Line	Used to export information from SuiteProjects Pro revenue recognition transactions as credit journal entry lines on NetSuite journal entries (income account or revenue). Does not support filters.
`JOURNAL_LINE_DEBIT`	Recognition Transactions (Revenue Recognition Transactions)	Debit Journal Entry Line	Used to export information from SuiteProjects Pro revenue recognition transactions as debit journal entry lines on NetSuite journal entries (deferred revenue ). Does not support filters.
`CREDIT_TO_CREDIT_MEMO`	Send SuiteProjects Pro Credit (negative invoice) as NetSuite credit memo	SuiteProjects Pro Credit (negative invoice)	Used to export SuiteProjects Pro invoices with a negative total amount as NetSuite credit memos. Does not support filters.
`PR_TASK_TO_OPP_ITEM`	WBS (Opportunity)	Task	Used to export SuiteProjects Pro project tasks with manually entered billing and cost projections as line items on NetSuite opportunities. Does not support filters.
`PTA_JOB_CODE_TO_OPP_ITEM`	WBS (Opportunity)	Task assignment	Used to export SuiteProjects Pro project task assignments with calculated billing and cost projections as line items on NetSuite opportunities. Does not support filters.

Integration Point

Workflow

Mapping Group

Additional information

OA_CUSTOMER_TO_NS_CUSTOMER

Customers (Customers)

Customer

—

PROJECT_TO_JOB

Projects (Projects)

Project

—

PURCHASE_REQUEST_TO_PURCHASE_REQUISITION

Purchase request (Purchase requisition)

Purchase request

Used to export SuiteProjects Pro purchase requests as NetSuite purchase requisitions.

PURCHASE_REQUEST_ITEM_TO_PURCHASE_REQUISITION_ITEM

Purchase request (Purchase requisition)

Request item

Used to export SuiteProjects Pro purchase request items as line items on NetSuite purchase requisitions.
Does not support filters.

EXPENSE_REP_TO_EXPENSE_REP

Expense Reports (Expense Reports)

Expense Report

Can be used to define filters for the EXPENSE_REP_TO_VENDORBILL integration point.

EXPENSE_REP_TO_VENDORBILL

Expense Reports (Expense Reports)

Vendor Bill

Used to export SuiteProjects Pro expense reports as NetSuite vendor bill headers.
Does not support filters. Can use filters defined for the EXPENSE_REP_TO_VENDORBILL integration point.

EXPENSE_REP_LINE

Expense Reports (Expense Reports)

Expense Line

Used to export SuiteProjects Pro receipts as NetSuite expense lines.
Does not support filters. This is to prevent inconsistent expense reports in NetSuite and SuiteProjects Pro.
DO NOT map the nonreimbursable SuiteProjects Pro field. This would cause significant impact downstream when rebilling expenses on invoices.

EXPENSE_REP_LINE_TO_VENDORBILL_LINE

Expense Reports (Expense Reports)

Vendor Bill Line

Used to export SuiteProjects Pro receipts as NetSuite vendor bill lines.
Does not support filters.

EXPENSE_REP_LINE_TAX

Expense Reports (Expense Reports)

Tax Line

Used to export SuiteProjects Pro receipts as NetSuite tax lines (related to the tax_location table).
Does not support filters.

INVOICE_TO_INVOICE

Invoices (Invoices)

Invoice

Used to export invoice header information.

INVOICE_PROJECT

Invoices (Invoices)

Project

Used to export SuiteProjects Pro project information as NetSuite invoice header information.
Requires the One project per invoice Invoices application setting to be enabled (Administration > Application Settings > Invoices > Other settings).
Does not support filters.

INVOICE_LINE

Invoices (Invoices)

Invoice Line

Used to export SuiteProjects Pro charges as line items on NetSuite invoices.
Does not support filters.

INVOICE_EXPENSE_LINE

Invoices (Invoices)

Expense Line

Used to export SuiteProjects Pro expense item charges as billable expense lines on NetSuite invoices.
Can be used to export SuiteProjects Pro expense item charges created from expense reports exported to NetSuite as expense reports or vendor bills.
If an expense charge was created manually in SuiteProjects Pro, it can only be exported to NetSuite if there is a service assigned to it. It will be exported using the INVOICE_LINE integration point and will display as a line item (service charge) instead of a billable expense line on the NetSuite invoice.
Does not support filters.

INVOICE_PURCHASE_LINE

Invoices (Invoices)

Purchase Line

Used to export SuiteProjects Pro product charges as NetSuite line items.
Can be used to include purchase item information to the NetSuite line item.
Does not support filters.

INVOICE_BILLABLE_ITEM_LINE

Invoices (Invoices)

Bill Line

Used to export SuiteProjects Pro product charges as NetSuite billable items lines when SuiteProjects Pro charges are created from NetSuite vendor bill lines imported into SuiteProjects Pro as purchase items.
Can be used to export charge information to the NetSuite billable items lines.
Used to rebill NetSuite vendor bills to the end customer through SuiteProjects Pro when at least one of the following conditions applies:
- The NetSuite vendor bill line billable box (custom field) on the Purchase Order form in SuiteProjects Pro is NOT checked — the vendor bill is NOT marked billable in NetSuite.
- The Disable vendor bill linkage on invoices in NetSuite integration setting is enabled on the NetSuite Connector administration form.
Does not support filters.

INVOICE_PURCHASE_VB_LINE

Invoices (Invoices)

Vendor Bill Line

Used to export SuiteProjects Pro product charges as NetSuite billable items lines when SuiteProjects Pro charges are created from NetSuite vendor bill lines imported into SuiteProjects Pro as purchase items.
Can be used to export purchase item information, including any information from the original NetSuite vendor bill line, to the NetSuite billable line items.
Used to rebill NetSuite vendor bills when both the following condition apply:
- The NetSuite vendor bill line billable box (custom field) on the Purchase Order form in SuiteProjects Pro is checked — the vendor bill is marked billable in NetSuite.
- The Disable vendor bill linkage on invoices in NetSuite integration setting is NOT enabled on the NetSuite Connector administration form.
Must not be used to export SuiteProjects Pro expense item charges created from expense reports exported to NetSuite as vendor bills. Use INVOICE_EXPENSE_LINE instead.
Does not support filters.

INVOICE_LINE_TIME_GROUP_BY

Invoices (Invoices)

Group by Time

Used only together with the Customer POs (Sales Order) import integration workflow and if the Enable charges to map to NetSuite description items workflow setting is enabled.
Used to export SuiteProjects Pro time charges (for example, hourly charges) as NetSuite description line items on NetSuite invoices.
If the Combine charges by service on invoices workflow setting is enabled, all SuiteProjects Pro time charges, including time charges that are not associated with a sales order, are grouped under one description line item on the NetSuite invoice.
Does not support filters.

INVOICE_LINE_OTHER_TIME_GROUP_BY

Invoices (Invoices)

Group by Other

Used only together with the Customer POs (Sales Order) import integration workflow and if the Enable charges to map to NetSuite description items workflow setting is enabled.
Used to export SuiteProjects Pro other charges (for example, daily charges) as NetSuite description line items on NetSuite invoices.
If the Combine charges by service on invoices workflow setting is enabled, all SuiteProjects Pro other charges, including other charges that are not associated with a sales order, are grouped under one description line item on the NetSuite invoice.
Does not support filters.

INVOICE_LINE_FIXED_FEE_GROUP_BY

Invoices (Invoices)

Group by Fee

Used only together with the Customer POs (Sales Order) import integration workflow and if the Enable charges to map to NetSuite description items workflow setting is enabled.
Used to export SuiteProjects Pro fixed fee charges as NetSuite description line items on NetSuite invoices.
If the Combine charges by service on invoices workflow setting is enabled, all SuiteProjects Pro fixed fee charges, including fixed feecharges that are not associated with a sales order, are grouped under one description line item on the NetSuite invoice.
Does not support filters.

TIMESHEET

Time Entries (Time)

Timesheet

Used to export SuiteProjects Pro timesheets as NetSuite time entries

TIMEENTRY_TO_TIMEBILL

Time Entries (Time)

Time Entry

Used to export SuiteProjects Pro time entries as NetSuite time entries.

REVENUE_TO_JOURNAL