Browse By Tags

  • MRP Purchase Suggestions

    Hello, Is there a way to setup MRP to create a planned purchase request as opposed to creating a suggestion? I know the suggestions can be converted to Purchase Requests but or team is looking to remove a step in the process if possible. Any guidance…

  • Planning work order material import for BOM change

    What is the best way to update planning work order material based on the updated BOM? There is no standard import template for MFGMAT. Users requested that they have three old components that is in 189 open work orders that "builds" phantom part# to…

  • Sage 200 MRP SQL Query

    Hi, I am trying to build a excel report using SQL to give me MRP demand. I have built 90% of the report but need to add in the works orders required/demand quantities which haven't been allocated to stock. Below is my current query - any help would be…

  • MRP is not writing into ORDERS table in some items, saying that for that suggestion - Record already exists

    After executing the FUNBCN for MRP, it gives me this error for 2 items: <0001 Table : ORDERS [ORD] <0001 Key : 6 SUG103240000669629 ITM000021322 <0001 Record already exists I looked into ORDERS table and there is nothing created with that number.…

  • Allow user to run MRP only for a product in simulation mode!

    A lot of time user wants to run MRP to see how changes in setup and Product/Product-site gets reflected for an item. Requirements for an item can be driven out of Safety stock, Forecast, or Manufacturing BOM or simply inter-site. In simulation mode…

  • MRP/MPS not producing desired WOS

    I'm struggling to make MRP/MPS provide WOS the way I need them. There are "leftovers" from work orders that the system will count as inventory and either give messages to reduce firmed orders or give wrong WOS. This product is good for that one week,…

  • What is the purpose of the following: Substitution product "Field SBSITM / Screen ITS [ITS]" VS Alternate product "Field RPLITM / Screen ITM2 [ITM2]" in "Product"

    Hello All, Can someone explain the reason for these two fields listed in the subject in "Products" screen. I've read the basic break down's from "F1" help, but we are looking for more real world examples and purposes of these two fields. Could either…

  • Safety Stock Coefficient

    Allow a percentage over or under safety before suggesting supply or replanning supply. So if I have a 10% SS coefficient on 100 pc safety, new supply wouldn't wouldn't suggest until projected stock hits 90. Vice-versa on re-planning. A reduction message…

  • Setting MRP Default BOM Different from MPS Default BOM

    Looking for any words of wisdom or experience in driving MPS from a different BOM, than MRP. All on the same site in the Requirements Parameters Settings. Goals: Allow Purchasing to have a ‘pure’ BOM from which to purchase from (BOM 1) Allow Production…

  • MRP and MPS Prodcuts

    Hi folks! We're in the middle of converting some of our products from MRP to MPS. We noticed on one product the MPS processing wasn't recognizing an existing WOF for supply and suggested an order(EOS) which it really shouldn't. We tested a few scenarios…

  • Missing WOS from the Planning Workbench when running MPS

    We have been running all Finished Good products under MRP for a while now. We are now trying to set these up under MPS so we can take advantage of some additional features. I have taken a single FG item and marked it as MPS and then changed my Planning…

  • MRP and Subcontract

    We're exploring using the subcontracting functionality in X3. First thing I noticed is I'm not getting any supply suggestions from MRP. The product site record is set to subcontract suggestion and there is a subcontract BOM. Other than being a subcontract…

  • Version Management, MRP and Safety Stock

    Hi can anybody clarify for me how MRP handles the safety stock level on the product-site record where the product is version managed? if we have multiple active versions of the product - lets say 3 and we have a safety stock level set at 10. does…

  • MRP operation loads from suggested work roders

    Does X3 create operations for suggested work orders? I have the ROP set for MRP pegging and have the load calculation on for the requirements parameter but not seeing operations for suggested work orders. Routings are out there.

  • Trolley Build Function Sage

    I am wondering if anyone out here has had any experience with the trolley build features with Datalinx? We are thinking of exploring "picking to slot", "Trolley Build", "picking to Carton" functions in our warehouse. Would love to pick someone's brain…

  • Tooling information on Works Orders

    Not sure if anyone can help with this, but while we are using Sage 200 Manufacturing, I am trying to get the tool resources listed on the route card in the right sequence that it would need to go in, we do have multiple boms with multiple tools at different…

  • MRP and Customer Allocations

    We have a case where we want to allocate material to a customer. We set the customer allocation but it appears that when we have a Sales Order for the same customer MRP doesn't net the sales order demand from the customer allocation. It is creating a…

  • Running a addon in Sage 200 on a scheduled task

    I am not sure if this is possible, but we have an addon on Sage that was written by our consultant that updates mrp recommendations and currently this is something that is run manually every morning. I have been asked if I can make it run via a windows…

  • Sage 200 MRP BoM costing out of memory error

    Hi, We have about 8000 BoM's in our MRP system and we have been trying to get them costed for quite a while. But every time we try and do a full cost roll up, it errors with an out of memory exception error. Now I know you can do them by product group…

  • Problem with Action Recommended box in MRP

    I have one weird error on a PC that I have tried everything I can to fix. If the user goes into Planning and the MRP Recommendations List and tries to Action something, it brings up the Action Recommendations box in the task bar but its completely blank…

  • MRP date

    I have a process basically just using the ORDERS(WIP) table. When there is no value for MRP date, SEI shows '01-01-53'. How can I suppress that and still have a value when there is an MRP date? I've played with the calculation but no avail. Was trying…

  • How to Allocate stock/create shortage against intervention

    Hi Guys, V12 PU 25. Wondering if there is a way to manage the following scenario involving service interventions. When creating an intervention typically we need to specify the parts required for the job. We can do this under the consumption…

  • Suggested trasnfer order showing red highlight and cant be selected on the Grouping workbench

    We ran MRP and got some warehouse transfer suggestions On mlost products it is working fine but on a few products we are having the issue below When we go to grouping workbench for suggested warehouse (intersite) transfers the line whos with red highlight…

  • Shipment Pre-receipt not updating expected receipt date on the ORDERS table

    Hi! I'm using the pre-receipt of shipments for purchase orders being imported. Acording to the X3 help, this function should update the EXTRCPDAT of the pre-receipted order in the ORDERS table, even though it doesn't update the original expected date…

  • Using Default Dimensions "Source Document" as a standard when using MRP creating a POF from a POS

    When using default dimensions, if you select a dimension that draws information from the master data, like "Site" for example. the dimension is pulled through without issue. however if you select a different dimension type like "Source Document" there…

*Community Hub is the new name for Sage City