Saturday, December 8, 2018

Sales Order Saved Search for Orders with Billing Address different from Shipping Address


Navigate to: Reports > Saved Searches > All Saved Searches > New > choose Transaction

Rename the Search Title for easy reference in the future.

Under Criteria tab > Standard sub tab > use below parameters:

*Filter                         *Description   Formula

Type                             is Sales Order

Main Line                      is true

Formula (Numeric)         is 1                   case when {billaddress}<>{shipaddress} then 1 else 0 end

Under Results tab > Columns sub tab > add below fields:

*Field                          Formula

Billing Address

Shipping Address

Formula (Numeric)         case when {billaddress}<>{shipaddress} then 1 else 0 end

Click on Save & Run button.

No comments:

Post a Comment