Address validation occurs – The order amount, misc. charges, and freight charges in the attribute will be set to zero.
- If validation is unsuccessful, the attribute for the order will not be created and if it exists only the address will be updated.
- If validation is successful but there are no suggested changes, the attribute will be created with the address as entered.
- If validation is successful and the user accepts the changes, the attribute will be created with the accepted address.
- If validation is successful and the user rejects the changes, the attribute will be created with the original address.
Tax calculation occurs during billing when the payment window is presented or when the picking ticket is printed –
- If the attribute exists and all of the fields match, taxes are not recalculated for a “SalesOrder” type transaction.
- If the attribute exists and any of the fields don’t match, taxes are recalculated for a “Sales Order” type transaction.
- If the attribute does not exist, taxes are calculated for a “Sales Order” type transaction. The attribute will be created and will store the
order amount, misc. charges, and freight charges
.
_AVATAXFINAL
- Reference 1 – Address line 1
- Reference 2 – Address line 2
- Reference 3 – City
- Reference 4 – State
- Reference 5 - Zip Code
- Amount 1 – Order Amt
- Amount 2 – Misc Charges
- Amount 3 – Freight charges
- Check Box 1 – Taxable?
- Check Box 2 –
Used TaxCd ON030000?
AVATAXFINAL will be created for the order when invoices are printed (“SalesInvoice” transaction type).
Final Tax calculation occurs during invoice printing. The attribute is created indicating the information that was used when calculating taxes. If everything goes as expected, this attribute should contain same data as in _AVATAXSNAPSHOT attribute. The Elliott design will allow invoice printing even if there's no internet connection. The existence of this attribute indicates there was a successful communication to Avalara during invoice printing which is the final step before committing to Avalara. Hence this attribute will influence Elliott's later on processing. To ensure the integrity between this attribute and order status, if an invoice is voided, this attribute is deleted so taxes will be recalculated when the invoice is printed again. If a duplicate invoice is printed and this attribute exist, taxes will not be calculated again.
_USECODE
Use codes are used to determine why a customer is exempt
from taxes. Use Codes can be assigned at the customer type, customer, ship-to
and order levels. When determining the use code for an order, a hierarchy will
be applied. If the order contains a ship-to and a use code has been assigned to
the ship-to, the use code will be assigned to the order. If no ship-to use code
has been assigned or the user is not using a ship-to, the application will
check for a customer use code. If the use code does not exist, the application
will check for a customer type use code. If the use code has not been defined
the Avalara Global Setup Default, Cust Exempt Use Code will be used as the
default. The use code can manually be defined at the order header level.
_GOODSERVICES
- Reference 1 – Tax Code (Goods and Services Code)
Avalara's Tax codes are used to determine what tax category an item belongs to for taxing purposes. Tax codes can be assigned at the product category, user-defined code and item levels. When creating an order, a hierarchy will be applied. If no tax code exists for the item, the application will check for a user-defined code tax code. If the tax code does not exist, the application will check for product category tax code. If the tax code has not been defined, the Avalara Global Setup Default Item Tax Code will be used as the default.
_TAXBREAKDOWN00 (through 04)
- Reference 1 – jurisCode
- Reference 2 – jurisType (00=Country, 01=State, 02 = County, 03 = City, 04 = Special)
- Reference 3 – jurisName
- Reference 4 – taxType
- Amount 1 – taxableAmount
- Amount 2 – taxCalcuated
- Amount 3 - rate
Used to record the Tax Breakdown at the Order Header and the Order Line Item file levels. When added to the Order Header file, it is a total per jurisdiction code. This is attached to the order when taxes are calculated with the order number as the document number of reference. When invoices are printed, tax will be recalculated and will update the attributes attached to the Order Header and Order Line Item tables using the order number. Once the invoice is posted, they will then be keyed using the invoice number.
_TAXBREAKDOWN09 (used for retail delivery fee)
- Reference 1 – jurisCode
- Reference 2 – jurisType (00=Country, 01=State, 02 = County, 03 = City, 04 = Special)
- Reference 3 – jurisName
- Reference 4 – taxType
- Amount 1 – taxableAmount
- Amount 2 – taxCalcuated
- Amount 3 - rate
_CALCAVALARA
This attribute will be stored for the customer, ship-to or location. The purpose is to determine if address had been validated which is implied by the existence of the attribute and the matching of address. If so, there's no need to validate address again to prevent excessive communication with Avalara web services.
- Reference 1 – Notes concerning any failures encountered during tax calculation or address check
- Reference 2 – Notes Continued
- Reference 3 – Resolution Quality
- Reference 4 - Address 1
- Reference 5 - City, State & Zip Code
- Amount 1 – Latitude
- Amount 2 - Longitude
- Checkbox 1 – Elliott Zip Checked
- Checkbox 2 – Avalara Addr Checked
- Checkbox 3 – Foreign Address
This attribute is created when running the utility programs to mass update the customer, ship-to, or location. It will be updated also when adding a customer or ship-to manually. General speaking, this attribute is not saved for the order unless the ship-to address is manually entered (i.e. drop ship.)
CLS