Customizing Avalara AvaTax Tax Calculation Mappings
If you have specified that you want to use the FDN Mappings component to define mappings for Avalara tax calculation, you can view or update the mappings from the Manage External Tax Calculation Mappings link on the Billing Central Task Launcher.
Default Mappings
The following mappings are provided by default.
Source Object |
Source |
Target (Avalara) |
---|---|---|
Billing Document | Company > Code | Company Code |
Document Number | Document Code | |
Document Date | Document Date | |
Account > Account Extension (first related record) > Tax Exemption Reason | Customer Usage Type | |
Account > Exemption Certificate | Exemption Number | |
Billing Account or Shipping Account Billing account is used unless a shipping address is specified, when shipping account is used. |
Customer Code | |
Currency ISO Code | Currency ISO Code | |
Company > City, Country, State/Province, Street, Zip/Postal Code | Ship From Address | |
Billing Address or Shipping Address (City, Country, State/Province, Street, Zip/Postal Code) Billing address is used unless a shipping address is specified. |
Ship To Address | |
Billing Document Line Items | Document Line | Line Number |
Product or Service > Product Code | Item Code | |
Product or Service > Product Extension (first related record) > External Tax Code | Tax Code | |
Shipping Account > Account Extension (first related record) > Tax Exemption Reason | Customer Usage Type | |
Quantity | Quantity | |
Net Value | Amount | |
Description or Product Name
Product name is used unless line description is provided |
Description | |
Company Site > City, Country, State/Province, Street, Zip/Postal Code | Ship From Address | |
Shipping Address (City, Country, State/Province, Street, Zip/Postal Code) | Ship To Address |
Customizing Mappings
If required, you can customize mappings by adding additional mappings or updating the information sources.
Additional Properties
An additional Create Transaction property is available for custom mappings.
Overriding Properties
You can override managed mappings or add mappings for additional supported properties.
You can add a custom mapping that contains a unique target field, or for child relationship mappings, a unique target field and target child type. If a managed mapping exists with the same information, the custom mapping overrides it.
If an overridden managed mapping contains child mappings, these are rendered obsolete. If the overriding custom mapping is subsequently removed, the managed mapping and its children are automatically reinstated.
Overridden mappings are displayed in the mappings table with the following information appended to the target:
- (Overridden) indicates that the managed mapping has been overridden by a custom mapping.
- (Parent Overridden) indicates that a parent of the mapping has been overridden by a custom mapping.
For more information about how to add or customize mappings, see