• What happens to a Work Order if a Routing becomes inactive?

    Work order was created and then a month later the Routing/Version was made 'inactive' but the Work order wasn't finished. Would this cause any issues with the Schedule generation? Or does the routing only need to be active when the WO is created.…

  • Exclude a work order from Schedule Generation?

    Is there a way to exclude certain work orders when generating a schedule? I've searched online forums/read books but I do not see anything on if we can exclude certain work orders. Please advise.
    This is in reference to the 'Schedule Generation' after…

  • Error in CalcCrRatioSlackTime Routine

    Trying to run Schedule Generation for the first time and i'm getting a few errors.

    it was going through the steps and stopped at a work order. gave an "Error 5 occurred at frmmfzmn001 in Procedure cmdGenerateSched_Click. Invalid procedure call or…

  • MRP Generation enhancement for items using Manual reorder method

    Starting with the October 2019 product update for Sage 500 version 2019 we have made a change to MRP processing user interface. As shown in the screenshots in the Material Requirements Planning Generation form’s Options tab we have replaced in the Selection…

  • What access is needed to run MRP?

    What am I missing here, I have some users that I am trying to setup to use the MRP Generation. When they get to the "Planned Orders" tab, under Generate the Planned Orders is grayed out. But they can select "Actual Orders". They are setup with Supervisory…

  • Does MRP Generation look at Purchase order tables?

    When MRP Generation is running, does it look at the open PO's, what does it look at? Does it look at Header or Detail line tables? Or does it go by the PO Log? Reason for asking is that I see a lot of entries in the PO Log that are not in the Header/Detail…

  • During MRP, received error "Cannot create steps for Planned order. Error in Routing xxxxx, step

    Received this error on several of the items. We have reviewed the routings/steps and do not see any issues. The are set to Standard/Active. Some are Phantoms, some are stand alone. What could cause these type of errors?

  • Lead Time Formula vs Projected Lead Time

    If you specify both a Lead Time formula & Projected lead time in the Maintain Inventory, which does MRP consider? I did a average lead time calculation based on the last 15 months using the PO date vs the Receipt date and was going to update the Projected…

  • Creating Planned, Firmed, and Actual orders in MRP

    After the Generate Planned Orders has been run, the system will show all the suggested orders to create. The suggested orders is based on the MRP factors that have been selected on the Planned Orders tab. At this time, the work orders and purchase orders…

  • Unit of measure conversion

    Ok, I'm running Sage MRP against our system and I have found a issue with unit of measure.  We have a base unit of measure of EA .  We sell in units of "72 cel" which are set up properly to the best of my knowledge as 72 each's.  However…

  • Product Configurator - Sage 500 ERP Manufacturing

    Has anyone implemented this module with Sage 500 Manufacturing in a discrete environment?

  • Forecast and MRP

    Ok, we have work orders, sales orders and forecast all going into MRP.  For sales orders and work orders I see the inventory as UOM Each.  However, I think that the forecast is coming in UOM 72 or 30 (our flat size ).  As you can see below the forecast only…

  • Undocumented secret ?

    Version 2014. I just recently found this by shear accident. MRP planned orders tab, in the date cells for Req Date or Ord Date. Double click a date in the cell to activate, then double click it again and a calendar pops up to pick a new date. Now I don…

  • Replenishment, setting up for MRP

    We are getting to the stage we want to set up our system to run MRP and work off the min/max, safety stock setup.

    I believe I read somewhere, although I can not find it now, That MRP uses safety stock level along with the EOQ of the active and standard…

  • Work order to sales order link

    I'm having issues with linking existing work orders to existing sales orders.  I can link the sales order to the work order using work order maintenance but only for some sales orders.  For example I have a existing work order and I choose the correct…

  • MRP generate purchase orders

    On version 7.40.4.0 and MRP grabs the replacement cost from the inventory record when generating a purchase order. Any way to get it to look at vendor item info instead?

    John

  • RE: Demand Report

    We have an Enhanced MRP module for Sage 500 that allows you to view all demand for items within MRP. You can drill-down to see sales orders, work orders, and forecasts. We also have reports that may also be useful. You can watch a short overview video…

  • RE: Demand Report

    Not out of the box. You can use MRP to accomplish that. It wouldn't be an 'exploded BOM' style, but all the info you're looking for would be on the screen/report.

  • Demand Report

    Is there a way to get a report for a specific Item number BOM that explodes out all levels and shows what is on WO and on PO?

    It would be for a certain quantity of the upper assembly. It would have what's on order and what we have on hand, versus what…

  • Indented BOM

    Hi,

    Version is Sage 500 7.4x

    I would like to get Excel export of Indented Bill of Materials out of Sage 500.  Does any one know how to get a indented Bill of Material? 

    Any help you can provide would be great.