Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Austin Adams]

When I try to inactivate an item, I get the message “This item is part of an active assembly and cannot be marked inactive.”

I was able to disassociate the item from BoM’s, but it was still giving me an error about being part of any active assembly.  I found a kb article which said there was a bug in the GP code which ignored the closed status of MO’s in the picklist table (PK010033) and therefore tagged the items as active.

A solution suggested by MS and contributors to the article was to delete the line items that reference the item you want to inactivate from PK010033, which I tried in our test environment and it allowed me to inactivate the item.

I wanted to see if anyone has ever had to address this issue and if they’d experienced any issues after deleting lines from PK010033 or if there were any suggestions for better ways to go about this.

Thanks!

——————————
Austin Adams
American Innovations
Austin TX
——————————

[Al Schuette]

?While I try to avoid resorting to SQL scripts, simply updating the inactive flag to a value of “1” can accomplish the objective.  In my opinion, it is at least as good of option as deleting items off historical pick lists (which results in inaccurate history).  Something like:

update iv00101 set inactive=1 where itemnmbr=‘xxxxx’

——————————
Al Schuette
Senior Business Consultant
Heartland Business Systems, LLC
Little chute WI
——————————
——————————————-

[Dan Abernathy]

Hi Austin, rather than go into SQL and remove pick list records I’ve had good results just marking the inactive field in the IV00101 table. For completeness I also change the item to discontinued and make it as obsolete in the item engineering.

——————————
Dan Abernathy
Managing Director
Manufacturing Resource Partners
Reno NV
——————————
——————————————-

[Austin Adams]

Thanks for the input!   I’ll give that a try and follow up with any notes.

——————————
Austin Adams
American Innovations
Austin TX
——————————
——————————————-