Sales Order Search to Display Shipping and Handling Amounts in Columns

This is only possible when the shipping account is different from the handling account.

1. Navigate to Reports > Saved Searches > All Saved Searches > New.

2. Select Transaction in the list.

3. Rename the Search Title.

4. Under the Criteria tab, Standard subtab, set the following filters:
*Type is Sales Order
*Main Line is false
*Tax Line is false
*Shipping Line is true
*
5. Under the Results tab, Columns subtab, select the following fields:
*Number | Summary Type = Group
*Date | Summary Type = Group
*Name | Summary Type = Group
*Amount | Summary Type = Sum
*Formula (Numeric) | Function = Round to Hundredths | Formula = case when {account} = 'shipping account name' then {amount} else 0 end | Summary Label = Shipping Cost
*Formula (Numeric) | Function = Round to Hundredths | Formula = case when {account} = 'handling account name' then {amount} else 0 end

6. Under the Results tab, put a check mark in the Show Totals box.

7. Click the Save and Run button.