1. Navigate to Reports> Saved Searches > All Saved Searches> New
2. Choose Search Type “Transaction”
3. At the Criteria tab, set the following:
Filter
Description
Formula
Type
Is Invoice
Main Line
Is true
Formula (Numeric)
Is 1
Case When {shipaddress} != {custbody_end_user_default_ship_address} then 1 else 0 end
Date
Depends on the date range that the users need for the report.
4. At The Results tab, there are already default fields. However, users may add other Results fields needed for their report. Add the following:
o End User Default Shipping Address (Custom)
o Shipping Address
Note: This report is useful for Avatax purposes if users need to export to Microsoft Excel the End User Ship to Address found in the Invoice.