how to rename the doc in journal entry
i try from MariaDB with this command
UPDATE `tabJournal Entry` SET name = 'ACC-JV-2024-00001'
where name ='ACC-JV-2024-04154';
UPDATE `tabComment`
SET reference_name= 'ACC-JV-2024-00001'
where reference_name='ACC-JV-2024-04154';
UPDATE `tabWorkflow Action`
SET reference_name= 'ACC-JV-2024-00001'
where reference_name='ACC-JV-2024-04154';
this is the output
![image](https://discuss.frappe.io/uploads/default/original/3X/d/2/d2458a5b360525295ca5819bfb76be568530614e.png)
also the doctype does not found in rename tool
@manal_erpnext when you change a document name using sql it does not update child table parent names , which is the link between child tables and the parent doctype . so now you need to find the child elements that have the parent ‘old_name’ and also chaneg it to the new_name .
and don’t do this again . you can rename documents by checking the ‘allow_rename’ checkbox in the doctype settings.
1 Like
where is it??
i try to rename from the system but see the result
![image](https://discuss.frappe.io/uploads/default/original/3X/8/2/82e2fe7a8099e9285ac1f58b59b1cf86e81c6263.png)
the name is diff than the ID
@bahaou