Thread Rating:
  • 0 Vote(s) - 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.)
#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 ?
Reply
01-21-2013, 08:07 PM,
#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
Reply
01-21-2013, 11:20 PM,
#3
RE: Changing the name of existing Account Groups
Awesome - thanks Phil
Reply
01-22-2013, 01:19 PM, (This post was last modified: 01-23-2013, 05:46 AM by phil.)
#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
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)