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
Everything Else
List of all screens...
 
Notifications
Clear all

Questions List of all screens in Acumatica

 
Everything Else
Last Post by Tim Rodman 8 years ago
4 Posts
4 Users
0 Reactions
5,337 Views
RSS
Posts: 11
 Christopher van Heerden
Topic starter
November 22, 2018 4:55 am
(@christopher-van-heerden)
Member
Joined: 8 years ago

Good day everyone.

I need to create a new CRActivity screen for a generic inquiry.

How can I get a listing of all the screens in the system so that I can see what number I must use for the next sequence numbers for my screen.

I know from the naming conventions that the screen must begin with CR.40.??.?? ( Where 40 - Inquiry) but I am unsure of what to enter for my Screen and Sub-screen sequential numbers.

Is there a table in the database I can select and sort on to see which next sequential number I can use?

I looked through all the topics and felt that this topic fell under "Everything else"

Hope this is correct.

 

Kind regards,

Christopher

 


3 Replies
Carl Brooks
 Carl Brooks
(@kingcarlos)
Joined: 6 years ago

Estimable Member
Posts: 121
November 25, 2018 11:29 pm
Reply toChristopher van Heerden

Hi Chris,

If you have Acumatica on premise you can run the following SQL Script, 

select screenid, * from sitemap
where screenid is not NULL
order by sitemap.screenid asc


Reply
mhoss
Posts: 34
 mhoss
November 22, 2018 12:58 pm
(@mhoss)
Trusted Member
Joined: 5 years ago

Hi Christopher,

Whenever I make new screens, I always start with ZZ. If you pick the next number in the sequence, there is a chance Acumatica could later also pick that screen and break something. 

You are then free to pick any sequence number. 

Does that work for you?

-Matt


Reply
Tim Rodman
Posts: 3204
 Tim Rodman
Admin
November 28, 2018 11:09 pm
(@timrodman)
Famed Member
Joined: 11 years ago

You can also create a Generic Inquiry based on the SiteMap table to accomplish the same thing. Then sort by the Screen ID.


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,533 Topics
  • 11 K Posts
  • 39 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.

‹›×

    ‹›×