Hello,
I deleted all company transactions from (Company > Manage > Delete Transactions).
the deletion was successful. however, when I tried to delete one of the accounts in the chart of accounts it gave me this error message
Cannot delete or cancel because Account “2351 added Tax -MME” is linked with Purchase Invoice “ACC-PINV-2021-00026-2”
when I follow the link for ACC-PINV-2021-00026-2 an error page appears (Sorry! I could not find what you were looking for.) which makes sense since I had deleted all transactions.
I tried to find some workaround, I found in Settings > Reports & Masters > Data > Deleted Documents
then I deleted all records but I still face the same issue.
So it seems there are still links or transactions existing. How to remove them?
I’m using the latest ERPNEXT V.13
Cloud basef from Frappe.
I can’t remember what version the Bug was on. But there was a time when Delete All Transactions failed to deleted child table rows. The only way to delete them is to login via an SQL client and delete the records manually.
Probably there is a row in one of the Purchase Invoice child tables referencing this account.
If you’re on hosting by Frappe, most likely you don’t have access to the database directly. I would reach out the the frappe team via a support ticket and ask them if your instance is effected.
Hello @dj12djdjs
thank you so much for all your suggestions. I had contacted them however they said I need to contact ERPNEXT support, not frappe. to cut it short, do you know any document I can follow that can help me to solve this issue?
@Tawfiq_Murtaja It looks like Frappe Cloud added a new feature. If you go to “Backup & Restore” there should be a button “Acess Database” I’ve never used this. Apparently you need a specific plan to use it. Try contacting frappe support to get access to this. From there you can delete the records manually.