Open Forum

Expand all | Collapse all

Mass Update Production BOMs

  • 1.  Mass Update Production BOMs

    SILVER CONTRIBUTOR
    Posted Jan 08, 2020 06:32 PM
    Hello,

    Don't think that there is an easy way to to do this but...worth checking. We have multiple production BOMs where we need to add a new item. Is there any automated way to add the same item# to multiple BOMs?

    The only thing remotely close that I can think of is RapidStart. However, do not think RS will work for this as the need is to insert new lines on the BOM, not change data already in the table.

    Anything other than a manual process?

    ------------------------------
    Neil Cates
    Beckwith & Kuffel
    Seattle WA
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Mass Update Production BOMs

    TOP CONTRIBUTOR
    Posted Jan 09, 2020 06:54 AM
    Not sure which version you are on, but in D365BC lines can be added.  I haven't tried a BOM yet.  All I am saying is that I encourage you test it on BOM's.  If you are not in BC SAAS then you may need to approach this from the SQL side or direct writes to the tables as Edit in Excel isn't available on the BOM page.

    Please share what you implement with the group.  Best of luck!

    ------------------------------
    Jason Nicolaou
    Engagement Manager
    Sikich, LLP
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Mass Update Production BOMs

    TOP CONTRIBUTOR
    Posted Jan 09, 2020 08:12 AM
    ​Why do you say you can't insert things with RapidStart?
    I did that before and it works well.

    ------------------------------
    Samuel Champoux
    IT Director
    Drummondville QC Canada
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Mass Update Production BOMs

    Posted Jan 09, 2020 08:27 AM
    Neil

    I think you can use RapidStart for this task. Remember your writing to the line not the header:

    Export the current values and add the new lines. You should be fine.


    ------------------------------
    Alfredo Zelaya
    Sr. Systems Analyst
    Megadyne Americas LLC
    Fairfield NJ
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Mass Update Production BOMs

    TOP CONTRIBUTOR
    Posted Jan 09, 2020 09:11 AM
    You'll have to make sure that your BOMs are not in a certified status when using RapidStart to update them.

    ------------------------------
    Lewis Rosenberg
    IT Manager
    Mars Fishcare
    Chalfont PA
    ------------------------------------------------------------------------
    BCUG/NAVUG All-Star
    BCUG/NAVUG Board of Advisors, Chairperson
    BCUG/NAVUG Programming Committee

    Twitter: @RosenbergL
    LinkedIn: https://www.linkedin.com/in/rosenbergl
    ------------------------------------------------------------------------

    NAVUG/D365BC-User Group Focus
    May 18-19, 2019
    Denver, Colorado
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: Mass Update Production BOMs

    SILVER CONTRIBUTOR
    Posted Jan 09, 2020 12:54 PM
    Here is what I don't understand about this. If I look at the data in the Production BOM Line table, each item entered on the BOM has a line number. I tried a test update on one BOM Line using RapidStart. I entered a new item but - I left the line number blank. I did Validate and it showed no errors. I applied the data and the new item was added to the BOM. I went back to RS to export the Excel - to look at the data after the update/add of the item. The new item came in with a line number of 0. If I update multiple BOMs - do I care if all of the new entries have a line number of 0?

    ------------------------------
    Neil Cates
    Beckwith & Kuffel
    Seattle WA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 7.  RE: Mass Update Production BOMs

    Posted Jan 09, 2020 03:14 PM
    Neil

    Maybe I'm too "Old School" but i would use the next available line number: 

    In the case above, I would use line 120000, to be consistent.


    ------------------------------
    Alfredo Zelaya
    Sr. Systems Analyst
    Megadyne Americas LLC
    Fairfield NJ
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 8.  RE: Mass Update Production BOMs

    SILVER CONTRIBUTOR
    Posted Jan 09, 2020 04:27 PM
    That's the problem. If I am updating multiple BOMs - the line numbers are not consistent throught all of the BOM records. I don't know how the system determines what line# to use but - if I have 25 BOM records, each with 25 items on the BOM, the line numbers on each will be different. If I have to find an available line number, on all records, could take some time. I could put in a number that is sufficiently large, so as to not likely be on any of the records, or I could search the Excel file for - random number - until I find one not on any record, and use that. This seems odd to me though and am not too comfortable using this approach.

    ------------------------------
    Neil Cates
    Beckwith & Kuffel
    Seattle WA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 9.  RE: Mass Update Production BOMs

    Posted Jan 10, 2020 09:08 AM
    ​Hi Neil,
    A possible solution could be:

    • Run a query that pulls the Production BOMs for your 25 items. 
    • Complete a RapidStart worksheet
    • For the Line Nbr, do an If statement to pull the MAX line for that Production BOM and add 10000 to it.  (see example of the formula below)




    ------------------------------
    David Chiu
    Acoustic Ceiling Products
    WI
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 10.  RE: Mass Update Production BOMs

    Posted Jan 10, 2020 10:07 AM
    I haven't worked directly with production BOMS but I have with other comparable tables.  If you do a copy/paste and exclude the field for the line number NAV will figure out what the next line number should be and will assign it for you.

    ------------------------------
    Chris Gittins
    Storm Products, Inc.
    Brigham City UT
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 11.  RE: Mass Update Production BOMs

    SILVER CONTRIBUTOR
    Posted Jan 10, 2020 02:52 PM
    Wanted to thank everyone for the replies. I have decided to just have these updated manually and move on. The research and testing was taking more time than just doing it manually. It was interesting and would have liked to kept working with it but....

    ------------------------------
    Neil Cates
    Beckwith & Kuffel
    Seattle WA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 12.  RE: Mass Update Production BOMs

    GOLD CONTRIBUTOR
    Posted Jan 13, 2020 09:20 AM

    Neil,

     

    We do things like this often (add, remove, replace, change values, comments, etc., to routing and boms, sometimes in the 1000's) and have been using different development objects depending on the scenario (XMLPort, Report, Codeunit).  Unfortunately, for us anyway, every request is slightly different so coming up with one all-encompassing modification is a challenge.  As we've evolved over many years we continued to massage the same logic (objects) to satisfy user requests.  If you don't have an internal developer, you could consult with your partner for these type of data requests, it's likely the cost of development will be lower than you doing it manually.  If you've a NAV admin that's interested in the development tools (and you've the license for NAV development tools), it's probably something you could manage internally once your NAV admin understands the data structures within NAV and the development tools.    

    John Bellinger
    Business Systems & Applications Manager
    Office: 952-392-3912 | Cell: 612-719-0289
    Activar, Inc.
    9700 Newton Ave. S. | Bloomington, MN 55431
    jbellinger@activar.com | www.activar.com




    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role