Unable to Cancel DN because of Serial No

Please make sure you backup the database before you do anything. Usually tinkering with DB is always risky. You never know how it impacts other transactions as well. It could also lead to entire DB being corrupted.

goto frappe-bench folder. Then use below cmds

bench mariadb

(if there are no other sites installed. If other sites are there use --site sitename)

UPDATE tabDelivery Note SET docstatus = ‘0’ WHERE name = ‘your delivery note number’;

use ` before and after tabDelivery Note in the above command. Something like below as example