Tuesday, July 8, 2008

Bug: SmartLists Builder not Formatting SQL Correctly in Microsoft Dynamics GP 10

It appears that SLB cannot format the SQL query required to extract data after adding a few restrictions. Specifically, any query requiring more than one restriction will ommit the AND operator. This has been documented under Problem report 47625: Restrictions don't work if have more than one on a SmartList which is currently scheduled to be resolved in v10 SP3.

"If you want it fixed earlier in a hotfix, I would suggest that you log a support case and reference the bug number. The more customers who request the fix, the higher the priority will be", said David Musgrave, Microsoft Escallation Engineer in a Microsoft Dynamics GP community post.

Until next post!

MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/

2 comments:

Anonymous said...

Hello,

Do you know if this bug did, in fact, end up getting resolved in either GP SP3 or GP SP4?

Mariano Gomez said...

This issue was resolved in SP3.

MG.-
Mariano Gomez, MVP