Open Forum

 View Only
  • 1.  Planning Worksheet - One Item, Multiple Vendors

    SILVER CONTRIBUTOR
    Posted Nov 26, 2021 09:59 AM
    Hi All,

    I have a scenario where I have one component item required for a job.  I have issued two separate PO's, from two separate vendors, with the same item.  I have purchased the total amount required in time for the job, but the Planning Worksheet MRP function creates two separate lines referencing the two PO's.  It is suggesting an action message to purchase the entire quantity needed by one vendor, and to cancel the other PO.  I do not want this to happen because there are times that we need to order from separate vendors based on availability of an item.  I thought maybe it was because there was a prioritized vendor setup at the item card level, but the vendor field is blank.

    We are getting the item component in time and with the quantity required, so it should not be an issue.  Is there any way around this so it doesn't populate in the Planning Worksheet?

    Bradley

    ------------------------------
    Bradley Schacht
    Clesen Wholesale
    Evanston IL
    ------------------------------


  • 2.  RE: Planning Worksheet - One Item, Multiple Vendors

    TOP CONTRIBUTOR
    Posted Nov 29, 2021 08:48 AM
    On the PO Lines, hidden field so you'll need to display it, there is a Planning Flexibility field.  You can change the setting to None to stop the Planning Worksheet from trying to change it.

    ------------------------------
    Ben Baxter
    Consultant
    Accent Software, Inc.
    Carmel, IN
    ------------------------------



  • 3.  RE: Planning Worksheet - One Item, Multiple Vendors

    SILVER CONTRIBUTOR
    Posted Nov 29, 2021 11:51 AM
    It worked, thanks Ben.  Great feature for managing different workflows in our business.

    I have another scenario in question: We have PO's for items that are NOT planned yet.  This is due to long lead times for specific items and we have a speculation forecast process in place that hasn't begun yet prior to forecasting and creating production orders.  We know that we will eventually plan it and create a production order, but the Planning Worksheet is now building action messages to cancel the supply.  I set the planning flexibility to none on the PO line.  Now, it no longer populates in the Planning Worksheet, which is what I want.  But, when we create a production order down the road for this supply, will it recognize any necessary change in quantity or date?  Let's say the PO currently has 100 on order to arrive on 11/1/22.  But, once we set up our production order, the plan is for 200 for 12/1/22.  If it is set as "none" in planning flexibility, will the Planning Worksheet create the action message to add 100 more of the supply as well as a necessary date change?

    I'm still not quite sure if I understand it's true functionality.  I'd appreciate any extra insight.



    ------------------------------
    Bradley Schacht
    Clesen Wholesale
    Evanston IL
    ------------------------------



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