Vendor Bill Line Mapping Group
Use the Vendor Bill Line mapping group to map information from receipt records in the OpenAir expense report with information on the line items on the NetSuite vendor bill transaction record.
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 — Overview of default field mapping definitions including notes and best practice guidelines where relevant. Information exported by default includes .
-
Additional Field Mappings — There are no specific best practice guidelines for custom field mapping definitions. The mapping group does not support custom pullback field mappings, retrieving information from the line item created in NetSuite back into OpenAir.
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 Bill Expense Line Item [ Schema: VendorBillExpense (2020.1)|VendorBillExpense (2023.1) |
Receipt [ |
Expense Report [ |
Default Field Mappings
The following table describes the default field mapping definitions for the Vendor Bill Line mapping group tab.
NetSuite Field |
D |
OpenAir Field |
Notes |
---|---|---|---|
|
![]() |
Looked up OpenAir field values — |
The internal ID of the NetSuite expense category corresponding to the expense item associated with the receipt in OpenAir. |
|
![]() |
|
— |
|
![]() |
Looked up OpenAir field values — |
The internal ID of the NetSuite project record corresponding to the project associated with the receipt in OpenAir. |
|
![]() |
|
The Tax amount is substracted from the total Amount when the following conditions are all met:
See also the mapping definition for NetSuite field |
|
![]() |
See notes |
The Billable box on NetSuite expense line items is exported from OpenAir receipts
|
|
![]() |
|
Active and visible only if the Apply invoice line in NetSuite to expense using OpenAir ticket id box is checked on the OpenAir NetSuite Connector administration form. See Apply invoice line in NetSuite to expense using OpenAir ticket id. The internal ID of the OpenAir receipt is stored in the OpenAir Expense Report Line ID [ |
|
![]() |
Looked up OpenAir field value |
Visible only if the Enable tax export on Expense reports box is checked on the Expense Reports (Expense Reports) export workflow settings form. Active only when the following conditions are all met:
The internal ID of the tax code or tax group in NetSuite corresponding to the tax location associated with the tax rate associated with the receipt in OpenAir. |
|
![]() |
Calculated value [
|
Visible only if the Enable tax export on Expense reports box is checked on the Expense Reports (Expense Reports) export workflow settings form. Active only when the following conditions are all met:
The Tax amount on the expense line is set to the Tax paid on the OpenAir receipt if the NetSuite Tax Nexus Type is |
|
![]() |
Calculated value — sum of |
Active and visible only if the Allow manual override of Canadian taxes on expense report export box is checked on the Expense Reports (Expense Reports) export workflow settings form. The Goods and Services Tax (GST) and Harmonized Sales Tax (HST) is stored in the OpenAir: GST/HST [ |
|
![]() |
Looked up OpenAir field value — |
Active and visible only if the Allow manual override of Canadian taxes on expense report export box is checked on the Expense Reports (Expense Reports) export workflow settings form. The Provincial Sales Tax (PST) entered manually on the OpenAir receipt is stored in the OpenAir: PST [ |
— |
![]() |
|
Not visible on mapping definition table OpenAir adds a timestamp for the date and time the record was exported. |
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.
Review the following guidelines:
-
Currency and Foreign Amount — When exporting expense reports from OpenAir to NetSuite as vendor bills, the receipts Currency should be the same as the Currency on the vendor or parent vendor record in NetSuite. Currency and foreign amount information is not exported by default as part of the Vendor Bill Line mapping group.
-
The following fields are not available as standard on the vendor bill expense line in NetSuite, and not exported by default as part of the Vendor Bill Line mapping group: Date, Receipt.