AUGForums.com

An Acumatica User Group

  • Forums
  • Podcast
  • Blog
  • Rolodex
  • Login
  • Start Here
  • Consulting
  • Courses
  • 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)

Online Members

Recent Blog Posts

  • Acumatica Comma-Separated List of Shipments for a Sales Order using a Generic Inquiry and SQL View January 26, 2021
  • EP 38: From Welder to Consultant, Nick Savage-Mady on his journey with Acumatica and MYOB Advanced (Podcast) January 21, 2021
  • Acumatica Reporting Tools Consulting January 19, 2021
  • EP 37: Jody Lorincz, IT Manager at MHR Brands, sharing his Acumatica Customer Story (Podcast) January 13, 2021
  • EP 36: What Motivates ERP Veteran Nicole Ronchetti To Participate in Acu-Connect (Podcast) January 8, 2021
Acumatica Learning Resources

Recent Forum Posts

  • RE: What is your role at your company?

    @dianne-a Sounds like you've had an interesting journey...

    By Tim Rodman, 5 hours ago

  • RE: What is your role at your company?

    My job title is Systems Analyst and I used to be a soft...

    By Dianne A, 5 hours ago

  • RE: Emailing Sales Orders / Quotes from Mobile App

    Hey Gustavo; did you ever get any where with this. I ha...

    By kevin.ruppert, 6 hours ago

  • RE: Importing Acumatica User Roles / User Security Permissions from Excel

    @ahmedbahar I am experiencing the same issue. I am on 2...

    By Adam-McGuinnes, 9 hours ago

  • RE: How to add multiple pages of contract terms to the Sales Order printed form

    I have the same issue and I use SubReport (in your case...

    By Idrus, 19 hours ago

  • RE: Is the Parameter Schema Field Mandatory?

    I think it's required. Without it, Acumatica doesn't kn...

    By Tim Rodman, 22 hours ago

  • RE: Can a customer Cross Reference for a parent account feed automatically to child accounts?

    @daniel I always like going simpler myself whenever pos...

    By Tim Rodman, 22 hours ago

  • RE: Carrier VDA Shipping Label (VDA 4994)

    Someone out there might have one, but I don't unfortuna...

    By Tim Rodman, 22 hours ago

  • RE: How to add multiple pages of contract terms to the Sales Order printed form

    I am attempting several different methods. The issue i...

    By Rick Taylor, 1 day ago

Recent Tweets

Terms of Use & Disclaimers :: Privacy Policy

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