I have added a couple of variance reasons to the VarianceReason entity. I have also assigned a new Gl default accounts to each one of them in the VarianceReasonGlAccount entity.
I'm getting this error when I try to do a Physical Inventory to adjust inventory and give the new variance reasons I created. How can I fix this error? Thanks, Eva The Following Errors Occurred: Error:<br/> ERROR: Could not complete the Create an InventoryItemDetail [file:/home/ofbiz/trunk/applications/product/script/org/ofbiz/product/inventory/InventoryServices.xml#createInventoryItemDetail] process [problem creating the newEntity value: Error while inserting: [GenericEntity:InventoryItemDetail][availableToPromiseDiff,-1(java.math.BigDecimal)][createdStamp,2009-07-31 20:47:38.767(java.sql.Timestamp)][createdTxStamp,2009-07-31 20:47:38.711(java.sql.Timestamp)][effectiveDate,2009-07-31 20:47:38.767(java.sql.Timestamp)][inventoryItemDetailSeqId,96477(java.lang.String)][inventoryItemId,10063(java.lang.String)][lastUpdatedStamp,2009-07-31 20:47:38.767(java.sql.Timestamp)][lastUpdatedTxStamp,2009-07-31 20:47:38.711(java.sql.Timestamp)][physicalInventoryId,10025(java.lang.String)][quantityOnHandDiff,-1(java.math.BigDecimal)][reasonEnumId,VAR_RESHIP(java.lang.String)] (SQL Exception while executing the following:INSERT INTO dbo.INVENTORY_ITEM_DETAIL (INVENTORY_ITEM_ID, INVENTORY_ITEM_DETAIL_SEQ_ID, EFFECTIVE_DATE, QUANTITY_ON_HAND_DIFF, AVAILABLE_TO_PROMISE_DIFF, UNIT_COST, ORDER_ID, ORDER_ITEM_SEQ_ID, SHIP_GROUP_SEQ_ID, SHIPMENT_ID, SHIPMENT_ITEM_SEQ_ID, RETURN_ID, RETURN_ITEM_SEQ_ID, WORK_EFFORT_ID, FIXED_ASSET_ID, MAINT_HIST_SEQ_ID, ITEM_ISSUANCE_ID, RECEIPT_ID, PHYSICAL_INVENTORY_ID, REASON_ENUM_ID, DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The INSERT statement conflicted with the FOREIGN KEY constraint "INV_ITDTL_REAS". The conflict occurred in database "BIABOBDev", table "dbo.ENUMERATION", column 'ENUM_ID'.))] <br/> <br/> -- View this message in context: http://www.nabble.com/Adding-New-Variance-Reason-Ids-tp24765041p24765041.html Sent from the OFBiz - User mailing list archive at Nabble.com.
