AvaTax Sales Invoice Mapping

GFERP__Sell_to_Customer__r.Is_Seller_Importer_Of_Record__c

isSellerImporterOfRecord

GFERP__Sell_to_Customer__r.AVA_MAPPER__Exemption_Number__c

exemptionNo

Account.AVA_MAPPER__Business_Identification_Number__c

businessIdentificationNo

GFAVA__Entity_Use_Code_to_Use__c

with formula: GFAVA__Entity_Use_Code_Override_r.Name if it is blank,

or use GFERP__Alternate_Shpping__r.GFAVA__Entity_Use_code__r.Name, or GFERP__Sales_Order__r.GFAVA__Entity_Use_Code_to_Use__c. If it is blank, use

GFERP__Sell_to_Customer__r.AVA_MAPPER__Entity_Use_code__r.Name

customerUsageType

yes

Account.AccountNumber

customerCode

yes

GFERP__Shipping_Street__c

ShipTo Line1

yes

GFERP__Shipping_City__c

ShipTo City

yes

GFERP__Shipping_State__c

ShipTo Region

yes

GFERP__Shipping_Postal_Code__c

ShipTo PostalCode

yes

GFERP__Shipping_Country__c

ShipTo Country

yes

GFERP__Warehouse__r.GFERP__Street__c

ShipFrom Line1

yes

GFERP__Warehouse__r.GFERP__City__c

ShipFrom City

yes

GFERP__Warehouse__r.GFERP__State__c

ShipFrom Region

yes

GFERP__Warehouse__r.GFERP__Postal_Code__c

ShipFrom PostalCode

yes

GFERP__Warehouse__r.GFERP__Country__c

ShipFrom Country

yes

Invoice Date

documentDate

yes

AVA_SFCLOUD.GetAvaTaxDocStatus

AvaTax_Doc_Status__c

Hard code to “Calculated”

AVA_SFCLOUD.GetAvaTaxMessage

AvaTax_Message__c

From Avalra

AVA_SFCLOUD.GetInvoiceMessage

Invoice_Message__c

Not used

Tax Calculated Date/Time

Current Date/Time

Tax Calculated

Yes