This topic contains 12 replies, has 0 voices, and was last updated by JCirocco 6 years, 6 months ago.

  • Author
    Posts
  • #22921 Score: 0

    SererraMike
    • Contributions: 0
    • Level 1

    Trying to show the buildable quantity on a work order search. "Buildable" is not an option in the drop down. The field ID is "committed", which is not an option either. I've tried "Qty Committed" but that gives no result. I've also tried Formula Numeric – {committed} and I get an error. Can anyone help here?

    Thanks,

    Mike
    This is a cached copy. Click here to see the original post.

  • #22922 Score: 0

    J_Wolf7
    • Contributions: 0
    • Level 1

    Did you ever get an answer to this? I'm seeing the same thing recently, and when I look at my Work Order Form the field is now 'Disabled' by NetSuite. When I click on the field Help I get the field definition of 'committed', including the Field ID. Very frustrating… The Committed field displays the total number of assemblies that are committed to sales on associated assembly builds.

    Field ID: committed

  • #22923 Score: 0

    SererraMike
    • Contributions: 0
    • Level 1

    Sorry. This one never got any traction. I feel like it would a nice option to be able to build into the assembly item record itself, but I've let this one go for the moment.

  • #22924 Score: 0

    mwhite@hgyp.com
    • Contributions: 0
    • Level 1

    Try looking at SuiteAnswers Id: 32913

  • #22925 Score: 0

    SererraMike
    • Contributions: 0
    • Level 1

    Interesting article, but the logic seems incorrect. The top paragraph contains the following statement "Note that the BuildableQuantity = Quantity – Built". This is not correct. Buildable Qty should (and does in the native field) represent the # of units that are possible to be built based on the qty available of the components. For example, I have an assembly, with 4 components, all with a qty of 1 used for the build. If I enter a work order for 100, and 3 of my components have available inventory of > 100, but the last has only 60 units available, my buildable qty would = 60. This is actually how the native field works, I'm not sure why NS support would state this incorrectly in the help document.

    Thanks,

    Mike

  • #22926 Score: 0

    kaj710
    • Contributions: 0
    • Level 1

    After working with NS support and trying several different work arounds, we were unable to get something like this done. Amazing that it can't be done. We even tried building new custom fields to try and source them to be able to create a saved search that shows work orders where all components of an assembly were available.

    Does anyone have a solution or work around that would enable me to build….

    Saved search: Work Orders

    One of two options would work…

    -All components included in the work order are available/quantity on hand of all components > quantity needed.

    OR

    -one specific component of the work order has a quantity on hand or available that is greater than the quantity needed?

    Driving a production team from a list of work orders is USELESS if you cannot parse out the ones with all components available.

  • #22927 Score: 0

    cosmeticsolutions
    • Contributions: 0
    • Level 1

    any updates on this? trying to do the same?

  • #22928 Score: 0

    kaj710
    • Contributions: 0
    • Level 1

    Even with building come custom fields we were unable to make it work…. which is totally absurd as it seems like a very desirable functionality. We are in the process of implementing the Netsuite package WMS (Warehouse Management System). Supposedly this add on will give us the functionality.

  • #22929 Score: 0

    JCirocco
    • Contributions: 0
    • Level 1

    I have a search on the Assembly item that calculates the Buildable Quantity. Since it is not stored it is not available normally for another transaction field to source from BUT you could have a scheduled workflow update a Stored field on the Assembly record every 30 minutes and then source that to a custom transaction field on the Work Order. Not quite real time as the quantity is stored every 30 minutes but might serve your purposes.

  • #22930 Score: 0

    SererraMike
    • Contributions: 0
    • Level 1

    Hey John,

    Could you share how you've structured this search? Are you just looking at the min or max back ordered qty and dividing by the qty or something like that?

    Thanks,

    Mike

  • #22931 Score: 0

    JCirocco
    • Contributions: 0
    • Level 1

    Mike,

    Criteria

    Member Item:Type is any of Assembly/Bill of Material, Inventory Item

    Member Item:Inventory Location is Warehouse

    Results

    Formula (Numeric) Summary Type=Minimum Formula=FLOOR(NVL({memberitem.locationquantityavai lable}, 0)/{memberquantity})

    Available Filters

    Internal ID

  • #22932 Score: 0

    SererraMike
    • Contributions: 0
    • Level 1

    Thanks John, I was thinking about that, but couldn't using the available # be an issue we're doing a search of WOs? If the WO already exists, depending on your commitment settings, the components are potentially already committed. In theory a work order could be completely buildable, with an available qty of 0. Am I looking at this wrong, or is it just a matter of commitment preferences?

  • #22933 Score: 0

    JCirocco
    • Contributions: 0
    • Level 1

    Actually, you are correct. We default our W/O's to released and commit inventory when created (Available Quantity). Technically I teach my customers that a Sales Order not yet approved, and Work Order not released are just pieces of paper and another order can come along and commit the inventory. We also have the same logic on the Item Assembly.

You must be logged in to reply to this topic.