/
Error deleting item 3688
Error deleting item 3688
Description of Issue
Error received deleting item:
Error deleting Item (3688): ifItemsio_delete: Execute delete_Items 28
The DELETE statement conflicted with the REFERENCE constraint "FK_RequisitionItems_Items". The conflict occurred in database "munprod", table "dbo.RequisitionItems", column 'ItemId'.
Context
Inventory Management
Cause
Item is listed on a requisition
Resolution
In Requisitions, use Advanced Search to search for the item
- If requisition is open, item can be deleted from it, and then the item itself can be deleted
- If requisition is converted, then item cannot be deleted from it or from Munis. Instead, the status of the item can be changed to Inactive or Obsolete (only available in 2018.1 and above)
Additional Information
- Inactive items cannot be added to requisitions, purchase orders, or pick tickets.
- The Obsolete Items program (Financials > Purchasing > Setup > Obsolete Items) sets item records to a status of Obsolete, which provides a way to remove from view any records for items that are no longer in stock or that have been discontinued. An obsolete item cannot be viewed or used in the Items program, and can only be viewed in the Obsolete Items program.
, multiple selections available,
Related content
Error deleting requisition - The DELETE statement conflicted with the REFERENCE constraint "FK_PickTicket_Requisition"...
Error deleting requisition - The DELETE statement conflicted with the REFERENCE constraint "FK_PickTicket_Requisition"...
More like this
Unknown error deleting invoice header when removing Purchase Order on the Invoice
Unknown error deleting invoice header when removing Purchase Order on the Invoice
More like this
Error deleting requisition line item - An error occurred when attempting to update the work order task detail for this line
Error deleting requisition line item - An error occurred when attempting to update the work order task detail for this line
More like this
Post canceled due to error deleting old change order
Post canceled due to error deleting old change order
More like this
Error when purging transactions in Inventory Transactions
Error when purging transactions in Inventory Transactions
More like this
Error purging requisitions - Unknown error on execute rqdetail_delete - status: -6372
Error purging requisitions - Unknown error on execute rqdetail_delete - status: -6372
More like this