Other Records Created or Updated by the POs (Vendor Credits) Import Workflow
The POs (Vendor Credits) 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 credit 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 credit in the NetSuite Vendor Credit ID [ |
|
|
|
When the integration creates a new purchase request record in OpenAir, OpenAir stores the transaction ID of the NetSuite vendor credit line item in the NetSuite Vendor Credit Number [ |
|
Looked up OpenAir field value —
|
|
The project can be referenced either in the vendor credit header or in each vendor credit 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 PR # on the vendor credit 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 PR # on the vendor credit 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 credit 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 credit 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 credit and the line ID number of the vendor credit line item in the NetSuite Vendor Credit 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 credit header or in each vendor credit 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 credit 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 credit 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 credit 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 credit 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 — |
|
— |
|
|
|
— |