Frappe (ERP Next): How can we store null in a Currency Field of a DocType?

610 Views Asked by At

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?

1

There are 1 best solutions below

2
On

The design for numerical properties is to be non-null. Can you explain the use case? Since Currency value are often used in expressions, functions, it does not make sense to keep them null.