Invoicing to Avalara Mappings
Here is a description of how fields and values from an invoice are mapped to an Avalara AvaTax transaction.
Avalara Transaction Field |
Invoicing 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 SCM Tax Calculation Settings Fields. |
Document Code | Set to the value of the Invoice Number field. |
Document Type | Set to "Sales Invoice". |
Document Date | Set to the value of the Invoice Date field. |
Customer Code |
Determined as follows:
|
Discount | If the Applied Discount field is greater than zero, its value is used. Otherwise, this is set to zero. |
Location Code | Set to the value of the Avalara Location Code field. |
Customer Exempt Number |
Determined as follows:
|
Entity Use Code |
Determined as follows:
|
Customer VAT Number | Set to the Tax Registration Number field of the account specified in the Customer field on the invoice. |
Currency | Set to the name of the currency master record specified in the Currency lookup field of the related sales order or service contract. |
Ship From |
Determined from the warehouse of the related sales order or service contract as follows:
|
Ship To | Set to the value of the ship-to fields. |
Here is a description of how fields and values from an invoice line item are mapped to an Avalara AvaTax transaction line.
Avalara Transaction Field |
Invoice Line Item Value |
---|---|
Item Code |
Determined as follows:
|
Item Description | Set to the value of the Item Description field. |
Quantity | Set to the value of the Quantity field. |
Total Amount |
Determined as follows:
|
Avalara Tax Code |
Determined as follows:
|
Include Line in Discount Calculations |
Determined as follows:
|
Ship From |
Determined as follows:
|
Ship To |
Determined as follows:
|