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,903
Views
January 13, 2022 3: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 9: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.