I have tried creating a Dashboard widget for Quarterly Revenue without any success. Does anyone have one already built?
Solved
Dashboard Widget For Revenue
Best answer by Robert Sternberg
You will need to create a Generic Inquiry displaying ending balance of your Revenue accounts using the GLHistory table, then sum the values for your dashboard tile and limit by the current period or the evaluation period you choose.
1 person likes this
+1have you tried using filter date @QuarterStart or @QuarterEnd?
Rico P. Ybanez
1 person likes this
I haven’t even been able to get to the point of setting the filters. I can’t seem to find the correct inquiry screen to have the amounts convert to local currency for all revenues (we bill in multiple currencies).
+1Maybe on the generic inquiry you can group by currency ID on your Revenue accounts
+7You will need to create a Generic Inquiry displaying ending balance of your Revenue accounts using the GLHistory table, then sum the values for your dashboard tile and limit by the current period or the evaluation period you choose.
Robert Sternberg, Crestwood Associates -- If a community member helped you, please *Like* their post/reply. If they provided an answer to your question, please mark it as *Best Answer*.
+12If you have the stock Controller Dashboard (I think this released in 2022?), take a look at the Income vs. Expense by Period widget. (the inquiry is called Income and Expense). Below is from the sales demo environment. This should give you the starting info you need to change it up to be quarterly.
Megan Friesen, Contego Software Solutions, Canada
1 person likes this
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.