After version Epicor 10.1.500 to 10.2.500 Dashboard “Bad SQL Statement”

Epicor ERP 10
1

So i have this query Dashboard a problem “Bad SQL Statement” :
2020-01-24_9-25-36

2020-01-24_9-25-52
2020-01-24_9-25-521036×744 110 KB
2020-01-24_9-39-56
2020-01-24_9-39-561600×860 425 KB
2020-01-24_9-40-08
2020-01-24_9-40-081600×860 422 KB
2020-01-24_9-40-17
2020-01-24_9-40-171600×860 424 KB
2020-01-24_9-49-53
2020-01-24_9-49-531600×860 462 KB
2020-01-24_9-51-35
2020-01-24_9-51-351600×861 259 KB
2020-01-24_9-52-59
2020-01-24_9-52-591600×860 238 KB
2020-01-24_9-55-42
2020-01-24_9-55-421600×860 235 KB
2020-01-24_9-56-52
2020-01-24_9-56-521600×860 317 KB
2020-01-24_10-14-03
2020-01-24_10-14-031600×861 277 KB
2020-01-24_10-17-05
2020-01-24_10-17-051600×860 480 KB
2020-01-24_10-18-22
2020-01-24_10-18-221600×860 485 KB
2020-01-24_10-19-26
2020-01-24_10-19-261600×860 455 KB
2020-01-24_10-23-55
2020-01-24_10-23-551600×860 232 KB
2020-01-24_10-24-48
2020-01-24_10-24-481600×860 226 KB
2020-01-24_10-25-21
2020-01-24_10-25-211600×860 224 KB
2020-01-24_10-26-03
2020-01-24_10-26-031600×860 477 KB
2020-01-24_10-28-10
2020-01-24_10-28-101600×860 310 KB
2020-01-24_10-31-20
2020-01-24_10-31-201600×861 272 KB
2020-01-24_10-36-56
2020-01-24_10-36-561354×546 242 KB
2020-01-24_10-38-36
2020-01-24_10-38-361376×717 267 KB
2020-01-24_10-40-57
2020-01-24_10-40-57737×129 16.3 KB

2

Welcome to the blog!

Your error image shows a division by zero… Maybe review your baq ?
How about Quoted.TotalPotential??? can it be zero…

Pierre

1 Like
3

@Hogardy I bet my lunch today that you nailed this one.

4

I will keep that in mind…if it is the case…:wink:

i am open to share though…

Pierre

5

Thank you. Mr. Hogardy, What kind of code do I need to edit?

2020-01-24_10-23-55
2020-01-24_10-23-551600×860 232 KB