Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Smartlist that shows a...

Smartlist that shows all orders

(0) Share

Report

Posted on by Community Member

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

All responses (1)

Answers (0)

GMA 1,074 on at

Like (0)

Report

RE: Smartlist that shows all orders

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.