Docs

Log in to read the version of docs relevant to your site, or use the dropdown versions

Accounts Receivable Invoice object mapping

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

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 FieldChargebee Source FieldAdditional information
customerididThe maximum allowed characters are 17
namecompany first_name + last_name idFirst 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.
billtoid+ Sage Intacct Target FieldChargebee Source Field
trx_taxamount
detailidbased on the configuration

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 FieldChargebee Source FieldAdditional information
memodescription 
glaccountnoglaccountnoglaccountno mapped to accounting code (Item GL Group) of the line item and it is fetched based on the configured transaction definition.
amountamountThe maximum allowed decimals are 4
itemididSynced intacct item id of Chargebee's Plan/Addon and other sync items.
locationidaccountingCategory2 OR based on the configuration 
departmentidbased on the configuration 
projectidbased on the configuration 
customeridbased on the configuration 
employeeidbased on the configuration 
classidbased on the configuration 
vendoridbased on the configuration 
revrectemplatebased on the configuration OR accountingCategory1 
revrecstartdatedate_from 
revrecenddatedate_to 
taxentries Mapping information provided in the table given below Tax.
Sage Intacct Target FieldChargebee Source Field
trx_taxamount
detailidbased on the configuration
Sage Intacct Target FieldChargebee Source Field
trx_tax0
detailidbased on the configuration
Sage Intacct Target FieldChargebee Source Field
memo"Round-off value"
glaccountnobased on the configuration
itemidbased on the configuration
amountamount Note: The maximum allowed decimals are 2
locationidbased on the configuration
departmentidbased on the configuration
projectidbased on the configuration
customeridbased on the configuration
employeeidbased on the configuration
classidbased on the configuration
vendoridbased on the configuration
revrectemplatebased on the configuration
revrecstartdatedate
revrecenddatedate

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 FieldChargebee Source Field
arpaymentkeyid
paymentdateallocated_at
memo"Creditmemo applied over invoice"
overpaylocidnil
overpaydeptidnil
arpaymentitemsItems 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 FieldChargebee Source Field
arpaymentkeyid
paymentdatedate
memo"refund knockoff" + refund transaction id
overpaylocidnil
overpaydeptidnil
arpaymentitemsItems 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 FieldChargebee Source Field
bankaccountidpayment account code based on the configuration
paymentmethod"Cash"
memo"refund id -" + id
vendorIdbased on the configuration
paymentdatedate
paymentrequestitemslist 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 FieldChargebee Source Field
arpaymentkeyid
paymentdatedate
memo"payment apply"
overpaylocidbased on the configuration
overpaydeptidbased on the configuration
arpaymentitemsItems 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 FieldChargebee Source FieldAdditional information
arpaymentkeyId 
paymentdatedate 
memo"refund knockoff" + refund transaction id 
overpaylocidnilIf multicurrency feature is enabled, then overpaylocid is populated from the mapping.
overpaydeptidApplicable only for multi currency featureIf multicurrency feature is enabled, then overpaydepartid is populated from the mapping.
arpaymentitemsList of invoices for which this payment should applyMapping information provided in the table given below AR Payment Item.
Sage Intacct Target FieldChargebee Source Field
key"bill_" + id
paymentamountexchangerate * 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 FieldChargebee Source Field
cusIdid
invIdid
amountamount
ts - (timestamp)date
mtd - (payment method)based on the configuration Note: Mapping information provided in the table given below Payment Method Mapping.
refIddocumentnumber
tpIdrecordno
comment"Two way sync from intact Id :" + documentnumber + " internalid :" + recordno

Note:

A prefix is added if the field is configured.

Sage Intacct Target FieldChargebee Source Field
Credit card / Online Charge CardCARD
CashCASH
EFTBANK_TRANSFER
Printed CheckCHECK
If emptyCASH
If none of the aboveCHECK

Was this article helpful?