Sage 100

 View Only
  • 1.  Inactive items ignored in Manufacturing Modules including BOM and Production Entry.

    Posted 10-31-2024 11:10

    Unless I am missing a setting somewhere, Inactive items ignored in Manufacturing Modules including BOM and Production Entry.

    I could use some help getting votes for a much needed (in my opinion) request on the Sage Ideas site so Sage can immediately (tongue in cheek) address this shortcoming. 



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


  • 2.  RE: Inactive items ignored in Manufacturing Modules including BOM and Production Entry.

    Posted 10-31-2024 11:41

    I had a customer ask about inactive items that were components on BOM and whether they would still appear in a where used report. I was able to find a KB  from Sage which seemed to verify this and I presume that it's a works as designed - at least for inactive components and the where used.



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    CT
    ------------------------------



  • 3.  RE: Inactive items ignored in Manufacturing Modules including BOM and Production Entry.

    Posted 10-31-2024 11:41

    Voted: idea link



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 4.  RE: Inactive items ignored in Manufacturing Modules including BOM and Production Entry.

    Posted 10-31-2024 12:02

    Wouldn't you want a prompt in Production entry when you create a work order that has an inactive component to prompt you about it and give an option to bring up Replace and Delete Component Entry with the inactive item and prompt for the replacement?

    And when you mark an item inactive it should check if it is a component and do the same thing?



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



  • 5.  RE: Inactive items ignored in Manufacturing Modules including BOM and Production Entry.

    Posted 10-31-2024 12:26

    I would like to see all of that!  but I'd be willing to start with just a prompt with options to continue. 

    if you don't mind, I will add your suggestions to it as a comment



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



  • 6.  RE: Inactive items ignored in Manufacturing Modules including BOM and Production Entry.

    Posted 10-31-2024 16:33

    Sure!



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



  • 7.  RE: Inactive items ignored in Manufacturing Modules including BOM and Production Entry.

    Posted 11-01-2024 09:27

    Voted.  



    ------------------------------
    Madeline Stefanou
    RKL eSolutions, LLC
    ------------------------------



  • 8.  RE: Inactive items ignored in Manufacturing Modules including BOM and Production Entry.

    Posted 03-18-2026 11:11

    I realize this thread has been around for a while, but I wanted to jump in and share a solution we've recently proposed after encountering the same issue with another client. Hopefully, this approach will be helpful to others facing similar challenges.

    Here's the plan we're proposing: Step one will be to clean up any inactive items that currently appear on Bills of Material or existing Work Tickets. To kick this off, DWD will create Crystal Reports that help identify all such items. Once the inactive items are flagged, the client will take responsibility for removing them from the relevant Bills of Material and Work Tickets.

    For step two, we're focusing on preventing these issues from cropping up in the future. DWD will add scripting code to Inventory Item Maintenance, which will stop users from marking an item as inactive if it still appears on a Bill of Material or Work Ticket. When someone tries to inactivate an item, a pop-up will display all associated Bills of Materials or Work Tickets containing that item. The item can only be inactivated once the necessary corrections are made.

    We're also implementing scripting in Bill of Materials Maintenance to prevent users from adding a component to a Bill of Material if it's inactive. The same kind of scripting will be used in Work Ticket Entry to block inactive components from being added.

    One thing to note: Users will still be able to add an item to a material issue transaction, BOM production entry, or manually add it to a work ticket and dynamically issue it there. We decided not to explore scripting for these scenarios since it wasn't relevant for this particular client.

    I wanted to share this solution with the group in case it proves useful for anyone else. If you have thoughts or additional suggestions, I'd love to hear them!



    ------------------------------
    David Overholt
    Programmer/Project Manager
    DWD Technology Group
    Fort Wayne IN
    (260) 399-8655
    ------------------------------