To find out how are Discounts taken on the Sales Order reflected on Saved Searches please read the following for three different scenarios:
1. Discount Taken on the Header Level
On the Sales Order if the Discount is on the header level you are able to utilize the Amount Net field on the Results tab of the Saved Search to display the average sales price. For example two items that cost $300.00 each with a $120.00 discount the Amount Net field will display $240.00 for the line items.
2.Discount Taken on Item Level using a - 'Non-Posting' Discount Item
When using a Discount line item that has the Account set to Non-posting (Item Record > Accounting tab) the discount gets reflected on the item right above it.
For example:
Item 1: $300.00
Discount: $120.00
Item 2: $300.00
When using a Item Level Non-Posting account on a Saved Search it will display Item 1: with a value of $180.00 and display Item 2 as $ 300.00
3. Discount Taken on Item Level - Posted to an Account Discount Item
When using the Discount line item that is posted to a specific Account (Item Record > Accounting tab) the Discount Line Item is reflected as its own individual item and will not be subtracted from the specific items and this is by design because it has its own specific line on the Sales Order. For example if the following Items are on the Sales Order:
Item 1: $300.00
Item 2: $300.00
Discount Item: $120.00
On a Saved Search all three items will appear on their own separate line.