I'm curious if this is unique to our environment or if anyone else receiving this error. Adding the Master Number column to the Sales Transactions Smartlist in GP 2015R2, then attempting to search on the Master Number yields me "Unhandled script exception: Bad power value EXCEPTION_CLASS_SCRIPT_OUT_OF_RANGE SCRIPT_CMD_POWER". When I click OK the search bails and I don't get expected results.
I've found a citation to this same error that suggests changing the data type resolves it. I do have a custom Smartlist that I added Master Number to and received the same error. I had the luxury of changing the data type of the Master Number to string, as the found citation indicated, and this resolved the error in my custom Smartlist. I am not aware of how to change the data type on a column in a stock GP Smartlist like Sales Transactions.
Any information to share about resolving this would be appreciated.
*This post is locked for comments
The standard Sales Transaction Smartlist I have in GP has no formatting for the Master Number field. What's odd is in checking that I clicked to "Modify" the Smartlist, then removed the modified Smartlist. That seemed to solve my problem as it works now. I think there's issues with modifying existing Smartlists as we had another problem with 1/1/1900 dates when someone else modified another existing Smartlist.
14.00.0952(GP2015R2)
Added Master Number to Sales Transaction Smartlist.
Then used the Master Number Field to search and it worked fine when I tried it.
Then tried each of the conditions (begins with, contains, etc), they too worked normally.
I then did some thinking and research and changed the master number display option to show comma as a separator. On attempting the search again I now got the same exception as you.
i wrote it up in a blog post:
Essentially remove any field formatting from the master number field and it should work again.
Tim
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156