Apply invoice line in NetSuite to expense using OpenAir ticket id

Check this box to add the OpenAir Expense Report Line ID custom field to expense lines in NetSuite and populate it automatically with the internal ID of the OpenAir receipt when exporting an expense report from OpenAir to NetSuite. NetSuite Connector will use the OpenAir Expense Report Line ID custom field, if it is populated and visible on the expense report form in NetSuite, to match the relevant expense line when exporting the invoice from OpenAir to NetSuite.

This setting resolves an issue that prevented NetSuite Connector to match the expense line resulting in failed invoice exports from OpenAir to NetSuite. Enabling this setting will ensure that the OpenAir Expense Report Line ID is populated automatically on the appropriate NetSuite transaction record in future expense report exports. To troubleshoot previous failed invoice exports, update the OpenAir Expense Report Line ID custom field manually in NetSuite for each expense lines on each expense report using the internal ID of the corresponding OpenAir receipt, then export the invoices again.

Important:

Make sure the OpenAir Expense Report Line ID custom field is visible on the default Expense report form in NetSuite.

  1. In NetSuite, sign in as an Administrator and go to Customization > Forms > Transaction forms.

  2. Click the name of the transaction form with type Expense report and Preferred box checked.

  3. On the Screen fields subtab, click the Expenses subsection further to the right.

  4. Check the show box for the OpenAir Expense Report Line ID custom field.

  5. Click Save.