[ https://issues.apache.org/jira/browse/OFBIZ-3700?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12856927#action_12856927 ]
Bob Morley commented on OFBIZ-3700: ----------------------------------- Right and in the fieldtypepostgres.xml ... <field-type-def type="fixed-point" sql-type="NUMERIC(18,6)" java-type="java.math.BigDecimal"><validate method="isSignedDouble"/></field-type-def> <field-type-def type="floating-point" sql-type="FLOAT8" java-type="Double"><validate method="isSignedDouble"/></field-type-def> So these "floating-point" types translate to java Doubles when hydrated from the database. If you look at "InventoryItem" for example, its field definition is <field name="quantityOnHandTotal" type="fixed-point"></field> (for QOH). > Convert WorkEffort (and related entities) quantities from Double -> BigDecimal > ------------------------------------------------------------------------------ > > Key: OFBIZ-3700 > URL: https://issues.apache.org/jira/browse/OFBIZ-3700 > Project: OFBiz > Issue Type: Bug > Components: workeffort > Affects Versions: SVN trunk > Reporter: Bob Morley > Priority: Minor > Fix For: SVN trunk > > > It appears that this entity was missed from the BigDecimal conversion. Ran > into this when ProductionRunServices was attempting to create a WorkEffort > (it is passing the quantity to produce as a BigDecimal). A different bug in > OFBIZ-3699 was causing an auto-convert of the field from BigDecimal to Double > (which was allowing ProductionRuns to be created). At any rate, we should > convert this entity and any other quantity related entities in the WorkEffort > component. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira