Try smartlist Builder from eOne. You can pretty much do this report in there.
if you want to stay in SQL, you would need to create a view for a union between the 2 tables (open and History).
The smartlist builder has a wizard which does this for you automatically.
Don't bother using modifier or VB or even Dex. Use extender. I started using it, and basically, its a point and click that allows you to add fields, windows, forms etc to great plains with minimal problems. You can also add to smartlists and create searches too. It also links to core great...
There are a few people working with a Sales Logix integration to GP. Also depending on what you are using CRM software for, there are a few smaller ones that could do the job too.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.