Purchase Revenue Recognition Mapping Group

Use the Purchase Revenue Recognition mapping group to map information on the revenue recognition transaction records from purchase items in SuiteProjects Pro with header information on the journal entry records in NetSuite. The mapping group supports filters.

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, and custom filters. Custom filters are supported for this mapping group.
Default Field Mappings - Overview of default field mapping definitions including notes and best practice guidelines where relevant. Information exported by default includes company name, address and currency. Filters and pullbacks are supported.
Additional Field Mappings - There are no specific guidelines for custom field mapping definitions in this mapping group. 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`]
Revenue recognition journal entry [`JournalEntry`] Schema: JournalEntry (2025.2)\|JournalEntry (2023.1) XSD: tranGeneral (2025.2)\|tranGeneral (2023.1)	Revenue recognition transaction [`revenue_recognition_transaction`] Data Dictionary: revenue_recognition_transaction	Revenue recognition [`REVENUE_TO_JOURNAL`]

NetSuite Record type [SOAP object]

SuiteProjects Pro Record Type [table]

Mapping Group [Integration point]

Revenue recognition journal entry [JournalEntry]

Schema: JournalEntry (2025.2)|JournalEntry (2023.1)

XSD: tranGeneral (2025.2)|tranGeneral (2023.1)

Revenue recognition transaction [revenue_recognition_transaction]

Data Dictionary: revenue_recognition_transaction

Revenue recognition [REVENUE_TO_JOURNAL]

Default and Custom Filters

By default, revenue recognition transaction records are exported from SuiteProjects Pro to NetSuite if the following conditions are met:

A project exists in NetSuite matching the project associated with the revenue recognition transaction and its internal ID is recorded in the NetSuite Project ID custom field for the project in SuiteProjects Pro.
The revenue recognition transaction was not already exported - revenue_recognition_transaction.exported is empty.
The NetSuite Journal Entry ID [netsuite_revenue_recognition_transaction_id] custom field is empty OR the Allow objects with a NetSuite ID to be exported during integration run box is checked on the NetSuite Connector administration form in SuiteProjects Pro. See Allow objects with a NetSuite ID to be exported during integration run.
The revenue recognition transaction is associated with a fulfillment and the associated fulfillment is associated with a purchase item. If the revenue recognition transaction is not associated with a fulfillment or the associated fulfillment is not associated with a purchase item, the Revenue Recognition Mapping Group is used.

Custom filters are supported for this mapping group. For more information about adding filter conditions, see Using Filters and Filter Definition.

Default Field Mappings

The following table describes the default field mapping definitions for the Purchase Revenue Recognition mapping group tab.

NetSuite Field	SuiteProjects Pro Field	Notes
`JournalEntry.currency`	`Revenue_recognition_transaction.currency`	Multiple currency - If the Multiple Currency feature is enabled for your NetSuite account, you can export currency information for revenue recognition transactions from SuiteProjects Pro to NetSuite. The currency on the NetSuite journal entry record is set to The Currency on the revenue recognition transaction record in SuiteProjects Pro, if the Multicurrency feature is enabled for your SuiteProjects Pro account. The base currency for your SuiteProjects Pro account, otherwise.
`JournalEntry.exchangeRate`	`Project.netsuite_exchange_rate__c`	Visible on mapping definition table only if the Do not use SuiteProjects Pro project exchange rate on invoice and recognition transaction export box is not checked on the NetSuite Connector administration form in SuiteProjects Pro. Active only if the Multiple Currency feature is enabled for your NetSuite account and the Do not use SuiteProjects Pro project exchange rate on invoice and recognition transaction export box is not checked on the NetSuite Connector administration form in SuiteProjects Pro. SuiteProjects Pro NetSuite Connector lets you set the NetSuite Project Exchange Rate [`Project.netsuite_exchange_rate__c`] - the exchange rate to use when exporting invoices and revenue recognition translations from SuiteProjects Pro to NetSuite.
`JournalEntry.subsidiary`	`Project.netsuite_subsidiary_id__c`	The subsidiary field for the journal entry is set to the value of the NetSuite Project Subsidiary ID [`Project.netsuite_subsidiary_id`] custom field for the project associated with the revenue recognition transactions. If you use NetSuite OneWorld, the internal ID of the subsidiary associated with the project is imported into SuiteProjects Pro with the project import and stored in the NetSuite Project Subsidiary ID [`Project.netsuite_subsidiary_id`] custom field on the project record. See Projects (Projects) Import Workflow.
`JournalEntry.custbody_oa_rev_rec_id__c`	`Revenue_recognition_transaction.id`	Active but not visible on mapping definition table if the Enable NetSuite intercompany journal creation for recognition transaction and invoice export box is checked on the NetSuite Connector administration form in SuiteProjects Pro. The internal ID of the SuiteProjects Pro revenue recognition transactions is exported to NetSuite and stored in the SuiteProjects Pro Revenue Recognition ID [`custbody_oa_rev_rec_id__c`] for the journal entry.

NetSuite Field

Direction

SuiteProjects Pro Field

Notes

JournalEntry.currency

Revenue_recognition_transaction.currency

Multiple currency - If the Multiple Currency feature is enabled for your NetSuite account, you can export currency information for revenue recognition transactions from SuiteProjects Pro to NetSuite. The currency on the NetSuite journal entry record is set to

The Currency on the revenue recognition transaction record in SuiteProjects Pro, if the Multicurrency feature is enabled for your SuiteProjects Pro account.
The base currency for your SuiteProjects Pro account, otherwise.

JournalEntry.exchangeRate

Project.netsuite_exchange_rate__c

Visible on mapping definition table only if the Do not use SuiteProjects Pro project exchange rate on invoice and recognition transaction export box is not checked on the NetSuite Connector administration form in SuiteProjects Pro.

Active only if the Multiple Currency feature is enabled for your NetSuite account and the Do not use SuiteProjects Pro project exchange rate on invoice and recognition transaction export box is not checked on the NetSuite Connector administration form in SuiteProjects Pro.

SuiteProjects Pro NetSuite Connector lets you set the NetSuite Project Exchange Rate [Project.netsuite_exchange_rate__c] - the exchange rate to use when exporting invoices and revenue recognition translations from SuiteProjects Pro to NetSuite.

JournalEntry.subsidiary

Project.netsuite_subsidiary_id__c

The subsidiary field for the journal entry is set to the value of the NetSuite Project Subsidiary ID [Project.netsuite_subsidiary_id] custom field for the project associated with the revenue recognition transactions.

If you use NetSuite OneWorld, the internal ID of the subsidiary associated with the project is imported into SuiteProjects Pro with the project import and stored in the NetSuite Project Subsidiary ID [Project.netsuite_subsidiary_id] custom field on the project record. See Projects (Projects) Import Workflow.

JournalEntry.custbody_oa_rev_rec_id__c

Revenue_recognition_transaction.id

Active but not visible on mapping definition table if the Enable NetSuite intercompany journal creation for recognition transaction and invoice export box is checked on the NetSuite Connector administration form in SuiteProjects Pro.

The internal ID of the SuiteProjects Pro revenue recognition transactions is exported to NetSuite and stored in the SuiteProjects Pro Revenue Recognition ID [custbody_oa_rev_rec_id__c] for the journal entry.

Additional Field Mappings

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