Credit Journal Entry Line Mapping Group

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

Note:

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

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]

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 Credit Journal Entry Line mapping group tab.

NetSuite Field

Direction

SuiteProjects Pro Field

Notes

JournalEntryLine.account

Arrow pointing right

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

The internal ID for the NetSuite income account 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

Arrow pointing right

Revenue_recognition_transaction.total

-

JournalEntryLine.entity

Arrow pointing right

Project.netsuite_project_id__c

-

JournalEntryLine.memo

Arrow pointing right

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