AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

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

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 7 years ago
4 Posts
4 Users
0 Reactions
4,529 Views
RSS
Posts: 11
 Christopher van Heerden
Topic starter
November 22, 2018 4:55 am
(@christopher-van-heerden)
Member
Joined: 7 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: 5 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: 4 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: 3193
 Tim Rodman
Admin
November 28, 2018 11:09 pm
(@timrodman)
Famed Member
Joined: 10 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,526 Topics
  • 10.9 K Posts
  • 53 Online
  • 2,338 Members
Our newest member: Shoaib Shafquat
Latest Post: Pick List report suddenly not splitting on Shipment
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×