I need to generate a list to display all items that were created in the previous quarter regardless of whether they actually had sales. Meaning if item ABC had 3 sales I would report 3 but if item XYZ did not sell it would be in the search with either blanks or zero for the quantity sold.
I did try to use this post:
http://usergroup.netsuite.com/users/showthread.php?t=23073
but it references an inventory search and I do not have that as an option when creating a new search. I tried the formula on a normal item search but kept coming up with invalid formula in the results.
To quote the thread "Did you try an inventory search, grouped by item. You can use a formula with {transaction.type} and {transaction.trandate} to identify the maximum sales order date. Something like
max(case when {transaction.type}='Sales Order' then transaction.trandate})
This should will include items that have no transaction at all."
The only way I can get sales quantities (that I know of) is in transaction search and if an item has never been in the transaction I am using, it is not returned.
There is an Inventory Activity report but is way too user unfriendly for what we are trying to do. We just need total sold and not all possible transactions.
All help and suggestions are appreciated.
:h_a_w: