Docs

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

Sales Order Invoice object mapping

This page helps you understand the objects and field mapping between Chargebee and Sage Intacct for Sales Order 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 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 finally to the id. The maximum allowed characters are 99
displaycontactSee mapping information in the Display Contact table.
billtoid + "_billto"The maximum allowed characters are 99
shiptoid + "_billto"The maximum allowed characters are 99
contactinfocompany first_name + last_name idFirst 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 FieldChargebee Source FieldAdditional information
printascompany first_name + last_name idFirst preference is given to the company, then first_name+last_name, and finally to the id. The maximum allowed characters are 99
contactnamecompany first_name + last_name idFirst preference is given to the company, then first_name+last_name, and finally to the id. The maximum allowed characters are 99
companynamecompanyThe maximum allowed characters are 99
firstnamefirst_nameThe maximum allowed characters are 40
lastnamelast_nameThe maximum allowed characters are 40
phone1phoneThe maximum allowed characters are 30
email1emailThe maximum allowed characters are 100
mailaddressSee mapping information in the Mail Address table.

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 FieldChargebee Source FieldAdditional information
address1line1The maximum allowed characters are 255
address2line2The maximum allowed characters are 255
citycityThe maximum allowed characters are 80
statestateThe maximum allowed characters are 40
countrycountryThe maximum allowed characters are 60
zipzipThe 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 FieldChargebee Source FieldAdditional information
namesku nameFirst preference is given to sku, and the next preference to name
productLineidbased on the configuration 
extended_descriptiondescription 
itemidsku idFirst preference is given to sku, and the next preference to id
glgroupaccounting_codeThe glgroup field will be populated if accounting_code is of type ITEMGLGROUP, otherwise incomeacctkey
itemtype"Non-Inventory (Sales only)" 
incomeacctkeyaccounting_code

Invoice

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

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.

Sales Order (SO) Invoice

The following table provides information on the sales order invoice 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
transactiontypeConfigured transaction definition type 
datecreateddate 
customeridid 
documentnoidPrefix configured for INVOICE else, default prefix of the SITE will be populated.
dateduedueDate 
shiptoid+ "_shipto" 
billtoid+ "_billto" 
basecurrbaseCurrencyCodeIf a merchant has multiple base currency in Chargebee and multiple entities (with different currency in Intacct) and if multi currency is also enabled, then the base currency is determined based on the locationid configured. Otherwise base currency at Chargebee is considered , or this can be overridden using "override_basecurrency" additional setting.
currencycurrencyCodeInvoice currency code
exchratetype"Intacct Daily Rate" 
sotransitemsList of Invoice line itemsSee mapping information in the Line Item table.
subtotalsIf sub total is configured, tax amount will be mapped as subtotal 

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 FieldChargebee Source FieldAdditional information
itemdescdescription 
itemidid 
taxableis_taxed 
ationidaccountingCategory2 OR based on the configurationFor multiple base currency feature, location id is populated based on the invoice currency code.
quantityquantityThe maximum allowed decimals are 4
priceunit_amountThe maximum allowed decimals are 4
unit"Each" 
departmentidbased on the configuration 
revrectemplateaccountingCategory1 OR based on the configuration 
revrecstartdatedate_from 
revrecenddatedate_to 
projectidbased on the configuration 
customeridbased on the configuration 
vendoridbased on the configuration 
employeeidbased on the configuration 
classidbased 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 FieldChargebee Source FieldAdditional information
temdescdescription 
itemidid 
taxableis_taxed 
locationidbased on the configuration 
quantity1The maximum allowed decimals are 4
pricediscount_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
departmentidbased on the configuration 
revrectemplateid 
revrecstartdatedate 
revrecenddatedate 

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 FieldChargebee Source Field
itemdesc"Roundoff value"
itemid 
taxablefalse
locationidbased on the configuration
quantity1
priceprice
departmentidbased on the configuration
revrectemplatebased on the configuration
revrecstartdatedate
revrecenddatedate
projectidbased on the configuration
customeridbased on the configuration
vendoridbased on the configuration
employeeidbased on the configuration
classidbased on the configuration

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 FieldChargebee Source Field
descriptionbased on the configuration
totaltax
absvaltax
locationidbased on the configuration

Intacct Negative Invoice - Credit Memo

Note:

  • Source entity - Chargebee Credit Note
  • Supported actions - Create

Sales Order Credit Notes

The following table provides information on the SO credit notes 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
transactiontypeTransaction definition type based on the configuration 
datecreateddate 
customeridid 
documentnoid 
shiptoid+ "_shipto" 
billtoid+ "_billto" 
basecurrbaseCurrencyCodeIf a merchant has multiple base currency in Chargebee and multiple entities (with different currency in Intacct) and if multi currency is also enabled, then the base currency is determined based on the locationid configured. Otherwise base currency at Chargebee is considered , or this can be overridden using "override_basecurrency" additional setting.
currencycurrencyCode 
exchratetype"Intacct Daily Rate" 
sotransitemsList of Invoice line item

Mapping information provided in the table given below:

