Accounts Receivable Invoice object mapping

This page helps you understand the objects and field mapping between Chargebee and Sage Intacct for Accounts Receivable (AR) Invoice.

Customer

Note:

Source entity: Chargebee Customer
Supported actions: Create and Update
Unsupported actions: Delete and Void

The following table provides information on the customer object fields mapped between Chargebee and Sage Intacct:

Note:

A prefix is added if the field is configured.

Sage Intacct Target Field	Chargebee Source Field	Additional Information
`customerid`	`id`	The maximum allowed characters are 17
`name`	`company` `first_name + last_name` `id`	First preference is given to the `company`, then `first_name+last_name`, and finally to the `id`. The maximum allowed characters are 99
`displaycontact`	—	See mapping information in the Display Contact table.
`billto`	`id + "_billto"`	The maximum allowed characters are 99
`shipto`	`id + "_billto"`	The maximum allowed characters are 99
`contactinfo`	`company` `first_name + last_name` `id`	First preference is given to the `company`, then `first_name+last_name`, and finally to the `id`. The maximum allowed characters are 99

Display Contact

The following table provides information on the display contact object fields mapped between Chargebee and Sage Intacct:

Note:

A prefix is added if the field is configured.

Sage Intacct Target Field	Chargebee Source Field	Additional information
`printas`	`company` `first_name + last_name` `id`	First preference is given to the `company`, then `first_name+last_name`, and finally to the `id`. The maximum allowed characters are 99
`contactname`	`company` `first_name + last_name` `id`	First preference is given to the `company`, then `first_name+last_name`, and finally to the `id`. The maximum allowed characters are 99
`companyname`	`company`	The maximum allowed characters are 99
`firstname`	`first_name`	The maximum allowed characters are 40
`lastname`	`last_name`	The maximum allowed characters are 40
`phone1`	`phone`	The maximum allowed characters are 30
`email1`	`email`	The maximum allowed characters are 100
`mailaddress`		Mapping information provided in the table given below Mail Address.

Mail Address

The following table provides information on the mail address object fields mapped between Chargebee and Sage Intacct:

Note:

A prefix is added if the field is configured.

Sage Intacct Target Field	Chargebee Source Field	Additional information
`address1`	`line1`	The maximum allowed characters are 255
`address2`	`line2`	The maximum allowed characters are 255
`city`	`city`	The maximum allowed characters are 80
`state`	`state`	The maximum allowed characters are 40
`country`	`country`	The maximum allowed characters are 60
`zip`	`zip`	The maximum allowed characters are 30

Item

Note:

Source entity: Chargebee Plans, Addons, and Item Prices
Supported actions: Create and Update
Unsupported actions: Delete and Void

The following table provides information on the GL account object fields mapped between Chargebee and Sage Intacct:

Note:

A prefix is added if the field is configured.

Sage Intacct Target Field	Chargebee Source Field	Additional information
`name`	`sku` `name`	First preference is given to `sku`, and the next preference to `name`
`productLineid`	based on the configuration
`extended_description`	`description`
`itemid`	`sku` `id`	First preference is given to `sku`, and the next preference to `id`
`glgroup`	`accounting_code`	The `glgroup` field will be populated if `accounting_code` is of type ITEMGLGROUP, otherwise `incomeacctkey`
`itemtype`	"Non-Inventory (Sales only)"
`incomeacctkey`	`accounting_code`

Invoice

AR Invoices are created only when Tax Solution is enabled. Sales Order (SO) Invoices are created in Sage Intacct by default.

Note:

Source entity - Chargebee Invoice
Supported actions - Create and Update

You can delete the Invoice only when the invoice is in Payment_Due status, and you can not delete an Invoice which is associated with a payment or credit note.

Accounts Receivable (AR) Invoice

The following table provides information on the accounts receivable invoice object fields mapped between Chargebee and Sage Intacct:

Note:

