Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Bank accounts by webERP user
11-26-2013, 11:38 AM,
#1
Bank accounts by webERP user
Hi all:
Now every user with rights to the GL scripts has access to ALL company's bank accounts.

Reality we face is most users do only need access to a subset of the bank accounts: some work with local banks, some with international suppliers, so need acess to foreign currency accounts, some only for manager use, etc, etc.

Besides the confidentiality issue (if a user does not need to know something, why does she have access?) there is the human error. If she can select from a dropdown menu with 30 options it's more likely to make a mistake than if she has a dropdown of 3 options

So I propose to create a table userbankaccounts containing only the bankaccount code and the userid, to maintain the link. Then all the SELECT statements in webERP containing bank accounts can be JOINed by this table, so we only show the bank accounts relevant to the user.

Does it make sense to all of you? Any ideas or improvements?
Regards,
Pak Ricard
Reply


Messages In This Thread
Bank accounts by webERP user - by PakRicard - 11-26-2013, 11:38 AM
RE: Bank accounts by webERP user - by Exsonqu_Qu - 11-27-2013, 10:54 AM
RE: Bank accounts by webERP user - by PakRicard - 11-27-2013, 11:01 AM
RE: Bank accounts by webERP user - by Exsonqu_Qu - 11-27-2013, 12:20 PM
RE: Bank accounts by webERP user - by PakRicard - 11-27-2013, 12:48 PM
RE: Bank accounts by webERP user - by PakRicard - 11-29-2013, 12:22 PM
RE: Bank accounts by webERP user - by PakRicard - 11-29-2013, 10:32 PM
RE: Bank accounts by webERP user - by Exsonqu_Qu - 11-30-2013, 10:09 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)