×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Can't delete an item. Error: "Item is active captured component"

Can't delete an item. Error: "Item is active captured component"

Can't delete an item. Error: "Item is active captured component"

(OP)
When I try to delete some items, I get the following error message: "Item is active captured component. Item cannot be deleted."

The items have no BOM and are not used.

The items don't appeared in the following tables:
imordbld_sql, oeordlin_sql, oelinhst_sql, bmprdstr_sql

Can someone help me on this?

Thanks  

RE: Can't delete an item. Error: "Item is active captured component"

I am remembering something about this.

Write a view script as such.


CREATE VIEW dbo.Component_Captured
AS
SELECT     dbo.sfdtlfil_sql.ord_no, dbo.sfdtlfil_sql.rec_type, dbo.sfdtlfil_sql.item_no, dbo.sfordfil_sql.ord_status, dbo.sfdtlfil_sql.comp_item_no
FROM         dbo.sfdtlfil_sql INNER JOIN
                      dbo.sfordfil_sql ON dbo.sfdtlfil_sql.ord_no = dbo.sfordfil_sql.ord_no
WHERE     (dbo.sfdtlfil_sql.comp_item_no = 'Item No here') AND (dbo.sfordfil_sql.ord_status <> 'C')

Where it states Item No here put your part number.

RE: Can't delete an item. Error: "Item is active captured component"

(OP)
Here is the result of the script:

ord_no        = 138177
rec_type      = M
item_no       = 33100.3754R01
ord_status    = E
comp_item_no  = 33501.1610D01

What the result means? What is the next step to be able to delete this item?

Thanks   

RE: Can't delete an item. Error: "Item is active captured component"

This means the item is a component  in a bill of material.  Delete it from all BOMs and you'll be able to delete the item.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports.  Check out our Macola tools:
www.gainfocus.biz/exceladdin.html

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close