Vendor Bill Line Mapping Group

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

This mapping group is used when the product charges are created from purchase items imported from NetSuite vendor bills into OpenAir using the POs (Vendor Bills) import workflow and all the following condition are met.

• The charge is a product charge (type P) that was created from a purchase item imported from a NetSuite vendor bill into OpenAir using POs (Vendor Bills) import workflows. See POs (Vendor Bills) Import Workflow.

• 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.

Otherwise, the Purchase Line mapping group is used to export purchase item information associated with product charges to the corresponding line items listed on the Items subtab on the NetSuite invoice. See Purchase Line Mapping Group.

Tip:

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

Important:

If you add custom mapping definitions in the Vendor Bill Line mapping group tab for the NetSuite fields that are also mapped in the Bill Line mapping group tab, the field mapping definition in the Vendor Bill Line mapping group tab takes precedence, any value set for that NetSuite field using the Vendor Bill Line field mapping definition overrides the value set for that NetSuite field using the Bill 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]
Billable Line Item [InvoiceItemCost] Schema: InvoiceItemCost(2020.1)|InvoiceItemCost(2023.1) XSD: tranSales (2020.1)|tranSales (2023.1)	Purchase item [purchase_item] Data Dictionary: purchase_item	Bill Line [INVOICE_PURCHASE_VB_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