Be able to manually change badge status to “not grantable”

Have you enabled the custom badge SQL from the hidden setting? Enable Badge SQL