Docs
You are viewing:
Product Catalog 1.0
This page helps you understand the objects and field mapping between Chargebee and Sage Intacct for Sales Order Invoice.
Note:
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 |
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 | — | See mapping information in the Mail Address table. |
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 |
Note:
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 |
Sales Order (SO) Invoices are created in Sage Intacct by default. AR Invoices are created when Tax Solution is enabled.
Note:
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.
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 Field | Chargebee Source Field | Additional information |
---|---|---|
transactiontype | Configured transaction definition type | |
datecreated | date | |
customerid | id | |
documentno | id | Prefix configured for INVOICE else, default prefix of the SITE will be populated. |
datedue | dueDate | |
shipto | id+ "_shipto" | |
billto | id+ "_billto" | |
basecurr | baseCurrencyCode | If 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. |
currency | currencyCode | Invoice currency code |
exchratetype | "Intacct Daily Rate" | |
sotransitems | List of Invoice line items | See mapping information in the Line Item table. |
subtotals | If sub total is configured, tax amount will be mapped as subtotal |
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 |
---|---|---|
itemdesc | description | |
itemid | id | |
taxable | is_taxed | |
ationid | accountingCategory2 OR based on the configuration | For multiple base currency feature, location id is populated based on the invoice currency code. |
quantity | quantity | The maximum allowed decimals are 4 |
price | unit_amount | The maximum allowed decimals are 4 |
unit | "Each" | |
departmentid | based on the configuration | |
revrectemplate | accountingCategory1 OR based on the configuration | |
revrecstartdate | date_from | |
revrecenddate | date_to | |
projectid | based on the configuration | |
customerid | based on the configuration | |
vendorid | based on the configuration | |
employeeid | based on the configuration | |
classid | based on the configuration |
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 |
---|---|---|
temdesc | description | |
itemid | id | |
taxable | is_taxed | |
locationid | based on the configuration | |
quantity | 1 | The maximum allowed decimals are 4 |
price | discount_amount OR item_level_discount_amount - discount_amount |
|
departmentid | based on the configuration | |
revrectemplate | id | |
revrecstartdate | date | |
revrecenddate | date |
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 |
---|---|
itemdesc | "Roundoff value" |
itemid | |
taxable | false |
locationid | based on the configuration |
quantity | 1 |
price | price |
departmentid | based on the configuration |
revrectemplate | based on the configuration |
revrecstartdate | date |
revrecenddate | date |
projectid | based on the configuration |
customerid | based on the configuration |
vendorid | based on the configuration |
employeeid | based on the configuration |
classid | based on the configuration |
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 |
---|---|
description | based on the configuration |
total | tax |
absval | tax |
locationid | based on the configuration |
Note:
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 Field | Chargebee Source Field | Additional information |
---|---|---|
transactiontype | Transaction definition type based on the configuration | |
datecreated | date | |
customerid | id | |
documentno | id | |
shipto | id+ "_shipto" | |
billto | id+ "_billto" | |
basecurr | baseCurrencyCode | If 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. |
currency | currencyCode | |
exchratetype | "Intacct Daily Rate" | |
sotransitems | List of Invoice line item | Mapping information provided in the table given below: |
subtotals | If sub total is configured, tax amount will be mapped as subtotal |
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 |
---|---|---|
itemdesc | description OR "Write off item : " + description | If Credit_note reason is WRITE_OFF, then "Write off item : " + description |
itemid | id | |
taxable | is_taxed | |
locationid | accountingCategory2 OR based on the configuration | |
quantity | quantity | The maximum allowed decimals are 4 |
price | unit_amount | The maximum allowed decimals are 4 |
departmentid | based on the configuration | |
revrectemplate | based on the configuration OR accountingCategory1 | |
revrecstartdate | date_from | |
revrecenddate | date_to | |
projectid | based on the configuration | |
customerid | based on the configuration | |
vendorid | based on the configuration | |
employeeid | based on the configuration | |
classid | based on the configuration |
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 |
---|---|---|
itemdesc | description | |
itemid | id | |
taxable | is_taxed | |
locationid | based on the configuration otherwise, it is not applicable | |
quantity | 1 | The maximum allowed decimals are 4 |
price | discount_amount OR item_level_discount_amount - discount_amount |
|
departmentid | based on the configuration | |
revrectemplate | id | |
revrecstartdate | date | |
revrecenddate | date |
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 | Additional information |
---|---|---|
itemdesc | "Roundoff value" | |
itemid | based on the configuration | |
taxable | false | |
locationid | based on the configuration | |
quantity | 1 | The maximum allowed decimals are 4 |
price | price | The maximum allowed decimals are 4 |
departmentid | based on the configuration otherwise, it is not applicable | For the multiple base currency feature, departmentid is populated based on the invoice currency code. |
revrectemplate | based on the configuration | |
revrecstartdate | date | |
revrecenddate | date | |
projectid | based on the configuration | |
customerid | based on the configuration | |
vendorid | based on the configuration | |
employeeid | based on the configuration | |
classid | based on the configuration |
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 |
---|---|
description | based on the configuration |
total | tax |
absval | tax |
locationid | based on the configuration |
A credit note is applied over different invoices by AR payment linked to invoices over Intacct credit notes.
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. |
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 |
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. |
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. |
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 |
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. |
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 |
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. |
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. |
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 |
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. |
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 |
Chargebee Transactions include payments, refunds, and offline payments.
Payments include creating AR Payment and applying AR Payment objects.
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. |
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 |
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 |
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. |
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 |
Payments include creating AR Adjustment and AR Adjustment Line Items objects.
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. |
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. |
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 |
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. |
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 |
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. |
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. |
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. |
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 |
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 |
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?