I am trying to find a report that will show for example all items that contain a silver cross in the bill of materials ? Anyone have any ideas ?
-
758 Points
- FRUSTRATED
Posted 3 years ago
Shane, Employee
-
7,448 Points
Hi,
I dont think there is a report to show that, but the best way I can think is to export the item list to an IIF file, and have a look at the assembly items for those that use that item. You export it by going File, Utilities, Export, Lists to IIF Files, name it and save it somewhere. Open the IIF file in Excel and scroll to where the assembly items are and look for those with that item. It will look something like this:
In my example I have 2 assembly items called assembly1 and assembly2, and under these you can see the items linked to them.
This is the only way I can see to work out what assembly items have a certain item other than manually searching each one.
Hope this helps.
Regards,
Shane.
I dont think there is a report to show that, but the best way I can think is to export the item list to an IIF file, and have a look at the assembly items for those that use that item. You export it by going File, Utilities, Export, Lists to IIF Files, name it and save it somewhere. Open the IIF file in Excel and scroll to where the assembly items are and look for those with that item. It will look something like this:
In my example I have 2 assembly items called assembly1 and assembly2, and under these you can see the items linked to them.
This is the only way I can see to work out what assembly items have a certain item other than manually searching each one.
Hope this helps.
Regards,
Shane.
-
92 Points
