I have attempted to use the below SuiteAnswers response and the mentioned second reference but neither have been able to populate the information I am seeking. I need a Saved Search that will display inventory which has not been sold within a given time frame, for example 1/18/2016 - 2/1/2016 and I need the results to be Item Name,Display Name, Average price & Other Prices. When I use the examples below the information displayed is items included in a Sales Order, not items not included within the chosen time frame. Can anyone suggest a resolution for this? Or a formula which will execute the information I desire?
[COLOR=#888888]Answer Id: 38028[/COLOR]
[FONT=Verdana !important][FONT=verdana]1. Navigate to Lists > Search > Saved Search > New > Item[/FONT]
[FONT=verdana]2. Navigate to Criteria tab > Summary subtab:[/FONT]
[FONT=verdana]Summary Type: Maximum | Field: Formula (Date) | Formula: max(case when {transaction.type}='Sales Order' then {transaction.trandate} end) |Value: is empty[/FONT]
[FONT=verdana]3. Results Tab: Remove all Fields and add below Field[/FONT]
[FONT=verdana]--Name > Summary Type: Group[/FONT]
[FONT=verdana]Save & Run[/FONT]
[FONT=verdana]Notes:[/FONT]
[FONT=verdana]1. This search can also be used for other transaction types such as Purchase Orders, Transfer Orders etc. Just change the formula expression under the Criteria tab with the desired Transaction Type.[/FONT]
[FONT=verdana]2. Another variation of this search is documented under SuiteAnswer ID:13357 > Search for Items with no sales transactions for a particular period[/FONT][/FONT]