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.
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 — 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 [ |
OpenAir Record Type [ |
Mapping Group [ |
---|---|---|
Credit Memo [ Schema: CreditMemo (2020.1)|CreditMemo (2023.1) XSD: tranCust (2020.1)|tranCust (2023.1) XSD (pullback): |
Project [ Data Dictionary: project |
Project [ |
Default Field Mappings
None
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:
-
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).