Credit Purchase Journal Entry Line Mapping Group

Use the Credit Purchase Journal Entry Line mapping group to map information on the revenue recognition transaction records from purchase items in SuiteProjects Pro with credit line item 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 Credit 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

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

NetSuite Field

Direction

SuiteProjects Pro Field

Notes

JournalEntryLine.account

Arrow pointing right

Looked up SuiteProjects Pro field value - Product.netsuite_product_inc_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 income 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.credit

Arrow pointing right

Revenue_recognition_transaction.total

-

JournalEntryLine.entity

Arrow pointing right

Project.netsuite_project_id__c

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

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