Journal Entry Line Mapping Group

Use the Journal Entry Line mapping group to map information on the revenue recognition transaction records in SuiteProjects Pro with information on both credit and debit line items on journal entry records in NetSuite.

Note:

Changes to the Journal Entry mapping group also impact the behavior of the Credit Journal Entry Line and Debit Journal Entry Line mapping groups. See Credit Journal Entry Line Mapping Group and Debit Journal Entry Line Mapping Group.

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 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) XSD (pullback): `TransactionSearchRowBasic` - PlatformCommon (2025.2)\|platformCommon (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)

XSD (pullback): TransactionSearchRowBasic - PlatformCommon (2025.2)|platformCommon (2023.1)

Revenue Recognition Transaction [revenue_recognition_transaction]

Data Dictionary: Revenue_recognition_transaction

Revenue Recognition [REVENUE_TO_JOURNAL]

Default Field Mappings

The following table describes the default field mapping definitions for the Journal Entry Line mapping group tab.

NetSuite Field	SuiteProjects Pro Field	Notes
`JournalEntryLine.account`	Looked up SuiteProjects Pro field value - `Category.netsuite_inc_acct_id__c` for the service with `Category.id` equal to `Revenue_recognition_transaction.category_id` `Category.netsuite_def_rev_acct_id__c` for the service with `Category.id` equal to `Revenue_recognition_transaction.category_id`	The internal ID for the NetSuite income account when creating a credit line (`JournalEntryLine.credit` is set) or the NetSuite deferred revenue account when creating a debit line (`JournalEntryLine.debit` is set). It is sourced from the product in SuiteProjects Pro when the POs (Purchase Orders) import workflow is not enabled or a valid `fulfillment_id` is not set on the revenue recognition transaction in SuiteProjects Pro.
`JournalEntryLine.credit`	`Revenue_recognition_transaction.total`	-
`JournalEntryLine.debit`	`Revenue_recognition_transaction.total`	-
`JournalEntryLine.entity`	`Project.netsuite_project_id__c`	The internal ID of the project associated with the journal entry line in NetSuite.
`JournalEntryLine.memo`	`Revenue_recognition_transaction.notes`	-

NetSuite Field

Direction

SuiteProjects Pro Field

Notes

JournalEntryLine.account

Looked up SuiteProjects Pro field value -

Category.netsuite_inc_acct_id__c for the service with Category.id equal to Revenue_recognition_transaction.category_id
Category.netsuite_def_rev_acct_id__c for the service with Category.id equal to Revenue_recognition_transaction.category_id

The internal ID for the NetSuite income account when creating a credit line (JournalEntryLine.credit is set) or the NetSuite deferred revenue account when creating a debit line (JournalEntryLine.debit is set).

It is sourced from the product in SuiteProjects Pro when the POs (Purchase Orders) import workflow is not enabled or a valid fulfillment_id is not set on the revenue recognition transaction in SuiteProjects Pro.

JournalEntryLine.credit

Revenue_recognition_transaction.total

JournalEntryLine.debit

Revenue_recognition_transaction.total

JournalEntryLine.entity

Project.netsuite_project_id__c

The internal ID of the project associated with the journal entry line in NetSuite.

JournalEntryLine.memo

Revenue_recognition_transaction.notes

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