BOM Mass Update

  • BOM Mass Update

    Posted by DSC Communities on May 8, 2017 at 10:37 am
    • Aleiha Hanson

      Member

      May 8, 2017 at 10:37 AM

      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

      Member

      May 9, 2017 at 8:22 AM

      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

      Member

      May 9, 2017 at 11:22 AM

      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

      Member

      May 9, 2017 at 9:43 AM

      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

      Member

      May 10, 2017 at 6:08 AM

      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

      Member

      May 10, 2017 at 9:39 AM

      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
      ——————————
      ——————————————-

    DSC Communities replied 7 years, 1 month ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘BOM Mass Update’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!