Accounts Receivable Invoice object mapping 

This page helps you understand the objects and field mapping that is done 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 the least to the id.

The maximum allowed characters are 99

displaycontact

 

Mapping information provided in the table given below Display Contact.

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 the least 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 the least 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 the least 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 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

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.

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 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.

AR Payment Item

The following table provides information on the AR Payment 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

invoicekey

id

amount

allocated_amount

Applying Refund 

Creating AR Adjustment

The following table provides information on the AR Adjustment 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

customerid

id

datecreated

date

adjustmentno

id + "_" + transaction_id

invoiceno

null

basecurr

baseCurrencyCode

currency

currency

exchratedate

date

exchratetype

"Intacct Daily Rate"

taxsolutionid

If tax solution is enabled in configuration settings, fetch tax solutionid from configuration

aradjustmentitems

List of adjustment line item

Note:

Mapping information provided in the table given below AR Adjustment Line Item.

AR Adjustment Line Item

The following table provides information on the AR Adjustment 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

glaccountno

refund_clearingaccount

 

amount

amount_refunded

amount_refunded of credit_note

memo

"refund"

 

locationid

based on the configuration otherwise, it is not applicable

For multiple base currency feature, locationid populated based on the invoice currency code

departmentid

based on the configuration

 

itemid

based on the configuration

 

taxentries

List of Zero Rated Tax Entries

Mapping information provided in the table given below Tax.

Tax

The following table provides information on the tax 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

trx_tax

0

detailid

tax detailid based on the configuration

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.

AR Payment Item

The following table provides information on the AR Payment 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

invoicekey

id

amount

allocated_amount

Creating Bill and AP Manual Payment 

The following table provides information on the Bill and AP Manual 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

vendorid

based on the configuration

datecreated

date

datedue

date

billno

"refund_" + id

description

"refund id -" + id

basecurr

base_currency_code

currency

currency

exchratedate

date

exchratetype

"Intacct Daily Rate"

taxsolutionid

based on the configuration

billitems

List of billItems

Note:

Mapping information provided in the table given below Bill Items.

Bill Items

The following table provides information on the Bill Items 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

glaccountno

refund_clearingaccount

amount

amount

locationid

based on the configuration

taxentries

Note:

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

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.

Payment Request Items

The following table provides information on the payment request items 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

key

"bill_" + id

paymentamount

exchangerate * amount

Transactions 

Chargebee Transactions include payments, refunds, and offline payments.

Payments 

Payments include creating AR Payment and applying AR Payment objects.

Creating 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

customerid

id

 

paymentamount

amount

 

translatedamount

amount
OR
exhangerate * amount

If basecurrency is same as transaction currency, then the
transaction amount is considered.

Otherwise, the product of
exhangerate and transaction amount is considered.

bankaccountid

based on the configuration

 

refid

id

 

overpaylocid

based on the configuration

 

overpaydeptid

based on the configuration

 

datereceived

date

 

paymentmethod

based on the configuration

Mapping information provided in the table given below Payment Method Mapping.

basecurr

base_currency_code

 

currency

currency_code

 

exchratedate

date

 

exchratetype

"Intacct Daily Rate"

 

arpaymentitem

List of ARPayments

Mapping information provided in the table given below AR Payment Item.

AR Payment Item

The following table provides information on the AR Payment 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

invoicekey

id

amount

amount

Payment Method Mapping

The following table provides information on the payment method mapping 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

EFT

AMAZON_PAYMENTS

Credit card

CARD

Cash

CASH

EFT

PayPal_EXPRESS_CHECHOUT

EFT

BANK_TRANSFER

EFT

CHARGEBACK

Printed Check

CHECK

EFT

DIRECT_DEBIT

Cash

OTHER

Cash

_UNKNOWN

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.

AR Payment Item

The following table provides information on the AR Payment 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

invoicekey

id

amount

amount

Refunds 

Payments include creating AR Adjustment and AR Adjustment Line Items objects.

Creating AR Adjustment

The following table provides information on the AR Adjustment 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

customerid

id

datecreated

date

adjustmentno

id + "_refund"

invoiceno

null

basecurr

baseCurrencyCode

currency

currency

exchratedate

date

exchratetype

"Intacct Daily Rate"

taxsolutionid

If tax solution is enabled during configuration, fetch taxsolutionid from configuration

aradjustmentitems

List of adjustment line items

Note:

Mapping information provided in the table given below AR Adjustment Line Items.

AR Adjustment Line Items

The following table provides information on the AR Adjustment 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

glaccountno

refund_clearingaccount based on the integration configuration

 

amount

amount_refunded

 

memo

"refund"

 

locationid

based on the configuration otherwise, it is not applicable

For multiple base currency feature, locationid is populated based on the credit note/transaction currency code

departmentid

based on the configuration otherwise, it is not applicable

For multiple base currency feature, departmentid is populated based on the credit note/transaction currency code

itemid

based on the configuration otherwise, it is not applicable

 

taxentries

list of zero rated tax entries

Mapping information provided in the table given below Tax.

Tax

The following table provides information on the tax 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

trx_tax

tax

detailid

tax detail id based on the configuration

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.

AR Payment Item

The following table provides information on the AR Payment 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

invoicekey

ar adjustment id created corresponding to refund

amount

amount_refunded

Creating Bill and AP Manual Payment

The following table provides information on the Bill and AP Manual 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

vendorid

based on the configuration

datecreated

date

datedue

date

billno

"refund_" + id

description

"refund id -" + id

basecurr

base_currency_code

currency

currency

exchratedate

date

exchratetype

"Intacct Daily Rate"

taxsolutionid

based on the configuration

billitems

List of billItems

Note:

Mapping information provided in the table given below Bill Items.

Bill Items

The following table provides information on the bill items 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

refund_clearingaccount

 

amount

amount

 

locationid

based on the configuration

For multiple base currency feature, locationid is populated based on the credit note/transaction currency code

taxentries

 

Mapping information provided in the table given below Creating AP Payment.

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.

Payment Request Items

The following table provides information on the payment request items 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

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

Payment Method Mapping

The following table provides information on the payment method mapping 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

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?
Loading…