Credit Invoice to Avalara Mappings

Here is a description of how fields and values from a credit invoice are mapped to an Avalara AvaTax transaction.

Notes:
  • When you calculate tax for a credit invoice, an uncommitted transaction is created in Avalara AvaTax. When you recalculate tax for a credit invoice, the existing transaction is replaced by a new one. The ID of the transaction is stored in the External Tax Transaction ID field on the credit invoice.
  • Some values are retrieved from the original invoice specified in the Invoicing field on the credit invoice.
Credit Invoice to Avalara Transaction Mappings

Avalara Transaction Field

Credit Invoice Value
Company Code Set to the value of the Company Code field. This is defined on the Tax Calculation Settings page. For more information, see OIM Tax Calculation Settings Fields.
Document Code Set to the value of the Credit Invoice Name field.
Document Type Set to "Return Invoice".
Document Date Set to the date on which the credit invoice was created.
Customer Code

Determined from the original invoice as follows:

  • If the Billing Account field is populated, the name of the specified account is used.
  • Otherwise, the name of the customer account specified in the Customer field is used.
Discount Set to zero.
Location Code Set to the value of the Avalara Location Code field.
Customer Exempt Number

Determined from the original invoice as follows:

  • If the Billing Account field is populated, this is set to the Exemption Certificate field of the billing account.
  • Otherwise, this is set to the Exemption Certificate field of the account specified in the Customer field.
Entity Use Code

Determined from the original invoice as follows:

  • If the Billing Account field is populated, this is set to the Tax Exemption Reason field of the account extension record related to the billing account.
  • Otherwise, this is set to the Tax Exemption Reason field of the account extension record related to the account specified in the Customer field.
Customer VAT Number Set to the Tax Registration Number field of the account specified in the Customer field on the original invoice.
Reference Code Set to the name of the original invoice.
Currency Set to the name of the currency master record specified in the Currency lookup field on the sales order or service contract related to the original invoice.
Override Tax This is selected.
Override Type Set to "Tax Date".
Tax Date Set to the Invoice Date field of the original invoice.
Override Reason Set to Credit Invoice.
Ship From

Determined from the warehouse of the sales order or service contract related to the original invoice as follows:

  • If the related warehouse contains an address, the address of the warehouse is used.
  • If the related warehouse does not contain an address, the address of the ICP related to the warehouse is used.
  • If a warehouse is not specified, the org address is used.
Ship To Set to the value of the ship-to fields of the original invoice.

Here is a description of how fields and values from a credit invoice line item are mapped to an Avalara AvaTax transaction line.

Notes:
  • Some values are retrieved from the original invoice line item that the credit invoice line relates to.
  • Credit invoice lines with a quantity of zero and lines of type "Tax" are not sent to Avalara.
Credit Invoice Line to Avalara Transaction Line Mappings

Avalara Transaction Field

Credit Invoice Line Value
Item Code Set to the value of the Credit Invoice Line Name field.
Item Description Set to the value of the Item Description field of the original invoice line item.
Quantity Set to the value of the Quantity field.
Total Amount Set to the value of the Amount field of the original invoice line item.
Avalara Tax Code Set to the value of the Avalara Tax Code field of the original invoice line item.
Include Line in Discount Calculations This is deselected.
Ship From

Determined from the original invoice line item as follows:

  • If the line item is linked to a service contract line that has a warehouse specified, the address of the warehouse is used.
  • If the warehouse linked to the service contract line does not contain an address, the address of its ICP is used.
  • Otherwise, the Ship From address of the credit invoice is used.
Ship To

Determined from the original invoice line item as follows:

  • If the Ship-to address fields are populated on the invoice line item, their values are used.
  • Otherwise, the Ship To address of the credit invoice is used.