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 Forums

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

Forums
AUG Forums
Acumatica Generic I...
GI Setup Issues - D...
 
Notifications
Clear all

Questions [Solved] GI Setup Issues - Default Permissions and Excel Export Format

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Tim Rodman 6 years ago
4 Posts
2 Users
0 Reactions
11.3 K Views
RSS
mhoss
Posts: 34
 mhoss
Topic starter
August 2, 2018 10:37 am
(@mhoss)
Trusted Member
Joined: 5 years ago

Hi Tim,

Nice to see how lively the AUG has become. I'll be sure to spend some more time here looking around.

2 setup questions on GIs. 
1. When you make a save a new GI, it is by default visible to all users, even if the site map location and screen ID have not been granted rights for all users. What do you do after you make a new GI to not make it visible to all by default. I don't want to restrict access outright because then it becomes a role nightmare.

2. When you add a column to a GI, it can affect how the excel export looks (deleting columns, moving columns, etc.). I naively thought the excel would look identical to what is on screen on the GI. What settings do I need to check in the GI if my excel export does not match?

Thanks!


3 Replies
mhoss
Posts: 34
 mhoss
Topic starter
August 6, 2018 1:14 pm
(@mhoss)
Trusted Member
Joined: 5 years ago

Hi All,

Just wanted to update that both issues have been resolved.

1. This was just setting delete rights for admin at the access rights by screen.

2. I found a previous post that documented this, apparently a common issue. One workaround is the remake the GI in the order you wish to export. Let me know if there is a better solution. 


Reply
Tim Rodman
Posts: 3199
 Tim Rodman
Admin
August 14, 2018 5:43 am
(@timrodman)
Famed Member
Joined: 10 years ago

1. This is definitely my LEAST favorite thing about security in Acumatica. You have to explicitly define security permissions on the screen for at least one security role. I usually do the same thing, define Delete rights for the Administrator security role. But many people don't realize that they have to do this at first so the generic inquiry is available to EVERYONE until they (hopefully) notice it.

2. I didn't remember this one. So it only respects the column order in the RESULTS GRID tab on the Generic Inquiry (SM208000) screen when you do the Excel export?


Reply
Tim Rodman
Posts: 3199
 Tim Rodman
Admin
September 15, 2019 2:26 am
(@timrodman)
Famed Member
Joined: 10 years ago

Vote on this to change the behavior you experienced in #1 https://feedback.acumatica.com/ideas/ACU-I-2456


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,528 Topics
  • 10.9 K Posts
  • 44 Online
  • 2,412 Members
Our newest member: Peter Paasch
Latest Post: Tax on Inventory Transfer
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 © 2026 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×