Purchase Item Mapping Group

Use the Purchase Item mapping group to map information on purchase item records in SuiteProjects Pro with information on vendor bill line items in NetSuite. The mapping group supports filters.

For reference information and best practice guidelines, review the following topics:

References — Overview of record types in SuiteProjects Pro and NetSuite with links to the relevant reference material for information about fields available for mapping.
Default and Custom Filters — Overview of default filters and how to modify the default behavior, and custom filters. Custom filters are supported for this mapping group.
Default Field Mappings — Overview of default field mapping definitions including notes and best practice guidelines where relevant. Information imported by default includes task name, associated customer and project, start date, currency, and planned hours.
Additional Field Mappings — Best practice guidelines for custom field mapping definitions in this mapping group.

References

The following table gives reference information about the records and fields available for custom field mapping definition with links to the relevant reference material. See also Schema Reference Documentation.

NetSuite Record type [`SOAP object`]	SuiteProjects Pro Record Type [`table`]	Mapping Group [`Integration point`]
Purchase Order Item [`PurchaseOrderItem`] Schema: TransactionSearchRowBasic (2020.1)\|TransactionSearchRowBasic (2023.1) XSD: `TransactionSearchRowBasic` — platformCommon (2020.1)\|platformCommon (2023.1)	Purchase Item [`Purchase_item`] Data Dictionary: purchase_item	Purchase Item [`VENDORBILL_TO_PURCHASE_ITEM`]

NetSuite Record type [SOAP object]

SuiteProjects Pro Record Type [table]

Mapping Group [Integration point]

Purchase Order Item [PurchaseOrderItem]

Schema: TransactionSearchRowBasic (2020.1)|TransactionSearchRowBasic (2023.1)

XSD: TransactionSearchRowBasic — platformCommon (2020.1)|platformCommon (2023.1)

Purchase Item [Purchase_item]

Data Dictionary: purchase_item

Purchase Item [VENDORBILL_TO_PURCHASE_ITEM]

Default and Custom Filters

By default, vendor bill line item records are imported from NetSuite into SuiteProjects Pro as purchase items if the following conditions are met:

The vendor bill is imported from NetSuite into SuiteProjects Pro as a purchase order.
The vendor bill must reference a vendor.
The vendor bill line item must reference an item with a matching product record in SuiteProjects Pro.
The Export to SuiteProjects Pro [custcol_oa_export_to_openair] box is checked on the vendor bill line item in NetSuite.

Custom filters are supported for this mapping group. For more information about adding filter conditions, see Using Filters and Filter Definition.

NetSuite fields declared and used in filters in the Purchase Item mapping group should also be declared in the PO filters.

Default Field Mappings

The following table describes the default field mapping definitions for the Purchase Item mapping group tab.

