Expense Grid Field predefined

ant0n1s90 · Octobre 27, 2022, 5:59

Hello,

There is a field on expense line grid that is predefined as 0.00. Is it possible to edit the 0.00 to null?
This is the field on expense-line-grid View

Thank you

siddique · Octobre 27, 2022, 5:11

it’s of number type, what you are achieving

ant0n1s90 · Octobre 31, 2022, 8:19

Is it possible to change 0.00 to blank?

ZeeshanAhmad · Février 23, 2023, 5:00

yes it is possible to do in many ways.

you can change its type to string ( now probably it is a integer or decimal type field).
you can write an action attrs to set it to null like :

<action-attrs name="action-test-null-total-amount">
<attribute name="value" for="totalAmount" expr="eval: null"/>
</action-attrs>

you can use this action as per your needs .

gdu-axelor · Février 24, 2023, 2:55

Hello,

It s possible to use the attribute « nullable ».

https://docs.axelor.com/adk/6.1/dev-guide/models/models.html#fields

You can take a look on an example on the Inventory lines :

github.com

axelor/axelor-open-suite/blob/master/axelor-stock/src/main/resources/domains/InventoryLine.xml#L15

    
      
          
          
<module name="stock" package="com.axelor.apps.stock.db"/>
          
          
<entity name="InventoryLine" lang="java">
          
          
  <many-to-one name="inventory" ref="com.axelor.apps.stock.db.Inventory"
              title="Inventory"/>
            <many-to-one name="product" ref="com.axelor.apps.base.db.Product" title="Product"
              required="true"/>
            <decimal name="currentQty" title="Current Qty" precision="20" scale="10"/>
            <decimal name="realQty" title="Real Qty" nullable="true" precision="20" scale="10"/>
            <many-to-one name="unit" title="Unit" ref="com.axelor.apps.base.db.Unit"/>
            <string name="description" title="Description" large="true" multiline="true"/>
            <string name="rack" title="Rack"/>
            <many-to-one name="trackingNumber" ref="com.axelor.apps.stock.db.TrackingNumber"
              title="TrackingNumber"/>
            <decimal name="gap" title="Gap" readonly="true"/>
            <decimal name="gapValue" title="Gap value" readonly="true"/>
            <decimal name="realValue" title="Real valuation" readonly="true"/>
            <many-to-one name="stockLocation" ref="com.axelor.apps.stock.db.StockLocation"
              title="Stock location"/>

Also, you have to update the java code to avoid some NPE issues

Regards