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

Acumatica 4.0 Screens

June 11, 2013 by Tim Rodman

I created an Excel Pivot Table with a list of all the Acumatica 4.0 screens.

In order to view the Pivot Table, please click here.

Here is my SQL code for the query that feeds the Pivot Table:


SELECT MainModule.Title[Main Module],SubModule.Title[Sub Module],
Pane.Title[Pane],Category.Title[Category],
Screen.Title+' ('+Screen.ScreenID+')'[Screen]
FROM dbo.SiteMap Screen
LEFT OUTER JOIN dbo.SiteMap Category ON Screen.ParentID = Category.NodeID
LEFT OUTER JOIN dbo.SiteMap Pane ON Category.ParentID = Pane.NodeID
LEFT OUTER JOIN dbo.SiteMap SubModule ON Pane.ParentID = SubModule.NodeID
LEFT OUTER JOIN dbo.SiteMap MainModule ON SubModule.ParentID = MainModule.NodeID
WHERE Screen.ScreenID IS NOT NULL AND Screen.ScreenID NOT LIKE '%000000'
AND MainModule.Title IS NOT NULL AND MainModule.Title<>'Acumatica Company'
-- AND Screen.ScreenID='WI000020'
ORDER BY MainModule.Position,SubModule.Position,Pane.Position,Category.Position,Screen.Position

Filed Under: Acumatica Learning Tagged With: Acumatica, Acumatica Blog, Acumatica Training

By using this website, you agree to our Terms of Use (click here)
Building Generic Inquiries & Pivot Tables

Online Members

 No online members at the moment

Recent Blog Posts

  • EP 166: Tim uses ChatGPT and Claude to build something cool (Podcast) March 21, 2026
  • EP 165: Jake Wells – EOS Scorecard and Acumatica Dashboards (Podcast) March 12, 2026
  • EP 164: Phil Steichen – Vibe Coding your own Business Intelligence tool (Podcast) February 19, 2026
  • EP 163: Daryl Bowman – Dissecting the new Acumatica Calendar Board (Podcast) February 9, 2026
  • EP 162: Gabriel Michaud – Catching up on new cool stuff in Velixo and Excel (Podcast) February 2, 2026

Recent Forum Posts

  • Ed Dolan

    Negative/Credit Inventory Value?

    We are starting a new line of business to recycle const...

    By Ed Dolan , 2 days ago

  • Tami

    RE: Production Orders with all material on hand

    @timrodmanrodman Question for you. What table joins d...

    By Tami , 1 week ago

  • Brynn Rutherford

    RE: Can't export GI's to excel that contain the FATrans DAC after upgrade to 2025 R1 in less than 25 min

    @timrodman - It won't let me attach the file. I will em...

    By Brynn Rutherford , 2 weeks ago

  • Tami

    RE: Production Orders with all material on hand

    @timrodman Thank you! We just upgraded to 2025R1 in ...

    By Tami , 2 weeks ago

  • Tim Rodman

    RE: Production Orders with all material on hand

    @tlynn Looks like someone already created a product ide...

    By Tim Rodman , 2 weeks ago

  • Tami

    RE: Production Orders with all material on hand

    @timrodman Yes! If that parameter was optional it wo...

    By Tami , 2 weeks ago

  • Tim Rodman

    RE: Can not delete an automated schedule

    I doubt it since Business Events are stored on the Busi...

    By Tim Rodman , 2 weeks ago

  • Tim Rodman

    RE: Production Orders with all material on hand

    Is the problem with this Critical Materials (AM401000) ...

    By Tim Rodman , 2 weeks ago

  • Tim Rodman

    RE: Update the Unit Rate for Existing Project Templates

    The following worked for me.   Here's the Data...

    By Tim Rodman , 2 weeks ago

Terms of Use & Disclaimers :: Privacy Policy

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