180
Hi there,
I am trying to automate the BOM Component updation process in GP through Macro. But the structure of BOM entry window is such dat, its not working for me to create one macro. Mainly, as the number of components for each finished items is different. My objective is to update the component quantity to be used for in BOM. Any suggestion would be more helpful.
Thanks,
*This post is locked for comments
make one list in excel like this
parent part number, component part number, any other field you need for this pair but not a parent or component part number
parent part number, component part number, any other field you need for this pair but not a parent or component part number
parent part number, component part number, any other field you need for this pair but not a parent or component part number
parent part number, component part number, any other field you need for this pair but not a parent or component part number
parent part number, component part number, any other field you need for this pair but not a parent or component part number
more......
The parent part number can appear multiple times (but only once on each line). Each line updates ONE AND ONLY ONE component. A parent can appear on one line, two lines if it has two components, three lines if it has three components, four times if it has four components, etc. Run the macro I described against this table.
If this does not work for you, call your GP Partner or hire one to do it for you.
Hi Richard,
Again got stuck with this. The problem is..1 BOM & multiple components. If I try to create one macro for each combination (of BOM & one component) it may work. But in the left panel of BOM entry window, the components are lined up with position numbers. If I create a macro for BOM & position 1 component, I have to create another macro for position 2 component.. right?
Also, the Component lookup window in the right hand panel of BOM entry window is disabled. Is there any way to enable it, so I can use that window instead to select the component for macro.
Thanks,
Mohid
No, you create a macro with only one component. You merge that macro 4, 5, 9 or more times depending on the number of parent item/component item pairs you have in your source table. If, for example, a parent item has 6 components, there will be 6 lines in the merge source file. That will create 6 copies of the macro. Each copy updates one component, saves the change, and returns to the home field to wait for the next copy of the macro.
But..as the number of components for each finished items vary from 4 to 9 sometimes, in creating macro there is no standard number of components (steps). Thats creating me problem. If I create macro with 9 components, and if I run it on a Finished item with 4 components, it will stop and it wont run for the next item i.e. it will stuck in between.
I created many macros as you said. But this one is little different n difficult i feel.:-)
Regards,
Mohid
They are so easy to create (put the cursor in the "home" spot and start recording, walk through one manually returning to the "home" position, and stop recording.) that I do not keep them.
First, I assume that you looked at the BOM Mass Update tool and that does not work for you....ok
Macros updating the BOM module must take each item individually. The script should enter the parent item number, pull the component, add the fields needed, save the changes to the component, and then save the parent item. Merge that single item update script with a list of parent item/component items and it works great. I do it all the time.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (