Other Records Created or Updated by the POs (Vendor Bills) Import Workflow
The POs (Vendor Bills) 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 vendor bill 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 vendor bill in the NetSuite Vendor Bill ID [ |
|
|
|
When the integration creates a new purchase request record in OpenAir, OpenAir stores the transaction ID of the NetSuite vendor bill line item in the NetSuite Vendor Bill Number [ |
|
Looked up OpenAir field value —
|
|
The project can be referenced either in the vendor bill header or in each vendor bill 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 Reference No. on the vendor bill 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 Reference No. on the vendor bill 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 vendor bill 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 vendor bill 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 vendor bill and the line ID number of the vendor bill line item in the NetSuite Vendor Bill 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 vendor bill header or in each vendor bill 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 vendor bill 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 vendor bill 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 vendor bill line item imported into OpenAir if not fulfilled.
NetSuite Field |
D |
OpenAir Field |
Notes |
---|---|---|---|
|
|
Fulfillment records are created based on the Quantity field on the vendor bill line item 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 — |
|
— |
|
|
|
— |