I have a Database in ERPNext with about 30’000 items.
Now I need to set a default expense account for each of them, so I was directed to use the Bulk update.
However, I can not seem to get past the set limit of 500 entries per update, despite being able to enter a number on my own.
We also have had similar issues. A reliable solution is using a Rest API client and updating records via a automated script.
A good Rest API client has been created by Frappe Technologies here: GitHub - frappe/frappe-client: Python library to use Frappe API
You have to know little bit of python to get things going.