Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Super Contributor
DFeller
Posts: 2,939
Registered: 10-28-2008
0

GL Account level security

I see that Sage is laying the framework for GL account security by user group; does anyone know what version this is going to be released in?

 

Dawn

Sage Employee
dbcoles
Posts: 107
Registered: 12-04-2008
0

Re: GL Account level security

At this time, it is not on our detailed list of features. Meaning, it isn't in the next release. After that, we don't have many features at that level of detail.
Super Contributor
DFeller
Posts: 2,939
Registered: 10-28-2008
0

Re: GL Account level security

So why would Sage go through the effort of creating this table, and adding it to the schema browser, if they weren't going to actually implement it into the software?

 

We ran into an issue where a prospect wanted GL security by account and since MAS 500 didn't have it they went with another application.  When we spoke to Sage at that time, they indicated it was a feature that had been requested before.  So seeing this gave us hope.

 

Dawn

Moderator
rsisk101
Posts: 177
Registered: 10-28-2008
0

Re: GL Account level security

Which table are you asking about?
Richard Sisk
MAS500, Principal Designer
Irvine, CA
Super Contributor
DFeller
Posts: 2,939
Registered: 10-28-2008
0

Re: GL Account level security

tGLAcctSecurity

 

Contains the list of GL Account Segment Values (including the natural account segment) that are valid for each user group.  This is used to determine if a user (within a certain user group) has the authority to enter the segment value as part of a full GL account in a transaction.  Also determines if a user can inquire on a full GL Account that contains the segment value.

 

Dawn

Sage Employee
dbcoles
Posts: 107
Registered: 12-04-2008
0

Re: GL Account level security

Dawn,

This tables been around for some time and I'm guessing we had great intentions in the 6.x timeframe, but this has fallen off the radar.

unidentified user
rmorgan
Posts: 2
Registered: 12-20-2011
0

Re: GL Account level security

Hi Dawn - I have a MAS 500 client where this is an issue (lack of GL account level security). Were you ever able to develop or find a solution to this issue? Basics like allowing only certain users to hit the AP account via GL transactions is what they are looking for. Any ideas would be greatly appreciated. Thanks!

Sage MAS 500 Customer
trodman
Posts: 233
Registered: 02-13-2009
0

Re: GL Account level security

This isn't the best solution, but we created a nightly SQL job that compares the balance in the Accounts Payable module to the balance in the Accounts Payable GL account.  If they don't agree, an email is sent out.  So, while it doesn't prevent the two from getting out-of-sync, at least we know within 24 hours of when it happens.

Tim Rodman
Programmer Analyst
rodmant@robbinstbm.com
Version 7.30.6.0 (March 2011)
unidentified user
rmorgan
Posts: 2
Registered: 12-20-2011
0

Re: GL Account level security

Thanks Tim - We actually are proposing a similar workaround, recommending KnowledgeSync for this and other purposes.