 |
|
Topic: All component list with where used
|
| By: Mike | Posted on: Mar 5 2024 at 01:59:27 PM | Hi There, I need to give my turn-key board assembly house a list of the 300 components we use, that shows in what assembly and the amount needed for each assembly. The component list has a column for "Used In", but nothing fills in. Each individual component shows a "Used On", but I don't want to export or print out 300 parts one at a time. I must be missing something, because I'd think this would be a pretty standard thing. Anybody know what I'm missing?
Cheers | |
| By: Support | Posted on: Mar 11 2024 at 11:23:17 AM | As I said in email a few days ago (answering here in case anyone else has a similar question)
Your 'Used On' column is not one of our default columns. You must have added it yourself with the intention of populating it yourself.
We do have a Used In field in the item detail window. Go to all Components. Double click on a part number to open the item detail window. Across the middle of the Item Detail window you have a row of tab. One of them is "Used In". | |
| By: Mike | Posted on: Jun 19 2024 at 02:11:42 PM | | I understand. My issue is I need the Standard "Used In" field to show up on the component list. There is no option to add the used in field in the "columns to show" dialog on the component list. I need to end up with a component list that shows on which assemblies each component is used. I have added a custom field (Where Used) that will show up on the component list, but I have to copy and paste each assembly the component is used on from the used in field to the custom where used field. If we could have the option of adding the standard used in field to the component list, all that goes away. | |
| By: Support | Posted on: Jun 21 2024 at 05:36:18 AM | I'm sorry. The 'Used In' field does not actually exist in the database. Every time you view an item detail page it does a quick query to get the current 'Where Used' data for that one item. It only takes a fraction a second to create the 'Where Used' info but doing the query and showing it for your 300 items would take a few minutes to display the whole list.
There would be ways we could improve that performance by storing/caching the Where Used data but, in 25+ years, you are the only person who ever asked for this so I'm afraid we can'd make such a big change to the software that would affect everyone else. | |
| By: Mike | Posted on: Jun 21 2024 at 02:34:59 PM | | That's OK. I was kind of bored the last few days, and I just did the copy/paste to a custom where used field. Almost done! Cheers! | |
Reply - add a comment to this topic.
You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.
|
|
|