Multi base currency feature is not applicable.

Sage Intacct Target Field	Chargebee Source Field	Additional information
`basecurr`	`baseCurrencyCode`	The `basecurr` field can be overridden using "override_basecurrency" additional setting.
`datecreated`	`date`
`currency`	`currencyCode`
`customerid`	`id`
`invoiceno`	`prefix + id`
`datedue`	`duedate`
`shipto`	`prefix + id +` "_shipto"
`billto`	`prefix + id +` "_billto"
`exchratetype`	"Intacct Daily Rate"
`taxsolutionid`	If tax solution is enabled in configuration settings, fetch `tax solutionid` from configuration	`taxsolutionid` corresponding to tax country.
`invoiceitems`	List of Invoice line items	Mapping information provided in the table given below: Line Item Discount Roundoff Tax

Line Item

The following table provides information on the line item object fields mapped between Chargebee and Sage Intacct:

Note:

A prefix is added if the field is configured.

Sage Intacct Target Field	Chargebee Source Field	Additional information
`memo`	`description`
`glaccountno`	`glaccountno`	`glaccountno` mapped to accounting code (Item GL Group) of the line item and it is fetched based on the configured transaction definition.
`amount`	`amount`	The maximum allowed decimals are 2
`itemid`	`id`
`locationid`	`accountingCategory2` OR based on the configuration
`departmentid`	based on the configuration
`projectid`	based on the configuration
`customerid`	based on the configuration
`employeeid`	based on the configuration
`classid`	based on the configuration
`vendorid`	based on the configuration
`revrectemplate`	based on the configuration OR `accountingCategory1`
`revrecstartdate`	`date_from`
`revrecenddate`	`date_to`
`taxentries`		Mapping information provided in the table given below Tax.

Tax

The following table provides information on the tax object fields mapped between Chargebee and Sage Intacct:

Note:

A prefix is added if the field is configured.

Sage Intacct Target Field	Chargebee Source Field
`trx_tax`	amount
`detailid`	based on the configuration

Discount

The following table provides information on the discount object fields mapped between Chargebee and Sage Intacct:

Note:

A prefix is added if the field is configured.

Sage Intacct Target Field	Chargebee Source Field	Additional information
`glaccountno`	`glaccountno`	`glaccountno` mapped to accounting code (Item GL Group) of the line item and it is fetched based on the configured transaction definition.
`itemid`	`id`
`memo`	"Discount"
`amount`	discount_amount OR item_level_discount_amount - discount_amount	discount_amount If you want a separate discount on invoice and line items: itemLevelDiscountAmount invoiceLevelDicountAmount (itemLevelDiscountAmount - discount_amount) The maximum allowed decimals are 4
`locationid`	based on the configuration
`departmentid`	based on the configuration
`revrectemplate`	`revrectemplate`
`revrecstartdate`	`revrecstartdate`
`revrecenddate`	`revrecenddate`
`taxentries`		Mapping information provided in the table given below Tax.

Tax

The following table provides information on the tax object fields mapped between Chargebee and Sage Intacct:

Note:

A prefix is added if the field is configured.

Sage Intacct Target Field	Chargebee Source Field
`trx_tax`	0
`detailid`	based on the configuration

Roundoff

The following table provides information on the roundoff object fields mapped between Chargebee and Sage Intacct:

Note:

A prefix is added if the field is configured.

Sage Intacct Target Field	Chargebee Source Field
`memo`	"Round-off value"
`glaccountno`	based on the configuration
`itemid`	based on the configuration
`amount`	`amount` Note: The maximum allowed decimals are 4
`locationid`	based on the configuration
`departmentid`	based on the configuration
`projectid`	based on the configuration
`customerid`	based on the configuration
`employeeid`	based on the configuration
`classid`	based on the configuration
`vendorid`	based on the configuration
`revrectemplate`	based on the configuration
`revrecstartdate`	`date`
`revrecenddate`	`date`

