Browse By Tags

  • Can MRP Generation be scheduled to run automatically?

    The MRP module does not appear in the Task Scheduler Module drop-down list. We would like to schedule MRP Generation to run unattended nightly. Is it possible to do that? Thank you.
  • Sage X3 BOM and MRP

    We have requirement that customer is having multiple BOMs for the same product during the year. When running MRP will Sage X3 be able to pick the right BOM's based and provide the requirements considering the Start Dates and End dates. Is there any possibility…
  • Ability to set minimum order quantities (MOQ) by vendor for items.

    Does Sage 100 (v. 2019) provide a method for specifying minimum order quantities by vendor for inventory items? We know how to set minimum order quantities for an item at the warehouse level using "Reorder Maintenance," but we have not found a facility…
  • "[ProvideX][ODBC Driver][FILEIO]No Data Found" when refreshing Microsoft Query results in Excel against table MP_04SuppliesAndDemands. Worked until recently.

    We need an MRP report that is just a small subset of the entire 154 p. report and in a format more readily readable by our purchasing buyers. Using a silent connection string, I created a MSQuery table in Excel that brings in the filtered results of MRP…
  • EOQ and Technical lot

    We're trying to get MRP to do WOS's in increments using the EOQ and Technical lot. Here's the situation. Say the build needs to be 9,123 to get to ideal inventory position. What we're trying to get is 2 WOS's of 4,000 each and 1 WOS of 2,000 which would…
  • Inter-Site Suggestion for multiple production sites

    We have an environment in V11 Patch 8 and need to have MRP trigger inter-site suggestions with multiple sites. The product is manufactured in both sites, but we need suggestions from the warehouses to drive the intersite movements. Here are the sites…
  • MRP Available stock vs By order

    Internal constraints don't allow us to have a WOF of more than 5,000. If we have a SOF for 15,000 and 3 WOF's for 5,000 each, replanning wants us to increase the first WOF to 15,000 and cancel the other two WOF's in the same time bucket. Is there a way…
  • How to get MRP Suggestions to use Routing Run Time and Purchase LT?

    MRP suggestions don't seem to incorporate Purchase LT as specified on Product-site records, and Run Time as specified in the corresponding Routing. Is there an overview or something that describes what affects this? It feels like things have been set…
  • Stock location or status not nettable for MRP

    We have a requirement to have some items in stock but not show as available for MRP. I looked for a flag on the location or location type to say not for MRP, but can't seem to find anything. We want MRP to see Quality stock including status R since…
  • 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.
  • Outsourced Jobs accounting in SAGE 100

    Hello SAGE ppl, We buy parts from vendor as 001 and that part for outside job and receive it as 002 - How can we account that in SAGE system? We are placing PO and receiving 001 part @ price X. Now we are placing PO and and receive the part 002 @…
  • Open PO Qty vs On PO qty discrepancy

    Hello All, We are using SAGE 100. Somehow On PO qty coming in Stock status report is not Open PO Qty. SAGE is pulling a open PO qty from somewhere - SAGE ppl kindly share your thoughts In the below example, in main I m seeing a open PO qty but in…
  • Ability to split purchase order suggestions by a defined percentage between suppliers.

    Some clients have arrangements where they award 80% of the business to a primary supplier and 20% of the business to a secondary supplier. It would be great if the purchase suggestions can see a split of the business across various suppliers and factor…
  • 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…
  • Anyone else interested in a separate MRP/Planning forum?

    Might be good to have something very specific for manufacturing and distribution. Sage 500 had that and it was really good.
  • 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 argument…
  • How to inform MRP of regular receipts

    We have a process similar to a bottle return, where we regularly receive 60/widgets back from customers a week. How can I inform MRP of these POSs? Forecasts show planned deductions, how do i show planned receipts without creating POP/POF?
  • MRP Starting Stock

    MRP Starting stock What is Starting stock in MRP? A variable is used to maintain the quantity of stock available throughout the MRP process. This available stock is updated by .. initialized to the quantity of stock available at the start of the…
  • Does MRP pegging only do suggested materials and not loads?

    Still a newbie here....
  • How does MRP determine Suggested Work Order Start date

    Can someone shed some light on how MRP calculates the suggested work order start date. We have a demand forecast for quantity 1 in week 4 of Feb When we run enterprise planning it shows that the requirement date based on the demand forecast…
  • Requirement parameters

    In requirements parameters, replanning rules, if I set the type WOF to simulation, I don't get any WOS's. When I set the method to Messages only, I get WOS's but the message is to Cancel. Also it seems to be planning for way too much expected stock. I…
  • 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…
  • Grouping lines on Projected Stock enquiry screen

    Hi all, I have a client who processes lots of small suggestions daily on MRP. They then use the Projected Stock enquiry to view stock levels for the next few weeks. This is obviously throwing up hundreds of lines per day (as it pulls through all the…
  • 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…
  • The Impact of the Reorder Policy on MRP

    The reordering policies are set for a given product to specify certain details during the requirement calculations (MRP & MPS) to identify the suggestion type, the reorder quantity, the splitting, the safety stock, the use of the loss percentage and the…