1. NetSuite Integration
  2. Exporting Data From SuiteProjects Pro to NetSuite
  3. Loaded Cost (Custom Record) Export Workflow
  4. Loaded Cost (Custom Record) Field Mapping Definition

Loaded Cost (Custom Record) Field Mapping Definition

The Loaded Cost (Custom Record) export workflow includes one mapping group:

Loaded Cost Mapping Group

Use the Loaded Cost mapping group to map loaded cost information in SuiteProjects Pro with information on custom records of the specified type in NetSuite.

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

  • References - Overview of record types in SuiteProjects Pro and NetSuite with links to the relevant reference material for information about fields available for mapping.

  • Default and Custom Filters - Overview of default filters and how to modify the default behavior.

  • Default Field Mapping - There are no default field mapping definitions for this mapping group.

  • Additional Field Mapping - 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 record created in NetSuite back into SuiteProjects Pro.

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]

SuiteProjects Pro Record Type [table]

Mapping Group [Integration point]

Custom record type

Schema: n/a

XSD: n/a

Record Type: Project [ loaded_cost]

Data Dictionary: loaded_cost

Loaded Cost [OA_LC_TO_NS_CUSTOM_RECORD]

Default and Custom Filters

By default, user loaded cost information is exported from SuiteProjects Pro to NetSuite if the following conditions are met:

  • The loaded cost must be associated with a user (user_id > 0).

  • The loaded cost must not be associated with a customer (customer_id > 0), a project (project_id > 0), or a project task (project_task_id > 0).

  • The loaded cost must be a primary loaded cost (lc_level = 0)

  • The loaded cost information was added or updated since the last loaded cost information export.

Custom filters are not supported for this mapping group.

Default Field Mapping

None

Additional Field Mapping

Important:

Review the following guidelines

  • You should contact your SuiteProjects Pro 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 SuiteProjects Pro technical documentation before attempting to set field mapping definitions using the advanced notation - See Schema Reference Documentation.

No specific guidelines