Adding New Variance Reason Ids

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Adding New Variance Reason Ids

Eva Bowman
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/>
Reply | Threaded
Open this post in threaded view
|

Re: Adding New Variance Reason Ids

Scott Gray-2
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
Reply | Threaded
Open this post in threaded view
|

Re: Adding New Variance Reason Ids

Eva Bowman
Thank you for the quick reply. I will follow your instructions.

Eva
Scott Gray-2 wrote
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.
>