In your .env file you can simply add MANAGE_PY_PATH=manage.py This will solve the issue.
.env
MANAGE_PY_PATH=manage.py
I got to know about this in https://fizzylogic.nl/2024/09/28/running-django-tests-in-vscode