NetSuite Field	SuiteProjects Pro Field	Notes
`=Transaction.internalId +"-" +Transaction.line`	`Purchase_item.netsuite_vendorbill_purchase_item_id__c`	When you import a new vendor bill line item from NetSuite into SuiteProjects Pro, SuiteProjects Pro stores the internal ID of the NetSuite vendor bill and the line ID number of the vendor bill line item in the NetSuite Vendor Bill ID [`netsuite_vendorbill_purchase_item_id`] custom field. This custom field is used to link the SuiteProjects Pro and NetSuite records for future updates and matching record associations.
`Transaction.custcol_oa_po_line_tax`	`Purchase_item.netsuite_purchase_item_tax__c`	Tax information for each vendor bill line item imports to the purchase item in SuiteProjects Pro. The total tax on the SuiteProjects Pro purchase order is calculated based on the tax for each purchase item.
Looked up SuiteProjects Pro field value — `name` of SuiteProjects Pro product with `netsuite_product_id` equal to the NetSuite field `Transaction.item`	`Purchase_item.name`	Name of the product
Looked up SuiteProjects Pro field value — `id` of SuiteProjects Pro product with `netsuite_product_id` equal to the NetSuite field `Transaction.item`	`Purchase_item.product_id`	Internal ID of the product
Looked up SuiteProjects Pro field value — `id` of SuiteProjects Pro project with `netsuite_project_id` equal to either: NetSuite field `Transaction.custbody_oa_purchase_project_id` on the vendor bill header NetSuite field `Transaction.entity` on the vendor bill line item	`Purchase_item.project_id`	The project can be referenced either in the vendor bill header or in each vendor bill line item in NetSuite. Purchase order header — The NetSuite Project ID [`custbody_oa_purchase_project_id`] custom field holds the internal ID of the project in NetSuite (copied from the `shipTo` field. Purchase order line item — The Project field holds the internal ID of the project in NetSuite.
Looked up SuiteProjects Pro field value — `id` of SuiteProjects Pro customer associated with project with `netsuite_project_id` equal to the NetSuite field `Transaction.custbody_oa_purchase_project_id`	`Purchase_item.customer_id`	—
Looked up SuiteProjects Pro field value — `id` of SuiteProjects Pro request item record created by the integration and associated with the SuiteProjects Pro purchase item	`Purchase_item.request_item_id`	—
`Transaction.custcol_oa_po_rate`	`Purchase_item.cost`	The SuiteProjects Pro Rate [`custcol_oa_po_rate`] custom field value is sourced from the Rate on the vendor bill line item in NetSuite and imports to the Price and Approved Price fields on the purchase item record in SuiteProjects Pro.
`Transaction.custcol_oa_po_rate`	`Purchase_item.approved_cost`	The SuiteProjects Pro Rate [`custcol_oa_po_rate`] custom field value is sourced from the Rate on the vendor bill line item in NetSuite and imports to the Price and Approved Price fields on the purchase item record in SuiteProjects Pro.
`="each"`	`Purchase_item.um`	—
`ABS(Transaction.quantity)`	`Purchase_item.quantity`	The Quantity must be positive in the SuiteProjects Pro purchase item record.
`Transaction.fxAmount \|\| Transaction.amount`	`Purchase_item.total`	If the Quantity is negative on the vendor bill line item, the Total is adjusted automatically so that `quantity ×cost` and `total` are both negative or both positive. The foreign currency Amount [ `fxAmount`] or base currency Amount [ `amount`] value on the vendor bill line item is used.
Looked up SuiteProjects Pro field value — `id` of SuiteProjects Pro purchase request record created by the integration and associated with the SuiteProjects Pro purchase item	`Purchase_item.purchaserequest_id`	—
Looked up SuiteProjects Pro field value If the purchaser integration is enabled, `id` of the SuiteProjects Pro employee with `user.netsuite_user_id` equal to `Transaction.createdBy`, if the employee record is associated with a purchaser record with NetSuite Purchase Order Integration purchaser [`netsuite_purchaser`] box checked. Otherwise, `user_id` of the SuiteProjects Pro purchaser record with NetSuite Purchase Order Integration purchaser [`netsuite_purchaser`] box checked.	`Purchase_item.user_id`	Internal ID of the employee associated with the purchaser in SuiteProjects Pro. If the Enable purchaser integration box is checked on the Employees (Employees) import workflow settings form, the employee who created the purchase order in NetSuite is set as the Purchaser on the purchase item in SuiteProjects Pro. Matching records for this employee must exist in SuiteProjects Pro and NetSuite, and the employee must be associated with a purchaser record marked as a NetSuite purchaser in SuiteProjects Pro. See Enable purchaser integration. Otherwise, a purchaser designated as the universal NetSuite purchaser is used.
`Transaction.currency`	`Purchase_item.currency`	Active and visible only if the Multicurrency feature is enabled for your SuiteProjects Pro account . Multiple currency — The Currency on the purchase item record in SuiteProjects Pro is set to the Currency on the vendor bill line item in NetSuite.
Looked up SuiteProjects Pro field value — `id` of SuiteProjects Pro purchase order record created to match the vendor bill	`Purchase_item.purchaseorder_id`	—
Looked up SuiteProjects Pro field value — `id` of SuiteProjects Pro vendor record with `netsuite_vendor_id` equal to the NetSuite field `Transaction.entity` on the vendor bill header	`Purchase_item.vendor_id`	—
Looked up SuiteProjects Pro field value — `id` of SuiteProjects Pro purchaser	`Purchase_item.purchaser_id`	Internal ID of the purchaser specified for the purchase order integration in SuiteProjects Pro.
`Transaction.tranDate`	`Purchase_item.date`	—
`Transaction.billable`	`Purchase_item.netsuite_vb_billable__c`	If the Billable box is checked on the vendor bill line item in NetSuite, the NetSuite vendor bill line billable [`netsuite_vb_billable`] box is checked on the SuiteProjects Pro purchase item record.

NetSuite Field

Direction

SuiteProjects Pro Field

Notes

=Transaction.internalId +"-" +Transaction.line

Purchase_item.netsuite_vendorbill_purchase_item_id__c

When you import a new vendor bill line item from NetSuite into SuiteProjects Pro, SuiteProjects Pro stores the internal ID of the NetSuite vendor bill and the line ID number of the vendor bill line item in the NetSuite Vendor Bill ID [netsuite_vendorbill_purchase_item_id] custom field. This custom field is used to link the SuiteProjects Pro and NetSuite records for future updates and matching record associations.

Transaction.custcol_oa_po_line_tax

Purchase_item.netsuite_purchase_item_tax__c

Tax information for each vendor bill line item imports to the purchase item in SuiteProjects Pro. The total tax on the SuiteProjects Pro purchase order is calculated based on the tax for each purchase item.

Looked up SuiteProjects Pro field value — name of SuiteProjects Pro product with netsuite_product_id equal to the NetSuite field Transaction.item

Purchase_item.name

Name of the product

Looked up SuiteProjects Pro field value — id of SuiteProjects Pro product with netsuite_product_id equal to the NetSuite field Transaction.item

Purchase_item.product_id

Internal ID of the product

Looked up SuiteProjects Pro field value — id of SuiteProjects Pro project with netsuite_project_id equal to either:

NetSuite field Transaction.custbody_oa_purchase_project_id on the vendor bill header
NetSuite field Transaction.entity on the vendor bill line item

Purchase_item.project_id

The project can be referenced either in the vendor bill header or in each vendor bill line item in NetSuite.

Purchase order header — The NetSuite Project ID [custbody_oa_purchase_project_id] custom field holds the internal ID of the project in NetSuite (copied from the shipTo field.
Purchase order line item — The Project field holds the internal ID of the project in NetSuite.

Looked up SuiteProjects Pro field value — id of SuiteProjects Pro customer associated with project with netsuite_project_id equal to the NetSuite field Transaction.custbody_oa_purchase_project_id

Purchase_item.customer_id

—

Looked up SuiteProjects Pro field value — id of SuiteProjects Pro request item record created by the integration and associated with the SuiteProjects Pro purchase item

Purchase_item.request_item_id

—

Transaction.custcol_oa_po_rate

Purchase_item.cost

The SuiteProjects Pro Rate [custcol_oa_po_rate] custom field value is sourced from the Rate on the vendor bill line item in NetSuite and imports to the Price and Approved Price fields on the purchase item record in SuiteProjects Pro.

Transaction.custcol_oa_po_rate

Purchase_item.approved_cost

="each"

Purchase_item.um

—

ABS(Transaction.quantity)

Purchase_item.quantity

The Quantity must be positive in the SuiteProjects Pro purchase item record.

Transaction.fxAmount || Transaction.amount

Purchase_item.total

If the Quantity is negative on the vendor bill line item, the Total is adjusted automatically so that quantity ×cost and total are both negative or both positive. The foreign currency Amount [ fxAmount] or base currency Amount [ amount] value on the vendor bill line item is used.

Looked up SuiteProjects Pro field value — id of SuiteProjects Pro purchase request record created by the integration and associated with the SuiteProjects Pro purchase item

Purchase_item.purchaserequest_id

—

Looked up SuiteProjects Pro field value

If the purchaser integration is enabled, id of the SuiteProjects Pro employee with user.netsuite_user_id equal to Transaction.createdBy, if the employee record is associated with a purchaser record with NetSuite Purchase Order Integration purchaser [netsuite_purchaser] box checked.
Otherwise, user_id of the SuiteProjects Pro purchaser record with NetSuite Purchase Order Integration purchaser [netsuite_purchaser] box checked.

Purchase_item.user_id

Internal ID of the employee associated with the purchaser in SuiteProjects Pro.

If the Enable purchaser integration box is checked on the Employees (Employees) import workflow settings form, the employee who created the purchase order in NetSuite is set as the Purchaser on the purchase item in SuiteProjects Pro. Matching records for this employee must exist in SuiteProjects Pro and NetSuite, and the employee must be associated with a purchaser record marked as a NetSuite purchaser in SuiteProjects Pro. See Enable purchaser integration.
Otherwise, a purchaser designated as the universal NetSuite purchaser is used.

Transaction.currency

Purchase_item.currency

Active and visible only if the Multicurrency feature is enabled for your SuiteProjects Pro account

Multiple currency — The Currency on the purchase item record in SuiteProjects Pro is set to the Currency on the vendor bill line item in NetSuite.

Looked up SuiteProjects Pro field value — id of SuiteProjects Pro purchase order record created to match the vendor bill

Purchase_item.purchaseorder_id

—

Looked up SuiteProjects Pro field value — id of SuiteProjects Pro vendor record with netsuite_vendor_id equal to the NetSuite field Transaction.entity on the vendor bill header

Purchase_item.vendor_id

—

Looked up SuiteProjects Pro field value — id of SuiteProjects Pro purchaser

Purchase_item.purchaser_id

Internal ID of the purchaser specified for the purchase order integration in SuiteProjects Pro.

Transaction.tranDate

Purchase_item.date

—

Transaction.billable

Purchase_item.netsuite_vb_billable__c

If the Billable box is checked on the vendor bill line item in NetSuite, the NetSuite vendor bill line billable [netsuite_vb_billable] box is checked on the SuiteProjects Pro purchase item record.

Additional Field Mappings

Important:

Review the following guidelines

You should contact your SuiteProjects Pro Professional Services representative if you need to make changes to your integration configuration and field mapping definitions.
For advanced mapping usage and best practice guidelines, see Advanced Field Mapping Definition.
Familiarize yourself with the NetSuite and SuiteProjects Pro technical documentation before attempting to set field mapping definitions using the advanced notation — See Schema Reference Documentation.

Review the following guidelines:

NetSuite fields declared and used in advanced mappings in the Purchase Item mapping group should also be declared in the PO mapping group.