Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Changing the name of existing Account Groups
01-21-2013, 08:03 AM (This post was last modified: 01-21-2013 08:05 AM by richieeeee.)
Post: #1
Changing the name of existing Account Groups
Hi

First post on this forum. Firstly can I say what an excellent piece of software WebERP is Smile thanks Smile

Is it possible to change the name of Account Groups easily or would this require changing in MySQL ?

Cheers

Rich

edit: noticed that this has been submitted as a patch - which ver does this appear in ?
Find all posts by this user
Quote this message in a reply
01-21-2013, 08:07 PM
Post: #2
RE: Changing the name of existing Account Groups
hi rich,
Yes this work is currently in the svn repository.
You can download the modified accoutGroups.php script from:

http://sourceforge.net/p/web-erp/code/57...format=raw

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
01-21-2013, 11:20 PM
Post: #3
RE: Changing the name of existing Account Groups
Awesome - thanks Phil
Find all posts by this user
Quote this message in a reply
01-22-2013, 01:19 PM (This post was last modified: 01-23-2013 05:46 AM by phil.)
Post: #4
RE: Changing the name of existing Account Groups
Hi Richieeee,

It is not really a rename option unfortunately, you would need to run SQL queries to rename an account group I think just add the new account group say "new_account_group"

then run the following SQL from say phpMyAdmin or other mysql client:
Code:
UPDATE chartmaster SET group_ ='new_account_group' WHERE group_ ='old_account_group';

edit: The point has been made to me off list/forum that this does not work (thanks Tim) when old_account_group is also a parent account group, you would also need to run
Code:
UPDATE accountgroups SET parentgroupname='new_account_group' WHERE parentgroupname='old_account_group';

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)