Sales Order Invoice object mapping
This page helps you understand the object and field mapping between Chargebee and Sage Intacct for Sales Order 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 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
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 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 | Mapping information provided in the table given below Line Item. |
subtotals | If 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 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 |
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 |
|---|---|---|
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 |
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 |
|---|---|
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 |
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 |
|---|---|
description | based on the configuration |
total | tax |
absval | tax |
locationid | based 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 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 |
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 |
|---|---|---|
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 |
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 |
|---|---|---|
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 |
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 | 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 |
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 |
|---|---|
description | based on the configuration |
total | tax |
absval | tax |
locationid | based 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 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?