Other Records Created or Updated by the POs (Purchase Orders) Import Workflow

The POs (Purchase Orders) import workflow also creates purchase request, request item and fulfillment records. Mappings are not available for these on the NetSuite Connector page in SuiteProjects Pro and cannot be modified.

Purchase Requests

The following table describes the information added to the purchase request records created for each purchase order line item imported into SuiteProjects Pro.

NetSuite Field	SuiteProjects Pro Field	Notes
`Transaction.internalId`	`Purchaserequest.netsuite_purchaserequest_id__c`	When the integration creates a new purchase request record in SuiteProjects Pro, SuiteProjects Pro stores the internal ID of the NetSuite purchase order in the NetSuite Purchase Order ID [`netsuite_purchaserequest_id`] custom field. This custom field is used to link the SuiteProjects Pro and NetSuite records for future updates and matching record associations.
`Transaction.tranId`	`Purchaserequest.netsuite_purchaserequest_tranid__c`	When the integration creates a new purchase request record in SuiteProjects Pro, SuiteProjects Pro stores the transaction ID of the NetSuite purchase order line item in the NetSuite Purchase Order Number [`netsuite_purchaserequest_tranid`] custom field. This custom field is used to link the SuiteProjects Pro and NetSuite records for future updates and matching record associations.
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 purchase order header NetSuite field `Transaction.entity` on the purchase order line item	`Purchaserequest.project_id`	The project can be referenced either in the purchase order header or in each purchase order 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`	`Purchaserequest.customer_id`	—
`Transaction.tranDate`	`Purchaserequest.date`	—
`Transaction.tranDate`	`Purchaserequest.date_submitted`	—
`Transaction.dueDate` on the purchase order header, if set. `0000-00-00`, otherwise	`Purchaserequest.date_required`	—
`="NS-"`	`Purchaserequest.prefix`	The prefix part of the PR # is `NS-` to identify purchase requests imported from NetSuite. If the Map NetSuite transaction number to SuiteProjects Pro number when importing vendor bills or purchase orders box is checked on the NetSuite Connector administration form in SuiteProjects Pro, the PO # on the purchase order in NetSuite is used to generate the prefix and number part of the PR #. See Map NetSuite transaction number to SuiteProjects Pro number when importing vendor bills or purchase orders.
`Transaction.tranId` generated automatically in SuiteProjects Pro	`Purchaserequest.number`	By default, the number part of the PR # on the SuiteProjects Pro purchase request record is generated automatically when the record is created. If the Map NetSuite transaction number to SuiteProjects Pro number when importing vendor bills or purchase orders box is checked on the NetSuite Connector administration form in SuiteProjects Pro, the PO # on the purchase order in NetSuite is used to generate the prefix and number part of the PR #. See Map NetSuite transaction number to SuiteProjects Pro number when importing vendor bills or purchase orders.
`="NS-" +Transaction.tranId +"-" +Transaction.line` `="NS-" +<generated PO number> +"-" +Transaction.line`	`Purchaserequest.name`	The default mapping definitions for `Purchaserequest.prefix` (the prefix part of the PR #), `Purchaserequest.number` (the number part of the PR #), and the line number are used to generate the PR # [`Purchaseorder.name`].
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.	`Purchaserequest.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 Requester on the purchase request 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`	`Purchaserequest.currency`	Active and visible only if the Multicurrency feature is enabled for your SuiteProjects Pro account . Multiple currency — The Currency on the purchase request record in SuiteProjects Pro is set to the Currency on the purchase order line item in NetSuite.
`Transaction.memo`	`Purchaserequest.notes`	—
`="A"`	`Purchaserequest.approval_status`
<current date>	`Purchaserequest.date_approved`	[Initial only]

NetSuite Field

Direction

SuiteProjects Pro Field

Notes

Transaction.internalId

Purchaserequest.netsuite_purchaserequest_id__c

When the integration creates a new purchase request record in SuiteProjects Pro, SuiteProjects Pro stores the internal ID of the NetSuite purchase order in the NetSuite Purchase Order ID [netsuite_purchaserequest_id] custom field. This custom field is used to link the SuiteProjects Pro and NetSuite records for future updates and matching record associations.

Transaction.tranId

Purchaserequest.netsuite_purchaserequest_tranid__c

When the integration creates a new purchase request record in SuiteProjects Pro, SuiteProjects Pro stores the transaction ID of the NetSuite purchase order line item in the NetSuite Purchase Order Number [netsuite_purchaserequest_tranid] custom field. This custom field is used to link the SuiteProjects Pro and NetSuite records for future updates and matching record associations.

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 purchase order header
NetSuite field Transaction.entity on the purchase order line item

Purchaserequest.project_id

The project can be referenced either in the purchase order header or in each purchase order 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

Purchaserequest.customer_id

—

Transaction.tranDate

Purchaserequest.date

—

Transaction.tranDate

Purchaserequest.date_submitted

—

Transaction.dueDate on the purchase order header, if set.
0000-00-00, otherwise

Purchaserequest.date_required

—

="NS-"

Purchaserequest.prefix

The prefix part of the PR # is NS- to identify purchase requests imported from NetSuite.

If the Map NetSuite transaction number to SuiteProjects Pro number when importing vendor bills or purchase orders box is checked on the NetSuite Connector administration form in SuiteProjects Pro, the PO # on the purchase order in NetSuite is used to generate the prefix and number part of the PR #. See Map NetSuite transaction number to SuiteProjects Pro number when importing vendor bills or purchase orders.

Transaction.tranId
generated automatically in SuiteProjects Pro

Purchaserequest.number

By default, the number part of the PR # on the SuiteProjects Pro purchase request record is generated automatically when the record is created.

="NS-" +Transaction.tranId +"-" +Transaction.line
="NS-" +<generated PO number> +"-" +Transaction.line

Purchaserequest.name

The default mapping definitions for Purchaserequest.prefix (the prefix part of the PR #), Purchaserequest.number (the number part of the PR #), and the line number are used to generate the PR # [Purchaseorder.name].

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.

Purchaserequest.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 Requester on the purchase request 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

Purchaserequest.currency

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

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

Transaction.memo

Purchaserequest.notes

—

="A"

Purchaserequest.approval_status

Purchaserequest.date_approved

[Initial only]

Request Items

The following table describes the information added to the request item records created for each purchase order line item imported into SuiteProjects Pro.

NetSuite Field	SuiteProjects Pro Field	Notes
`=Transaction.internalId +"-" +Transaction.line`	`Request_item.netsuite_request_item_id__c`	When the integration creates a new request item record in SuiteProjects Pro, SuiteProjects Pro stores the internal ID of the NetSuite purchase order and the line ID number of the purchase order line item in the NetSuite Purchase Order ID [`netsuite_request_item_id`] custom field. This custom field is used to link the SuiteProjects Pro and NetSuite records for future updates and matching record associations.
Looked up SuiteProjects Pro field value — `name` of SuiteProjects Pro product with `netsuite_product_id` equal to the NetSuite field `Transaction.item`	`Request_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`	`Request_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 purchase order header NetSuite field `Transaction.entity` on the purchase order line item	`Request_item.project_id`	The project can be referenced either in the purchase order header or in each purchase order 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`	`Request_item.customer_id`	—
`Transaction.custcol_oa_po_rate`	`Request_item.cost`	The SuiteProjects Pro Rate [`custcol_oa_po_rate`] custom field value is sourced from the Rate on the purchase order line item in NetSuite and imports to the Price field on the request item record in SuiteProjects Pro.
`="each"`	`Request_item.um`	—
`ABS(Transaction.quantity)`	`Request_item.quantity`	The Quantity must be positive in the SuiteProjects Pro purchase item record.
`Transaction.fxAmount \|\| Transaction.amount`	`Request_item.total`	If the Quantity is negative on the purchase order 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 purchase order 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	`Request_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.	`Request_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 Requester on the request 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`	`Request_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 purchase order line item in NetSuite.
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 purchase order header	`Request_item.vendor_id`	—
`Transaction.tranDate`	`Purchase_item.date`	—

NetSuite Field

Direction

SuiteProjects Pro Field

Notes

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

Request_item.netsuite_request_item_id__c

When the integration creates a new request item record in SuiteProjects Pro, SuiteProjects Pro stores the internal ID of the NetSuite purchase order and the line ID number of the purchase order line item in the NetSuite Purchase Order ID [netsuite_request_item_id] custom field. This custom field is used to link the SuiteProjects Pro and NetSuite records for future updates and matching record associations.

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

Request_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

Request_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 purchase order header
NetSuite field Transaction.entity on the purchase order line item

Request_item.project_id

The project can be referenced either in the purchase order header or in each purchase order 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.

Request_item.customer_id

—

Transaction.custcol_oa_po_rate

Request_item.cost

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

="each"

Request_item.um

—

ABS(Transaction.quantity)

Request_item.quantity

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

Transaction.fxAmount || Transaction.amount

Request_item.total

If the Quantity is negative on the purchase order 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 purchase order 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

Request_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.

Request_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 Requester on the request 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

Request_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 purchase order line item in NetSuite.

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 purchase order header

Request_item.vendor_id

—

Transaction.tranDate

Purchase_item.date

—

Fulfillments

The following table describes the information added or updated to the fulfillment records created for each purchase order line item imported into SuiteProjects Pro if not fulfilled.

NetSuite Field	SuiteProjects Pro Field	Notes
`ABS(Transaction.quantityShipRecv) – <Total quantity fulfilled>` `ABS(Transaction.quantity – <Total quantity fulfilled>`	`Fulfillment.quantity`	Fulfillment records are created based on The Received field on the purchase order line item if the purchase item can be fulfilled. The Quantity field on the purchase order line item if the purchase item cannot be fulfilled. The quantity fulfilled in SuiteProjects Pro cannot be greater than the quantity received in NetSuite. If the NetSuite value is increased after the initial import a new fulfillment record is created. The Quantity cannot be decreased in SuiteProjects Pro after the initial import — a warning is issued if the NetSuite value is decreased.
Looked up SuiteProjects Pro field value — `id` of SuiteProjects Pro purchase order record created to match the imported NetSuite purchase order	`Fulfillment.purchaseorder_id`	—
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	`Fulfillment.purchaserequest_id`	—
Looked up SuiteProjects Pro field value — `id` of SuiteProjects Pro purchase item record created to match the imported NetSuite purchase order line item	`Fulfillment.purchase_item_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	`Fulfillment.request_item_id`	—
`Transaction.tranDate`	`Fulfillment.date`	—

NetSuite Field

Direction

SuiteProjects Pro Field

Notes

ABS(Transaction.quantityShipRecv) – <Total quantity fulfilled>
ABS(Transaction.quantity – <Total quantity fulfilled>

Fulfillment.quantity

Fulfillment records are created based on

The Received field on the purchase order line item if the purchase item can be fulfilled.
The Quantity field on the purchase order line item if the purchase item cannot be fulfilled. The quantity fulfilled in SuiteProjects Pro cannot be greater than the quantity received in NetSuite.

If the NetSuite value is increased after the initial import a new fulfillment record is created. The Quantity cannot be decreased in SuiteProjects Pro after the initial import — a warning is issued if the NetSuite value is decreased.

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

Fulfillment.purchaseorder_id

—

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

Fulfillment.purchaserequest_id

—

Looked up SuiteProjects Pro field value — id of SuiteProjects Pro purchase item record created to match the imported NetSuite purchase order line item

Fulfillment.purchase_item_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

Fulfillment.request_item_id

—

Transaction.tranDate

Fulfillment.date

—