Hello - has anyone created a dashboard widget that shows an accounting ratio? For example, we would like to see our debt to equity ratio on our dashboard. The data for that ratio is found in our balance sheet and I do not see the balance sheet as an available data source for widget creation. I am new to creating widgets and not sure where to start. Thank you.
Solved
Accounting Ratios as dashboard widgets
Best answer by lauraj46
Hi
Widgets on Acumatica dashboards are based on a Generic Inquiry. The balance sheet report is what’s called an ARM (analytical) report which doesn’t translate directly.
I created a sample Generic Inquiry that groups and sums to calculates a ratio between two different GL account classifications. It uses the GLHistory data access class which as the totals by financial period. You would need to filter on the appropriate period.
In the example I looked at the first digit of the GL account. You would need to adjust this to match the logic from your balance sheet.
Once you have the Generic Inquiry working, it’s pretty straighforward to create the KPI widget based on the ratio column.
Hope this helps!
1 person likes this
+8Hi
Widgets on Acumatica dashboards are based on a Generic Inquiry. The balance sheet report is what’s called an ARM (analytical) report which doesn’t translate directly.
I created a sample Generic Inquiry that groups and sums to calculates a ratio between two different GL account classifications. It uses the GLHistory data access class which as the totals by financial period. You would need to filter on the appropriate period.
In the example I looked at the first digit of the GL account. You would need to adjust this to match the logic from your balance sheet.
Once you have the Generic Inquiry working, it’s pretty straighforward to create the KPI widget based on the ratio column.
Hope this helps!
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.