Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) How to find what kits ...

How to find what kits an item is a component of?

(0) Share

Report

Posted on by Community Member Microsoft Employee

This might be an easy question, but we are looking to cleanup and delete a number of outdated legacy items we no longer sell from GP. Several of these low-priced items are components in a variety of kits. Is there a way to find out which kits a particular item is a component of so that the items can be removed/replaced from the kits, therefore allowing us to delete the item from GP?

Many of these items are service items, so transaction history has never been tracked, but since they are service items that cannot be discontinued we would prefer to delete them rather than just make them inactive.

Thanks in advance!

*This post is locked for comments

All responses (2)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: How to find what kits an item is a component of?

Thank you Almas. I was looking for that table.

Regards,
Verified answer

Almas Mahfooz 11,003 User Group Leader on at

Like (0)

Report

RE: How to find what kits an item is a component of?

check IV00104 table, you can get kit items and there components from this table.

select * from IV00104