Negative Charge Mapping Group

Use the Negative Charge mapping group to map information about charges on credit (negative invoice) records in SuiteProjects Pro with information about credit memos applied to invoice transaction records in NetSuite.

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 imported by default includes credit memo number, date, amount, internal ID of the associated customer, service, product and project in SuiteProjects Pro, charge type, time and rate or quantity and cost, and currency.
Additional Field Mappings — There are no specific guidelines for custom field mapping definitions in this mapping group.

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`]
Credit Memo [`CreditMemoItem`] Schema: TransactionSearchRowBasic (2020.1)\|TransactionSearchRowBasic (2023.1) XSD: `TransactionSearchRowBasic` — platformCommon (2020.1)\|platformCommon (2023.1)	Charge [`slip`] Data Dictionary: slip	Negative Charge [`CREDIT_LINE`]

NetSuite Record type [SOAP object]

SuiteProjects Pro Record Type [table]

Mapping Group [Integration point]

Credit Memo [CreditMemoItem]

Schema: TransactionSearchRowBasic (2020.1)|TransactionSearchRowBasic (2023.1)

XSD: TransactionSearchRowBasic — platformCommon (2020.1)|platformCommon (2023.1)

Charge [slip]

Data Dictionary: slip

Negative Charge [CREDIT_LINE]

Default Field Mappings

The following table describes the default field mapping definitions for the Negative Charge mapping group tab.

NetSuite Field	SuiteProjects Pro Field	Notes
`Transaction.tranDate`	`Slip.date`	The credit memo Date in NetSuite
`-CreditMemoItem.amount`	`Slip.total`	The negative Total value of the charge in SuiteProjects Pro corresponds to the positive Amount on the corresponding credit memo line item.
`'Created from NetSuite credit memo' +Transaction.tranId`	`Slip.notes`	By default, the Credit # of the credit memo in NetSuite is recorded in the Notes field on the charge record in SuiteProjects Pro.
Looked up SuiteProjects Pro field value — `id` of SuiteProjects Pro negative invoice record matching the credit memo in NetSuite.	`Slip.invoice_id`	The internal ID of the invoice associated with the charge in SuiteProjects Pro.
Looked up SuiteProjects Pro field value — `id` of SuiteProjects Pro customer record matching the customer entity associated with the credit memo in NetSuite.	`Slip.customer_id`	The internal ID of the customer associated with the charge in SuiteProjects Pro.
Looked up SuiteProjects Pro field value — `id` of SuiteProjects Pro service record matching the service item associated with the credit memo line item in NetSuite.	`Slip.category_id`	The internal ID of the service associated with the charge in SuiteProjects Pro.
Looked up SuiteProjects Pro field value — `id` of SuiteProjects Pro product record matching the purchase item associated with the credit memo line item in NetSuite.	`Slip.product_id`	Active and visible only if the POs (Vendor Bills) import workflow is enabled. The internal ID of the product associated with the charge in SuiteProjects Pro.
Looked up SuiteProjects Pro field value — `id` of SuiteProjects Pro project record matching the project associated with the credit memo line item in NetSuite.	`Slip.project_id`	The internal ID of the project associated with the charge in SuiteProjects Pro.
`Transaction.currency`	`Slip.currency`	Active and visible only if the Multicurrency feature is enabled for your SuiteProjects Pro account. The Currency on the charge record in SuiteProjects Pro is set to the Currency on the credit memo transaction record in NetSuite.
`CreditMemoItem.custcol_oa_credit_charge_type` `="P"` `="T"` `="F"`	`Slip.type`	[Initial Only] If the Map the charge type from the NetSuite credit memo box is checked on the Credits (Applied Credit Memos) import workflow settings form, the SuiteProjects Pro: Charge Type [`CreditMemoItem.custcol_oa_credit_charge_type`] imports to the charge record in SuiteProjects Pro unless empty on the credit memo line item in NetSuite. Otherwise, the charge type is set to `P` if there is a product record associated with the charge, `T` if the Quantity is greater than `1`, or `F`. Note: The SuiteProjects Pro: Charge Type [`CreditMemoItem. custcol_oa_credit_charge_type`] is sourced from the invoice line item by default. You can set it to a different value if required. The SuiteProjects Pro: Charge Type is set automatically on the invoice line item when you export invoices from SuiteProjects Pro to NetSuite.
Looked up SuiteProjects Pro field value — `id` of SuiteProjects Pro charge type record with `slip_type.type` equal to `Slip.type`.	`Slip.slip_type_id`	—
Calculated number of hours based on `CreditMemoItemList.quantity` if the Charge type is `T` or `O`	`Slip.hour`	—
Calculated number of minutes based on `CreditMemoItemList.quantity` if the Charge type is `T` or `O`	`Slip.minute`	—
Calculated rate based on `Slip.total` and `CreditMemoItemList.quantity` if the Charge type is `T` or `O`	`Slip.rate`	—
`-CreditMemoItemList.quantity` if the Charge type is `P`	`Slip.quantity`	—
Calculated cost based on `Slip.total` and `CreditMemoItemList.quantity` if the Charge type is `P` `Slip.total` if the Charge type is `F`	`Slip.cost`	—
If the Charge type is `P` Looked up SuiteProjects Pro field value — Unit measure [`um`] for the associated product in SuiteProjects Pro, if any.charge type record with `slip_type.type` equal to `Slip.type`. `="each"` otherwise.	`Slip.um`	—
`CreditMemo.internalId`	`Slip.netsuite_credit_id__c`	Not visible in mapping definition table [Initial Only] SuiteProjects Pro stores the internal ID of the credit memo in the NetSuite Credit Memo ID [`netsuite_credit_id`] custom field on the charge record in SuiteProjects Pro. This custom field is used to link the SuiteProjects Pro and NetSuite records for future updates and matching record associations.
`CreditMemoItem.line`	`Slip.netsuite_credit_line_id__c`	Not visible in mapping definition table [Initial Only] SuiteProjects Pro stores the line ID of the credit memo item in the NetSuite Credit Memo Line ID [`netsuite_credit_line_id`] custom field on the charge record in SuiteProjects Pro. This custom field is used to link the SuiteProjects Pro and NetSuite records for future updates and matching record associations.

NetSuite Field

Direction

SuiteProjects Pro Field

Notes

Transaction.tranDate

Slip.date

The credit memo Date in NetSuite

-CreditMemoItem.amount

Slip.total

The negative Total value of the charge in SuiteProjects Pro corresponds to the positive Amount on the corresponding credit memo line item.

'Created from NetSuite credit memo' +Transaction.tranId

Slip.notes

By default, the Credit # of the credit memo in NetSuite is recorded in the Notes field on the charge record in SuiteProjects Pro.

Looked up SuiteProjects Pro field value — id of SuiteProjects Pro negative invoice record matching the credit memo in NetSuite.

Slip.invoice_id

The internal ID of the invoice associated with the charge in SuiteProjects Pro.

Looked up SuiteProjects Pro field value — id of SuiteProjects Pro customer record matching the customer entity associated with the credit memo in NetSuite.

Slip.customer_id

The internal ID of the customer associated with the charge in SuiteProjects Pro.

Looked up SuiteProjects Pro field value — id of SuiteProjects Pro service record matching the service item associated with the credit memo line item in NetSuite.

Slip.category_id

The internal ID of the service associated with the charge in SuiteProjects Pro.

Looked up SuiteProjects Pro field value — id of SuiteProjects Pro product record matching the purchase item associated with the credit memo line item in NetSuite.

Slip.product_id

Active and visible only if the POs (Vendor Bills) import workflow is enabled.

The internal ID of the product associated with the charge in SuiteProjects Pro.

Looked up SuiteProjects Pro field value — id of SuiteProjects Pro project record matching the project associated with the credit memo line item in NetSuite.

Slip.project_id

The internal ID of the project associated with the charge in SuiteProjects Pro.

Transaction.currency

Slip.currency

Active and visible only if the Multicurrency feature is enabled for your SuiteProjects Pro account.

The Currency on the charge record in SuiteProjects Pro is set to the Currency on the credit memo transaction record in NetSuite.

CreditMemoItem.custcol_oa_credit_charge_type
="P"
="T"
="F"

Slip.type

[Initial Only] If the Map the charge type from the NetSuite credit memo box is checked on the Credits (Applied Credit Memos) import workflow settings form, the SuiteProjects Pro: Charge Type [CreditMemoItem.custcol_oa_credit_charge_type] imports to the charge record in SuiteProjects Pro unless empty on the credit memo line item in NetSuite.

Otherwise, the charge type is set to P if there is a product record associated with the charge, T if the Quantity is greater than 1, or F.

Note:

The SuiteProjects Pro: Charge Type [CreditMemoItem. custcol_oa_credit_charge_type] is sourced from the invoice line item by default. You can set it to a different value if required. The SuiteProjects Pro: Charge Type is set automatically on the invoice line item when you export invoices from SuiteProjects Pro to NetSuite.

Looked up SuiteProjects Pro field value — id of SuiteProjects Pro charge type record with slip_type.type equal to Slip.type.

Slip.slip_type_id

—

Calculated number of hours based on CreditMemoItemList.quantity if the Charge type is T or O

Slip.hour

—

Calculated number of minutes based on CreditMemoItemList.quantity if the Charge type is T or O

Slip.minute

—

Calculated rate based on Slip.total and CreditMemoItemList.quantity if the Charge type is T or O

Slip.rate

—

-CreditMemoItemList.quantity if the Charge type is P

Slip.quantity

—

Calculated cost based on Slip.total and CreditMemoItemList.quantity if the Charge type is P
Slip.total if the Charge type is F

Slip.cost

—

If the Charge type is P

Looked up SuiteProjects Pro field value — Unit measure [um] for the associated product in SuiteProjects Pro, if any.charge type record with slip_type.type equal to Slip.type.
="each" otherwise.

Slip.um

—

CreditMemo.internalId

Slip.netsuite_credit_id__c

Not visible in mapping definition table

[Initial Only] SuiteProjects Pro stores the internal ID of the credit memo in the NetSuite Credit Memo ID [netsuite_credit_id] custom field on the charge record in SuiteProjects Pro. This custom field is used to link the SuiteProjects Pro and NetSuite records for future updates and matching record associations.

CreditMemoItem.line

Slip.netsuite_credit_line_id__c

Not visible in mapping definition table

[Initial Only] SuiteProjects Pro stores the line ID of the credit memo item in the NetSuite Credit Memo Line ID [netsuite_credit_line_id] custom field on the charge record in SuiteProjects Pro. This custom field is used to link the SuiteProjects Pro and NetSuite records for future updates and matching record associations.

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