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
Would be a great improvement in future releases of Reckon to have what is in logistics known as a "where used" lookup for components of BOMs. We have the same issue, a component is used in multiple BOMs and sometimes your assemblies can be built individually but not all due to stock availability of the component. To find out what to prioritise without this "where used" function is a headache.
Related Categories
-
Accounts Hosted
- 5417 Conversations
- 1632 Followers