Tax

The following table provides information on the tax object fields mapped between Chargebee and Sage Intacct:

Note:

A prefix is added if the field is configured.

Sage Intacct Target Field	Chargebee Source Field
`trx_tax`	0
`detailid`	based on the configuration

Intacct Negative Invoice - Credit Memo

Note:

Source entity - Chargebee Credit Note
Supported actions - Create

AR Credit Memo

Note:

Multi base currency feature is not applicable.

The following table provides information on the AR Credit Memo object fields mapped between Chargebee and Sage Intacct:

Note:

A prefix is added if the field is configured.

Sage Intacct Target Field	Chargebee Source Field	Additional information
`basecurr`	`baseCurrencyCode`	The `basecurr` field can be overridden using "override_basecurrency" additional setting.
`datecreated`	`date`
`currency`	`currencyCode`
`customerid`	`id`
`invoiceno`	`prefix + id`
`datedue`	`duedate`
`shipto`	`prefix + id +` "_shipto"
`billto`	`prefix + id +` "_billto"
`exchratetype`	"Intacct Daily Rate"
`taxsolutionid`	If tax solution is enabled in configuration settings, fetch `tax solutionid` from configuration
`invoiceitems`	List of Invoice line item	Mapping information provided in the table given below Line Item.

####Line Item

The following table provides information on the line item object fields mapped between Chargebee and Sage Intacct:

Note:

A prefix is added if the field is configured.

Sage Intacct Target Field	Chargebee Source Field	Additional information
`memo`	`description`
`glaccountno`	`glaccountno`	`glaccountno` mapped to accounting code (Item GL Group) of the line item and it is fetched based on the configured transaction definition.
`amount`	`amount`	The maximum allowed decimals are 4
`itemid`	`id`	Synced intacct item id of Chargebee's Plan/Addon and other sync items.
`locationid`	`accountingCategory2` OR based on the configuration
`departmentid`	based on the configuration
`projectid`	based on the configuration
`customerid`	based on the configuration
`employeeid`	based on the configuration
`classid`	based on the configuration
`vendorid`	based on the configuration
`revrectemplate`	based on the configuration OR `accountingCategory1`
`revrecstartdate`	`date_from`
`revrecenddate`	`date_to`
`taxentries`		Mapping information provided in the table given below Tax.
Sage Intacct Target Field	Chargebee Source Field
`trx_tax`	amount
`detailid`	based on the configuration

Sage Intacct Target Field	Chargebee Source Field
`trx_tax`	0
`detailid`	based on the configuration

Sage Intacct Target Field	Chargebee Source Field
`memo`	"Round-off value"
`glaccountno`	based on the configuration
`itemid`	based on the configuration
`amount`	`amount` Note: The maximum allowed decimals are 2
`locationid`	based on the configuration
`departmentid`	based on the configuration
`projectid`	based on the configuration
`customerid`	based on the configuration
`employeeid`	based on the configuration
`classid`	based on the configuration
`vendorid`	based on the configuration
`revrectemplate`	based on the configuration
`revrecstartdate`	`date`
`revrecenddate`	`date`

Applying Credit Note on Invoice

A credit note is applied over different invoices by AR payment linked to invoices over Intacct credit notes.

Applying AR Payment

The following table provides information on the AR Payment object fields mapped between Chargebee and Sage Intacct:

Note:

A prefix is added if the field is configured.

Sage Intacct Target Field	Chargebee Source Field
`arpaymentkey`	`id`
`paymentdate`	`allocated_at`
`memo`	"Creditmemo applied over invoice"
`overpaylocid`	nil
`overpaydeptid`	nil
`arpaymentitems`	Items on which this payment should apply Note: Mapping information provided in the table given below AR Payment Item.

Applying AR Payment

The following table provides information on the AR payment object fields mapped between Chargebee and Sage Intacct:

Note:

