AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register

— The Forums are now read-only —

— All new activity now takes place here: —

AugForums.com Discord Server
Forums
AUG Forums
Acumatica Generic I...
Need to sum up GL a...
 
Notifications
Clear all

Questions Need to sum up GL account totals over a range of dates or periods

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by claytonsummers 2 years ago
3 Posts
2 Users
0 Reactions
1,293 Views
RSS
claytonsummers
Posts: 2
 claytonsummers
Topic starter
April 19, 2024 12:05 pm
(@claytonsummers)
New Member
Joined: 6 years ago

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.


Topic Tags
GL account sums
2 Replies
Tim Rodman
Posts: 3204
 Tim Rodman
Admin
May 9, 2024 5:29 pm
(@timrodman)
Famed Member
Joined: 11 years ago

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.


Reply
claytonsummers
Posts: 2
 claytonsummers
Topic starter
May 13, 2024 12:07 pm
(@claytonsummers)
New Member
Joined: 6 years ago

Thanks, that points me in the right direction.


Reply
Forum Jump:
  Previous Topic
Next Topic  
Topic Tags:  GL (1) , account sums (1) ,
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,533 Topics
  • 11 K Posts
  • 27 Online
  • 2,437 Members
Our newest member: Matt Butler
Latest Post: Nested SubReport Issue
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

By using this website, you agree to our Terms of Use (click here)

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×