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/> |
Hi Eva
It looks like the variance reasons also need to appear in the Enumeration entity (use enumTypeId = IID_REASON). Regards Scott HotWax Media http://www.hotwaxmedia.com On 1/08/2009, at 12:55 PM, Eva Bowman wrote: > > 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. > smime.p7s (3K) Download Attachment |
Thank you for the quick reply. I will follow your instructions.
Eva
|
Free forum by Nabble | Edit this page |