[Aleiha Hanson]

Good Morning,

We are looking to do a few component replacements in GP BOMs, plus changing component quantities. Does anyone have any feedback on using the mass BOM update utility in manufacturing versus running SQL scripts?
Any feedback is greatly appreciated!

Thank you,
Aleiha

——————————
Aleiha Hanson
Royal Basket Trucks
Darien WI
——————————

[Beat Bucher]

Hi Aleiha,
We do use the MfG module in GP, but I don’t think anyone has ever used the BOM Mass Update utility in the company..
This is one of those function that you don’t want to take a chance and trying to figure it out by your own.. If Microsoft took the time to write the utility, that’s for a good reason..
I know for the fact that the MfG module has a lot of ties with inventory tables and the MfG tables structure itself is pretty complex too.. I had to deal in the past with Archived MFG & ENG BOM’s that needed to be restored because the working version was scrapped by accident, and let me tell you that’s not an easy fate.
Especiall you have to consider following statement from the MfG user guide :

“You can use settings in the BOM Preference Defaults window to choose how the mass updates will work in your company. You can choose to archive the original versions of the bills of materials that are updated, so that you have a record of the changes that are made. You can choose to exclude certain bill of materials types from updates. You also can set up process security, so that users must be part of a process security group or supply a password before the bills of materials can be updated.”

Just by reading this paragraph shows you the complexity behind the process of mass update.. I wouldn’t try to do that thru my own SQL code..  To be on the safe side, I strongly suggest that you take a backup of your live data and test this out in a TEST company before applying it to the production company.
Hope this helps and good luck with your process.

PS: Willoware has an excellent add-on pack for GP MfG : https://willoware.com/mfg-powerpack-ivu/
       you may want to have a look at it..

——————————
Beat Bucher
Business Analyst, Dynamics GP MVP
Ultra-Electronics Forensic Technology Inc.
Montreal QC/Canada
+1-514-489-4267
@GP_Beat http://dyngpbeat.wordpress.com/
Montreal QC GPUG Chapter Leader
GP2013R2 / MR2012 CU14
——————————
——————————————-

[Aleiha Hanson]

Thank you for the feedback! I will try it on our test company to see the impact and definitely always make a backup prior to rolling a change like this.

I took a couple manufacturing courses at Summit last year with Sunny, I may reach out to her. Thank you for the suggestions!

——————————
Aleiha Hanson
Royal Basket Trucks
Darien WI
——————————
——————————————-

[Blair Christensen]

I would contact Sunny Mattoon for assistance.  She is currently assisting us in implementing the Manufacturing Module.  In preparation she had to help us adjust our unit of measure schedules and our Bills of Materials and she’s top notch.

——————————
Blair Christensen
Database Administrator
Oppenheimer Companies, Inc.
Boise ID
——————————
——————————————-

[David Cazalet]

We use BoMs for costing purposes and have used the BoM mass update a number of times to change Material and useage. It felt easy to use and worked well right from the start, I was pleasantly surprised! We weren’t that concerned about archiving the old versions though and the only BoMs we are using are the MFG BoMs.

If you have 100’s – a few 1000’s of lines to update you could also consider creating a screen input macro – I’ve updated the BoM card this way and it worked although a little fiddly to create. I’ve not tried updating the BoM mass update with a macro just yet but it may well be worth a go.  

   

——————————
David Cazalet
Management Accountant
Slater Harrison & Co Ltd

——————————
——————————————-

[Aleiha Hanson]

Thank you David. We also only use MFG BOMs and aren’t concerned about preserving previous versions, we always just overwrite any changes.

I’m going to give it a try in our test company and prod forward from there.

——————————
Aleiha Hanson
Royal Basket Trucks
Darien WI
——————————
——————————————-