PO Mapping Group
Use the PO mapping group to map information on purchase order records in OpenAir with information on vendor credit records in NetSuite. The mapping group supports filters.
For reference information and best practice guidelines, review the following topics:
-
References — Overview of record types in OpenAir 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 — There are no specific 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 [ |
OpenAir Record Type [ |
Mapping Group [ |
---|---|---|
Vendor Credit [ Schema: VendorCredit (2020.1)|VendorCredit (2023.1) XSD: |
PO [ Data Dictionary: purchaseorder |
PO [ |
Default and Custom Filters
By default, vendor credit records are imported from NetSuite into OpenAir as purchase orders if the following conditions are met:
-
The Status of the vendor credit in NetSuite must be one of the following: Fully Billed, Partially Received, Pending Bill, Pending Billing/Partially Received, or Pending Receipt.
-
The Export to OpenAir [
custbody_oa_export_to_openair
] box is checked on the project task record in NetSuite.
Custom filters are supported for this mapping group. For more information about adding filter conditions, see Using Filters and Filter Definition.
Default Field Mappings
The following table describes the default field mapping definitions for the PO mapping group tab.
NetSuite Field |
D |
OpenAir Field |
Notes |
---|---|---|---|
|
|
|
|
Looked up OpenAir field value — |
|
|
|
|
|
|
|
|
|
Active and visible only if the Multicurrency feature is enabled for your OpenAir account . Multiple currency — The Currency on the purchase order record in OpenAir is set to the Currency on the vendor credit record in NetSuite. |
|
Looked up OpenAir field value
|
|
Internal ID of the employee associated with the purchaser in OpenAir.
|
|
|
|
The prefix part of the PO # 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 vendor credit in NetSuite is used to generate the prefix and number part of the PO #. See Map NetSuite transaction number to OpenAir number when importing vendor bills or purchase orders. |
|
|
|
By default, the number part of the PO # on the OpenAir purchase order 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 vendor credit in NetSuite is used to generate the prefix and number part of the PO #. See Map NetSuite transaction number to OpenAir number when importing vendor bills or purchase orders. |
|
|
|
The default mapping definitions for |
|
|
|
[Initial only] The Automatically track payability with fulfillment field is set to |
|
|
|
[Initial only] |
|
<current date> |
|
[Initial only] |
|
Looked up OpenAir field value — |
|
[Initial Only] |
|
Looked up OpenAir field value — |
|
[Initial Only] |
|
Looked up OpenAir field value — |
|
[Initial Only] |
|
Looked up OpenAir field value — |
|
[Initial Only] |
|
|
|
Not visible in mapping definition table When you import a new purchase order record from NetSuite into OpenAir, OpenAir stores the internal ID of the NetSuite vendor credit in the NetSuite Vendor Credit ID [ |
|
|
|
Not visible in mapping definition table When you import a new purchase order record from NetSuite into OpenAir, OpenAir stores the PO # of the NetSuite vendor credit in the NetSuite Vendor Credit Number [ |
|
|
|
Not visible in mapping definition table When you import a vendor credit from NetSuite into OpenAir as a purchase order, the From NetSuite Vendor Credit [ |
Additional Field Mappings
Review the following guidelines
-
You should contact your OpenAir 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 OpenAir technical documentation before attempting to set field mapping definitions using the advanced notation — See Schema Reference Documentation.
No specific guidelines