Purchase Line Mapping Group

Use the Purchase Line mapping group to export information on the purchase items imported from NetSuite purchase order line item and associated with the product charges (type P) included on the invoice in OpenAir to corresponding NetSuite invoice line items listed on the Items subtab.

The Purchase Line mapping group is NOT used if the product charge was created from a purchase item imported from a NetSuite vendor bill into OpenAir using the POs (Vendor Bills) import workflow and all the following conditions are met:

• The Use Service item instead of Product item during invoices export for purchase charges box is NOT checked on the Invoices (Invoices) import workflow settings form. See Use Service item instead of Product item during invoices export for purchase charges

• The Billable box is checked on the vendor bill line item in NetSuite and the NetSuite vendor bill line billable [netsuite_vb_billable] box is checked on the corresponding purchase item in OpenAir.

• The Disable vendor bill linkage on invoices in NetSuite integration box is NOT checked on the Invoices (Invoices) import workflow settings form. See Disable vendor bill linkage on invoices in NetSuite integration.

The Vendor Bill Line mapping group is used in that case — See Vendor Bill Line Mapping Group.

Otherwise the Purchase Line mapping group is used when the charge is a product charge (type P) that was created from a non-billable purchase item imported from a NetSuite purchase order or vendor bill into OpenAir using the POs (Purchase Orders) or POs (Vendor Bills) import workflows.

Tip:

You can use this mapping group to include information from the original purchase order line item or vendor bill line item in NetSuite that was imported into OpenAir as purchase item on the invoice line item in NetSuite.

Important:

If you add custom mapping definitions in the Purchase Line mapping group tab for the NetSuite fields that are also mapped in the Invoice Line mapping group tab, the field mapping definition in the Purchase Line mapping group tab takes precedence, any value set for that NetSuite field using the Purchase Line field mapping definition overrides the value set for that NetSuite field using the Invoice Line field mapping definition.

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 Field Mappings — There are no default field mapping definitions for this mapping group.

• 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 [SOAP object]	OpenAir Record Type [table]	Mapping Group [Integration point]
Line Item [InvoiceItem] Schema: InvoiceItem (2020.1)|InvoiceItem (2023.1) XSD: tranSales (2020.1)|tranSales (2023.1)	Purchase item [purchase_item] Data Dictionary: purchase_item	Purchase Line [INVOICE_PURCHASE_LINE]

Default Field Mappings

None

Additional Field Mappings

Important:

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