When I try to change the company abbreviation I get the error below
I see the same thing too… I wish I could just delete a test company I made but the system refuses … so I’m going to just leave it I guess… but I can’t change the abbreviation so I can use the proper abbreviation on the new company… Doh!
In new version you cant change company abbrevation. Delete the company and make newone.
i also encounter that
Frappe has disabled the ability to change company abbreviations. But you can still achieve this manually by dumbing your database and using a manual replace query to make the change.
You can change your company abbreviation by following these steps:
-
mysqldump -u user -p yourdatabasename > ./yourpreferredname.sql(You can also use bench backup command here and just go to the backup folder to extract the database file and then go to the next step) -
sed -i 's/oldAbbreviarion/newAbbreviation/g' ./yourpreferredname.sql -
mysql -u user -p yourdatabasename < ./yourpreferredname.sql. (You can also use bench restore here to restore the database
This should help you replace your abbreviation with the preferred one.
Caveat: If there are texts or parts of texts that match your abbreviation in your database, they will get replaced too so ensure you are aware of this before using this method.
1 Like
Thank for the advice. I have a similar problem of renaming the abbreviations. Where do I begin?
What is this “yourpreferredname?” Can you give an example of the commands.
This is the name you give your database file you just dumped
Thank you for the response
Is there a simple option to replace abbreviation rather than making direct change to DB. In my case I fear it may cause other unwanted changes so don’t want to risk it. Can anyone suggest please.
my response is same. the system should allow change of abbreviation. if old chart of account codes, voucher codes are not changed, it does not matter, suppose that facebook is using erpnext and now changed to Meta, what will they do. i think this restriction is not logical