How can we store null in Currency Fields of a DocType?

ERPNext
1

Hi Friends,

We require null to be stored in a Currency Field of a DocType. Right now even though the field is not mandatory, by default 0 (zero) is stored in the database, whenever a row is inserted. Is it possible to store null (no value) for the Currency field? Or do we need to switch to Float for the same?

2

Adding the stackoverflow response for the same question:
https://stackoverflow.com/questions/65284216/frappe-erp-next-how-can-we-store-null-in-a-currency-field-of-a-doctype/65299745#65299745