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 OpenAir NetSuite Connector UI 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 OpenAir.
NetSuite Field |
D |
OpenAir Field |
Notes |
---|---|---|---|
|
![]() |
|
When the integration creates a new purchase request record in OpenAir, OpenAir stores the internal ID of the NetSuite purchase order in the NetSuite Purchase Order ID [ |
|
![]() |
|
When the integration creates a new purchase request record in OpenAir, OpenAir stores the transaction ID of the NetSuite purchase order line item in the NetSuite Purchase Order Number [ |
Looked up OpenAir field value —
|
![]() |
|
The project can be referenced either in the purchase order header or in each purchase order line item in NetSuite.
|
Looked up OpenAir field value — |
![]() |
|
— |
|
![]() |
|
— |
|
![]() |
|
— |
|
![]() |
|
— |
|
![]() |
|
The prefix part of the PR # is If the Map NetSuite transaction number to OpenAir number when importing vendor bills or purchase orders box is checked on the OpenAir NetSuite Connector administration form, 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 OpenAir number when importing vendor bills or purchase orders. |
|
![]() |
|
By default, the number part of the PR # on the OpenAir purchase request record is generated automatically when the record is created. If the Map NetSuite transaction number to OpenAir number when importing vendor bills or purchase orders box is checked on the OpenAir NetSuite Connector administration form, 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 OpenAir number when importing vendor bills or purchase orders. |
|
![]() |
|
The default mapping definitions for |
Looked up OpenAir field value
|
![]() |
|
Internal ID of the employee associated with the purchaser in OpenAir.
|
|
![]() |
|
Active and visible only if the Multicurrency feature is enabled for your OpenAir account . Multiple currency — The Currency on the purchase request record in OpenAir is set to the Currency on the purchase order line item in NetSuite. |
|
![]() |
|
— |
|
![]() |
|
|
<current date> |
![]() |
|
[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 OpenAir.
NetSuite Field |
D |
OpenAir Field |
Notes |
---|---|---|---|
|
![]() |
|
When the integration creates a new request item record in OpenAir, OpenAir 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 [ |
Looked up OpenAir field value — |
![]() |
|
Name of the product |
Looked up OpenAir field value — |
![]() |
|
Internal ID of the product |
Looked up OpenAir field value —
|
![]() |
|
The project can be referenced either in the purchase order header or in each purchase order line item in NetSuite.
|
Looked up OpenAir field value — |
![]() |
|
— |
|
![]() |
|
The OpenAir Rate [ |
|
![]() |
|
— |
|
![]() |
|
The Quantity must be positive in the OpenAir purchase item record. |
|
![]() |
|
If the Quantity is negative on the purchase order line item, the Total is adjusted automatically so that |
Looked up OpenAir field value — |
![]() |
|
— |
Looked up OpenAir field value
|
![]() |
|
Internal ID of the employee associated with the purchaser in OpenAir.
|
|
![]() |
|
Active and visible only if the Multicurrency feature is enabled for your OpenAir account . Multiple currency — The Currency on the purchase item record in OpenAir is set to the Currency on the purchase order line item in NetSuite. |
Looked up OpenAir field value — |
![]() |
|
— |
|
![]() |
|
— |
Fulfillments
The following table describes the information added or updated to the fulfillment records created for each purchase order line item imported into OpenAir if not fulfilled.
NetSuite Field |
D |
OpenAir Field |
Notes |
---|---|---|---|
|
![]() |
|
Fulfillment records are created based on
If the NetSuite value is increased after the initial import a new fulfillment record is created. The Quantity cannot be decreased in OpenAir after the initial import — a warning is issued if the NetSuite value is decreased. |
Looked up OpenAir field value — |
![]() |
|
— |
Looked up OpenAir field value — |
![]() |
|
— |
Looked up OpenAir field value — |
![]() |
|
— |
Looked up OpenAir field value — |
![]() |
|
— |
|
![]() |
|
— |