By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Acumatica Generic Inquiries & Pivot Tables
3
Posts
2
Users
0
Reactions
309
Views
April 19, 2024 11:05 am
We want to create a GI ( and dashboard KPIs) that show us the totals for a range of GL accounts. The idea is to have KPIs for Fringe, Overhead and SG&A rates. These all include a set of accounts that we need to sum over.
I think we want to do this in a General Inquiry, but not sure what DAQ is appropriate to do this with. I tried using PX.Objects.GL.AccountByPeriodFilter but the inquiry gives me an error, Invalid object name 'AccountByPeriodFilter'.
Any suggestions would be appreciated.
2 Replies
May 9, 2024 4:29 pm
Take a look at the Trial Balance Summary report in Report Designer to see what DACs are used there. That should give you a pretty good idea.
May 13, 2024 11:07 am
Thanks, that points me in the right direction.