Sales Order Invoice object mapping 

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

  • discount_amount

  • If you want a separate discount on invoice and line items:

    • itemLevelDiscountAmount

    • invoiceLevelDicountAmount (itemLevelDiscountAmount - discount_amount)

The maximum allowed decimals are 4

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

  • discount_amount

  • If you want a separate discount on invoice and line items:

    • itemLevelDiscountAmount

    • invoiceLevelDicountAmount (itemLevelDiscountAmount - discount_amount)

The maximum allowed decimals are 4

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