Skip to main content
Solved

Accounting Ratios as dashboard widgets

  • November 29, 2022
  • 1 reply
  • 207 views

Forum|alt.badge.img+1

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.

Best answer by lauraj46

Hi @jessicaASA ,

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!

View original
Did this topic help you find an answer to your question?

1 reply

lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 606 replies
  • Answer
  • November 29, 2022

Hi @jessicaASA ,

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!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings