
Hello,
So I previously did a report for my company that showed the hit ratio (successful quotes transferred to orders) by using the original number. I'm now requested to do a quarterly report for this data, but here's where the problem arises.
When I pull the same smartlist (SOP Type = Invoice; Document Date = Range etc.) the smartlist is no longer pulling all of the Orders. Any order that has been transferred into an invoice is now missing, giving me a misrepresentation of values.
Does anyone know how to pull a list that shows every order entered between my selected range of dates?
Tahnks!
*This post is locked for comments
I have the same question (0)If you limit Smartlist to "SOP Type" = "Invoice" then Smartlist is going to omit all "SOP Type" = "Order" records.
You can try SOP Type "between" Order and Invoice, but I am not sure if that will work.