Skip to main content
Answer

Project Account Group Generic Inquiry

  • October 29, 2025
  • 2 replies
  • 27 views

Forum|alt.badge.img

I would like to create a generic inquiry that lists the project account groups together with the GL accounts in each project account group.  There is a table called PMAccountGroup, but I can’t find a “child” table showing all the GL accounts.  Has anybody successfully done this?

I will use this inquiry as a “sub” GI for an inquiry on AR invoice lines, to show which project account group the AR invoice line has impacted.  This can then be compared to budget to show which AR invoice lines have deviated from Revenue Budget.

Best answer by MarciaW

I solved it - I had already created a GI like this for another client.  I have attached it in case anybody else requires the same thing.

2 replies

Forum|alt.badge.img
  • Author
  • Varsity III
  • Answer
  • October 29, 2025

I solved it - I had already created a GI like this for another client.  I have attached it in case anybody else requires the same thing.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • October 29, 2025

Thank you for sharing your solution with the community ​@MarciaW!