In cases, Users want to track the Sales Order Total that excludes other charges such as Shipping, Tax, and Discount Amount and retain the Item Amount, they can run a Saved Search and use a Formula (Numeric) as Criteria to achieve it.
Here are the Criteria filters and Results fields you may add to your Saved Search:
1. On the Criteria Tab, under the Standard sublist, add the following filters:
- Type = Sales Order
- Main Line = True
2. On the Criteria Tab, under Summary sublist, add the filter:
Sum = Formula (Currency) is not 0 = nvl({totalamount},0)-nvl({discountamount},0)-nvl({taxtotal},0)-nvl({shippingamount},0)
3. On the Results Tab, add the following fields:
Field | Summary Type | Custom Label
- Name | Group
- Formula (Currency) | Sum | Total Sales Order Amount
- Formula = nvl({totalamount},0)-nvl({discountamount},0)-nvl({taxtotal},0)-nvl({shippingamount},0)
- Document Number
Note: You may add other necessary fields that you prefer.
This Saved Search will show summary results of Sales Orders that pull only the Item Amount.
I hope this helps! 😊
Share your Saved Search tips and tricks on the comments below!