By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Acumatica Dashboards
2
Posts
2
Users
0
Reactions
1,822
Views
January 13, 2022 4:42 pm
I have an issue on my dashboard where creating a KPI scorecard gives me the following error: “Conversion failed when converting date and/or time from character string”.
My GI’s work perfectly on the dashboard when in data table format, and even in the GI itself I am able to aggregate the column on the bottom of the screen without issue. For some reason when I create the scorecard, I receive this error. Anyone seen this before? (attached XML for the GI in question)
1 Reply
February 18, 2022 10:30 am
Go to TOOLS -> Trace... and look for the SQL code that the Dashboard is running. That can usually give you a clue as to why it's returning an error.
Online Members