subtotalsIf sub total is configured, tax amount will be mapped as subtotal 

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 FieldChargebee Source FieldAdditional information
itemdescdescription OR "Write off item : " + descriptionIf Credit_note reason is WRITE_OFF, then "Write off item : " + description
itemidid 
taxableis_taxed 
locationidaccountingCategory2 OR based on the configuration 
quantityquantityThe maximum allowed decimals are 4
priceunit_amountThe maximum allowed decimals are 4
departmentidbased on the configuration 
revrectemplatebased on the configuration OR accountingCategory1 
revrecstartdatedate_from 
revrecenddatedate_to 
projectidbased on the configuration 
customeridbased on the configuration 
vendoridbased on the configuration 
employeeidbased on the configuration 
classidbased 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 FieldChargebee Source FieldAdditional information
itemdescdescription 
itemidid 
taxableis_taxed 
locationidbased on the configuration otherwise, it is not applicable 
quantity1The maximum allowed decimals are 4
pricediscount_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
departmentidbased on the configuration 
revrectemplateid 
revrecstartdatedate 
revrecenddatedate 

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 FieldChargebee Source FieldAdditional information
itemdesc"Roundoff value" 
itemidbased on the configuration 
taxablefalse 
locationidbased on the configuration 
quantity1The maximum allowed decimals are 4
pricepriceThe maximum allowed decimals are 4
departmentidbased on the configuration otherwise, it is not applicableFor the multiple base currency feature, departmentid is populated based on the invoice currency code.
revrectemplatebased on the configuration 
revrecstartdatedate 
revrecenddatedate 
projectidbased on the configuration 
customeridbased on the configuration 
vendoridbased on the configuration 
employeeidbased on the configuration 
classidbased on the configuration 

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 FieldChargebee Source Field
descriptionbased on the configuration
totaltax
absvaltax
locationidbased on the configuration

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.
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 FieldChargebee Source Field
invoicekeyid
amountallocated_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 FieldChargebee Source Field
customeridid
datecreateddate
adjustmentnoid + "_" + transaction_id
invoicenonull
basecurrbaseCurrencyCode
currencycurrency
exchratedatedate
exchratetype"Intacct Daily Rate"
taxsolutionidIf tax solution is enabled in configuration settings, fetch tax solutionid from configuration
aradjustmentitemsList 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 FieldChargebee Source FieldAdditional information
glaccountnorefund_clearingaccount 
amountamount_refundedamount_refunded of credit_note
memo"refund" 
locationidbased on the configuration otherwise, it is not applicableFor multiple base currency feature, locationid populated based on the invoice currency code
departmentidbased on the configuration 
itemidbased on the configuration 
taxentriesList of Zero Rated Tax EntriesMapping 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 FieldChargebee Source Field
trx_tax0
detailidtax 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 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.
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 FieldChargebee Source Field
invoicekeyid
amountallocated_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 FieldChargebee Source Field
vendoridbased on the configuration
datecreateddate
dateduedate
billno"refund_" + id
description"refund id -" + id
basecurrbase_currency_code
currencycurrency
exchratedatedate
exchratetype"Intacct Daily Rate"
taxsolutionidbased on the configuration
billitemsList 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 FieldChargebee Source Field
glaccountnorefund_clearingaccount
amountamount
locationidbased on the configuration
taxentriesNote: 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 FieldChargebee Source Field
trx_tax0
detailidbased 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 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.
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 FieldChargebee Source Field
key"bill_" + id
paymentamountexchangerate * 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 FieldChargebee Source FieldAdditional information
customeridid  
paymentamountamount 
translatedamountamount OR exhangerate * amountIf basecurrency is same as transaction currency, then the transaction amount is considered. Otherwise, the product of exhangerate and transaction amount is considered.
bankaccountidbased on the configuration 
refidid 
overpaylocidbased on the configuration 
overpaydeptidbased on the configuration 
datereceiveddate 
paymentmethodbased on the configurationMapping information provided in the table given below Payment Method Mapping.
basecurrbase_currency_code 
currencycurrency_code 
exchratedatedate 
exchratetype"Intacct Daily Rate" 
arpaymentitemList of ARPaymentsMapping 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 FieldChargebee Source Field
invoicekeyid
amountamount

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 FieldChargebee Source Field
EFTAMAZON_PAYMENTS
Credit cardCARD
CashCASH
EFTPayPal_EXPRESS_CHECHOUT
EFTBANK_TRANSFER
EFTCHARGEBACK
Printed CheckCHECK
EFTDIRECT_DEBIT
CashOTHER
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 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.
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 FieldChargebee Source Field
invoicekeyid
amountamount

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 FieldChargebee Source Field
customeridid
datecreateddate
adjustmentnoid + "_refund"
invoicenonull
basecurrbaseCurrencyCode
currencycurrency
exchratedatedate
exchratetype"Intacct Daily Rate"
taxsolutionidIf tax solution is enabled during configuration, fetch taxsolutionid from configuration
aradjustmentitemsList 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 FieldChargebee Source FieldAdditional information
glaccountnorefund_clearingaccount based on the integration configuration 
amountamount_refunded 
memo"refund" 
locationidbased on the configuration otherwise, it is not applicableFor multiple base currency feature, locationid is populated based on the credit note/transaction currency code
departmentidbased on the configuration otherwise, it is not applicableFor multiple base currency feature, departmentid is populated based on the credit note/transaction currency code
itemidbased on the configuration otherwise, it is not applicable 
taxentrieslist of zero rated tax entriesMapping 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 FieldChargebee Source Field
trx_taxtax
detailidtax 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 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.
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 FieldChargebee Source Field
invoicekeyar adjustment id created corresponding to refund
amountamount_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 FieldChargebee Source Field
vendoridbased on the configuration
datecreateddate
dateduedate
billno"refund_" + id
description"refund id -" + id
basecurrbase_currency_code
currencycurrency
exchratedatedate
exchratetype"Intacct Daily Rate"
taxsolutionidbased on the configuration
billitemsList 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 FieldChargebee Source FieldAdditional information
glaccountnorefund_clearingaccount 
amountamount 
locationidbased on the configurationFor 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 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.
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 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

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 FieldChargebee Source Field
Credit card / Online Charge CardCARD
CashCASH
EFTBANK_TRANSFER
Printed CheckCHECK
If emptyCASH
If none of the aboveCHECK

Was this article helpful?