Sage 100

 View Only

  • 1.  BM Component Requirement Report error

    Posted 06-07-2022 07:11
      |   view attached
    Sage 100 2018 Advanced, Component Requirement Report generates an error for some large bills:  error 41 BM_COMPONENTREQRMNTRERPORT_RPT.PVC line 637.  In looking at the work file for 2 different bills, the common thread on the last record is Level = 97, LIneKey = 000001.

    I have rebuilt keys and sorts for Bill of Materials  no issues reported and no change in the behavior.  It runs for about 2 hours before crashing.
    Clicking on Info button produces this lovely mess (see attachment).

    Any ideas?

    Phil


    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    ------------------------------


  • 2.  RE: BM Component Requirement Report error

    Posted 06-07-2022 08:13

    Phil,

    It almost seems like it might be in an infinite loop. Could one of the subassembly bills be referencing the parent or a higher level bill?

    Check the setting in BM Options for "maximum number of levels"? if it is at 99 maybe try reducing it to 10 just to see if that changes the behavior at all.

    Also it looks like there is a third party add-on – the selection grid in your screen shot doesn't look like the standard Component Requirement report. Maybe check with the developer?

     

     

     

     

    Learn about the benefits of warehouse & production automation - free webinar June 16th

     

    Don't miss out on the 2022 Intermediate Crystal Reports for Sage 100 online Training: View the details

     

     

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     






  • 3.  RE: BM Component Requirement Report error

    Posted 06-07-2022 08:57
    @David Overholt - good idea - I will check on that.  They do have Scanco multi-bin...​

    ------------------------------
    Phil McIntosh
    President
    Friendly Systems, Inc.
    ------------------------------

    Original Message


  • 4.  RE: BM Component Requirement Report error

    Posted 06-07-2022 09:08
      |   view attached
    I'm not sure if it is important, but your screen shot of the component requirement report looks like more than just multi-bin the column titled "Production No" is intriguing to me.

    ------------------------------
    David Overholt
    DWD Technology Group
    ------------------------------

    Original Message


  • 5.  RE: BM Component Requirement Report error

    Posted 06-07-2022 09:19
    Standard B/M does NOT have the Production No on the selection screen.

    --

    Friendly Systems, Inc.

    Sage 100 (Mas90/200), Sage 300 (Accpac), SageCRM, xTupleERP
    Visit us on the web at www.friendlysystems.com
    Office:?? 678.273.4010 ext 4
    Mobile: 404.202.9065
    Fax:?????????? ??678.273.4012
    See our blog at www.friendlysystems.com/blog


    Virus-free. www.avg.com



    Original Message


  • 6.  RE: BM Component Requirement Report error

    Posted 06-07-2022 09:48
    Edited by Alnoor Cassim 06-07-2022 09:49
    Phil - I've run into this with the Indented Bill report. When the Max Number of Bills was 10 it would only explode the 1st level. When I set it to 20 it would give me a hard error. The problem was exactly what @David Overholt said in that some of the components were parent bills and this circular processing resulted in an infinite / endless loop. It turns out they did this on purpose where the parent was added as a component with a Qty/Assembly = 0 as a way of listing a drawing x-ref in the sub-assembly. I suggested a comment line or misc item as an alternative but they didn't go for that. They were also moving to another ERP system and really just wanted to export the data for import into the new system. I ended up modifying the programming to not explode a sub-assembly if Qty/Assembly = 0 and a few other conditions.

    ------------------------------
    Alnoor Cassim

    Email: alnoor.cassim@90minds.com
    Ph:
    ------------------------------



Related Content