Negative Charge Mapping Group

Use the Negative Charge mapping group to map information about charges on credit (negative invoice) records in OpenAir 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 OpenAir 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 OpenAir, 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`]	OpenAir Record Type [`table`]	Mapping Group [`Integration point`]
Credit Memo [`CreditMemoItem`] Schema: CreditMemoItem (2020.1)\|CreditMemoItem (2023.1) XSD: `CreditMemo` — tranCust (2020.1)\|tranCust (2023.1)	Charge [`slip`] Data Dictionary: slip	Negative Charge [`CREDIT_LINE`]

NetSuite Record type [SOAP object]

OpenAir Record Type [table]

Mapping Group [Integration point]

Credit Memo [CreditMemoItem]

Schema: CreditMemoItem (2020.1)|CreditMemoItem (2023.1)

XSD: CreditMemo — tranCust (2020.1)|tranCust (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	OpenAir Field	Notes
`Transaction.tranDate`	`Slip.date`	The credit memo Date in NetSuite
`-CreditMemoItem.amount`	`Slip.total`	The negative Total value of the charge in OpenAir 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 OpenAir.
Looked up OpenAir field value — `id` of OpenAir negative invoice record matching the credit memo in NetSuite.	`Slip.invoice_id`	The internal ID of the invoice associated with the charge in OpenAir.
Looked up OpenAir field value — `id` of OpenAir 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 OpenAir.
Looked up OpenAir field value — `id` of OpenAir 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 OpenAir.
Looked up OpenAir field value — `id` of OpenAir 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 OpenAir.
Looked up OpenAir field value — `id` of OpenAir 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 OpenAir.
`Transaction.currency`	`Slip.currency`	Active and visible only if the Multicurrency feature is enabled for your OpenAir account. The Currency on the charge record in OpenAir 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 OpenAir: Charge Type [`CreditMemoItem.custcol_oa_credit_charge_type`] imports to the charge record in OpenAir 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 OpenAir: 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 OpenAir: Charge Type is set automatically on the invoice line item when you export invoices from OpenAir to NetSuite.
Looked up OpenAir field value — `id` of OpenAir 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 OpenAir field value — Unit measure [`um`] for the associated product in OpenAir, 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] OpenAir stores the internal ID of the credit memo in the NetSuite Credit Memo ID [`netsuite_credit_id`] custom field on the charge record in OpenAir. This custom field is used to link the OpenAir 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] OpenAir 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 OpenAir. This custom field is used to link the OpenAir and NetSuite records for future updates and matching record associations.

NetSuite Field

Direction

OpenAir Field

Notes

Transaction.tranDate

Slip.date

The credit memo Date in NetSuite

-CreditMemoItem.amount

Slip.total

The negative Total value of the charge in OpenAir 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 OpenAir.

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

Slip.invoice_id

The internal ID of the invoice associated with the charge in OpenAir.

Looked up OpenAir field value — id of OpenAir 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 OpenAir.

Looked up OpenAir field value — id of OpenAir 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 OpenAir.

Looked up OpenAir field value — id of OpenAir 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 OpenAir.

Looked up OpenAir field value — id of OpenAir 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 OpenAir.

Transaction.currency

Slip.currency

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

The Currency on the charge record in OpenAir 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 OpenAir: Charge Type [CreditMemoItem.custcol_oa_credit_charge_type] imports to the charge record in OpenAir 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 OpenAir: 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 OpenAir: Charge Type is set automatically on the invoice line item when you export invoices from OpenAir to NetSuite.

Looked up OpenAir field value — id of OpenAir 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 OpenAir field value — Unit measure [um] for the associated product in OpenAir, 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] OpenAir stores the internal ID of the credit memo in the NetSuite Credit Memo ID [netsuite_credit_id] custom field on the charge record in OpenAir. This custom field is used to link the OpenAir 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] OpenAir 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 OpenAir. This custom field is used to link the OpenAir and NetSuite records for future updates and matching record associations.

Additional Field Mappings

Important:

Review the following guidelines

You should contact your OpenAir 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 OpenAir technical documentation before attempting to set field mapping definitions using the advanced notation — See Schema Reference Documentation.

No specific guidelines