By using this website, you agree to our Terms of Use (click here)
Anybody ever create a Scorecard KPI for Net Income within Acumatica Dashboard? If not, looking for ideas to create. Thanks in advance for anyone's help.
I think you could do it. The key is building the Generic Inquiry.
The tricky part is that the GLHistory table only has entries for periods that have transactions. So, if an Expense Account only has transactions in periods 01-2019 and 03-2019, but you are trying to get Net Income for 11-2019, you can't just query on 11-2019. You have to also use the GLHistoryByPeriod table, specifically the LastActivityPeriod column, in conjunction with GLHistory to pull it off.
Then you'd also have to put some condition login in place to convert today's date into a Financial Period that you could filter the data on.
Online Members
