1. NetSuite Integration
  2. Exporting Data From OpenAir to NetSuite
  3. Send OpenAir Credits (Negative Invoices) as NetSuite Credit Memos Export Workflow
  4. Send OpenAir Credits (Negative Invoices) as NetSuite Credit Memos Field Mapping Definitions
  5. Project Mapping Group

Project Mapping Group

Use the Project mapping group to include project-specific information from the project record in OpenAir in the invoice header information on the NetSuite invoice transaction record.

Important:

Review the following guidelines:

  • To include project-specific information in the exported header information, each invoice and credit record in OpenAir must relate to one project only. To restrict each invoice and credit to one project only in OpenAir, check the One project per invoice box in Administration > Application Settings > Invoices > Other settings.

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

For reference information and best practice guidelines, review the following topics:

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]

Credit Memo [CreditMemo]

Schema: CreditMemo (2020.1)|CreditMemo (2023.1)

XSD: tranCust (2020.1)|tranCust (2023.1)

XSD (pullback): TransactionSearchRowBasic — platformCommon (2020.1)|platformCommon (2023.1)

Project [project]

Data Dictionary: project

Project [INVOICE_PROJECT]

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.

Review the following guidelines:

  • Field mapping definitions on this tabs are ignored unless the One project per invoice box is checked in the Invoices application settings in OpenAir (Administration > Application Settings > Invoices > Other settings).