Debit Purchase Journal Entry Line Mapping Group

Use the Debit Purchase Journal Entry Line mapping group to map information on the revenue recognition transaction records from purchase items in SuiteProjects Pro with debit line information on the journal entry records in NetSuite.

Note:

This mapping group is used if 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 Debit Purchase Journal Entry Line Mapping Group and Journal Entry Line Mapping Group are used.

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]

Default Field Mappings

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

NetSuite Field	Direction	SuiteProjects Pro Field	Notes
JournalEntryLine.account		Looked up SuiteProjects Pro field value - Product.netsuite_product_def_rev_acct_id__c for the service with Product.id equal to Purchase_item.product_id for the purchase item with Purchase_item.id equal to Fulfillment.purchase_item_id for the fulfillment with Fulfillment.id equal to Revenue_recognition_transaction.fulfillment_id.	The internal ID for the NetSuite deferred revenue account is sourced from the product in SuiteProjects Pro when the POs (Purchase Orders) import workflow is enabled and a valid fulfillment_id is set on the revenue recognition transaction in SuiteProjects Pro.
JournalEntryLine.debit		Revenue_recognition_transaction.total	-
JournalEntryLine.entity		Project.netsuite_project_id__c	-
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