Monday, June 10, 2019

Transaction Search where Billing Address is same as Shipping Address

Steps to create the saved search:

1. Lists > Accounting > Search> Saved Searches > New

2. Select Transactions

3. Set the following Criteria:

Transaction Type: Sales Order
Formula (Numeric)
Formula: case when {billaddress} like {shipaddress} then 1 else 0 end
Formula (Numeric) = equal to
Value = 1

4. Preview


 

No comments:

Post a Comment