A prefix is added if the field is configured.

Sage Intacct Target Field	Chargebee Source Field
`arpaymentkey`	`id`
`paymentdate`	`date`
`memo`	"refund knockoff" + refund transaction id
`overpaylocid`	nil
`overpaydeptid`	nil
`arpaymentitems`	Items on which this payment should apply Note: Mapping information provided in the table given below AR Payment Item.

Creating AP Payment

The following table provides information on the AP payment object fields mapped between Chargebee and Sage Intacct:

Note:

A prefix is added if the field is configured.

Sage Intacct Target Field	Chargebee Source Field
`bankaccountid`	payment account code based on the configuration
`paymentmethod`	"Cash"
`memo`	"refund id -" + `id`
`vendorId`	based on the configuration
`paymentdate`	`date`
`paymentrequestitems`	list of payment request items Note: Mapping information provided in the table given below Payment Request Items.

Applying AR Payment

The following table provides information on applying AR Payment object fields mapped between Chargebee and Sage Intacct:

Note:

A prefix is added if the field is configured.

Sage Intacct Target Field	Chargebee Source Field
`arpaymentkey`	`id`
`paymentdate`	`date`
`memo`	"payment apply"
`overpaylocid`	based on the configuration
`overpaydeptid`	based on the configuration
`arpaymentitems`	Items for which invoice this payment should apply. Note: Mapping information provided in the table given below AR Payment Item.

Applying AR Payment

The following table provides information on the AR Payment object fields mapped between Chargebee and Sage Intacct:

Note:

A prefix is added if the field is configured.

Sage Intacct Target Field	Chargebee Source Field	Additional information
`arpaymentkey`	`Id`
`paymentdate`	`date`
`memo`	"refund knockoff" + refund transaction id
`overpaylocid`	nil	If multicurrency feature is enabled, then `overpaylocid` is populated from the mapping.
`overpaydeptid`	Applicable only for multi currency feature	If multicurrency feature is enabled, then `overpaydepartid` is populated from the mapping.
`arpaymentitems`	List of invoices for which this payment should apply	Mapping information provided in the table given below AR Payment Item.

Sage Intacct Target Field	Chargebee Source Field
`key`	"bill_" + `id`
`paymentamount`	exchangerate * `amount`

Offline Payments

The following table provides information on the offline payments object fields mapped between Chargebee and Sage Intacct:

Note:

A prefix is added if the field is configured.

Sage Intacct Target Field	Chargebee Source Field
`cusId`	`id`
`invId`	`id`
`amount`	`amount`
`ts - (timestamp)`	`date`
`mtd - (payment method)`	based on the configuration Note: Mapping information provided in the table given below Payment Method Mapping.
`refId`	`documentnumber`
`tpId`	`recordno`
`comment`	"Two way sync from intact Id :" + `documentnumber` + " internalid :" + `recordno`

Note:

A prefix is added if the field is configured.

Sage Intacct Target Field	Chargebee Source Field
Credit card / Online Charge Card	CARD
Cash	CASH
EFT	BANK_TRANSFER
Printed Check	CHECK
If empty	CASH
If none of the above	CHECK

Was this article helpful?

Product Updates

Getting Started

Implementing Chargebee

Product Catalog

Subscriptions

Customers

Invoices, Credit Notes and Quotes

Taxes

Hosted Capabilities

Site Configuration

Reports and Analytics

Integrations

Data Privacy & Security

Data Operations

Accounts Receivable Invoice object mapping

Customer

Display Contact

Mail Address

Item

Invoice

Accounts Receivable (AR) Invoice

Line Item

Tax

Discount

Tax

Roundoff

Tax

Intacct Negative Invoice - Credit Memo

AR Credit Memo

Applying Credit Note on Invoice

Applying AR Payment

Applying AR Payment

Creating AP Payment

Applying AR Payment

Applying AR Payment

Offline Payments

In This Page