From: SourceForge.net <no...@so...> - 2009-02-28 03:20:59
|
Libero item #2556150, was opened at 2009-02-02 08:38 Message generated for change (Comment added) made by bayucahya You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=934929&aid=2556150&group_id=176962 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: MRP Group: None Status: Open Resolution: Fixed Priority: 9 Private: No Submitted By: Bayu Cahya P (bayucahya) Assigned to: Teo Sarca (teo_sarca) Summary: MRP, more supply for a demand Initial Comment: Hi all, We are using trunk rev 8275 with PostgreSQL. Build trunk, create database and applied all migration script (latest 409) Tasks 1. delete existing MO for Fertilizer#50 and Fertilizier#70 2. no existing Requisition for Fertilizer raw material 3. set vendor for Bag50 KG which avoide "No current vendor selected" MRP message 4. calculate material plan/MRP 5. there were 1 MO and 2 requisition 6. see MRP Info in this stage (mrp-info1.png). Mentioned that no supply (Requisition) there 7. complete both requisition for Bag50 and Fertilizer_Lawn Fertilizer 8. MRP Info still the same with mrp-info1.png 9. Perform Planned Order Approval for MO, process successful. MO state in InProgress. 10. MRP info still had the same status like mrp-info1.png. Status MO still in draft (strange) 11. calculate material plan/MRP again 12. MRP info in this stage (mrp-info2.png) has 2 MO, which in draft state for both 13. checking in MO, the first MO has InProgress while the other in the Draft ---------------------------------------------------------------------- >Comment By: Bayu Cahya P (bayucahya) Date: 2009-02-28 09:12 Message: Hi Cristi, Thank you. Finally I can determine about what is the gap between you and me. Previously, I just take a more deeper look at the MRP test and it does matter at the order policy. It works perfectly with LFL. Now, please try to replace your order policy to POQ, run MRP and examine your results. WDYT? Thanks and regards Bayu http://sistematika.web.id ---------------------------------------------------------------------- Comment By: Cristi P (cristi_p) Date: 2009-02-27 21:56 Message: I apologize for mistake of missing Order Qty. -------- Z1 ------------------------ 1. BOM & Formula : z3_z3_1000078 (but don't matter, I think) 2. Workflow : Not specified 3. Order Policy : LFL 4. Order Period : 0 5. Order Qty : 23 6. Safety Stock Qty : 0 7. Yield : 100 -------- X1 ------------------------ 1. BOM & Formula : Not Specified 2. Workflow : Not Specified 3. Order Policy : LFL 4. Order Period : 0 5. Order Qty : 10 6. Safety Stock Qty : 0 7. Yield : 100 -------- X2 ------------------------ 1. BOM & Formula : Not Specified 2. Workflow : Not Specified 3. Order Policy : LFL 4. Order Period : 0 5. Order Qty : 13 6. Safety Stock Qty : 0 7. Yield : 100 ------------------------------------- ---------------------------------------------------------------------- Comment By: Cristi P (cristi_p) Date: 2009-02-27 21:51 Message: Hi Bayu, I'm sorry I couldn't be online, just now I see your message. On the other hand, my case was really simple. Z1 / \ X1 X2 -------- Z1 ------------------------ 1. BOM & Formula : z3_z3_1000078 (but don't matter, I think) 2. Workflow : Not specified 3. Order Policy : LFL 4. Order Period : 0 5. Order Qty : 0 6. Safety Stock Qty : 0 7. Yield : 100 -------- X1 ------------------------ 1. BOM & Formula : Not Specified 2. Workflow : Not Specified 3. Order Policy : LFL 4. Order Period : 0 5. Order Qty : 6. Safety Stock Qty : 0 7. Yield : 100 -------- X2 ------------------------ 1. BOM & Formula : Not Specified 2. Workflow : Not Specified 3. Order Policy : LFL 4. Order Period : 0 5. Order Qty : 0 6. Safety Stock Qty : 0 7. Yield : 100 ------------------------------------- Please, send me your informations about Data Planning, BOM, Workflow and any other documents you think you made some changes and can influence you results and I will discuss with others about this, to check what is the problem. If you can, attach screenshots where is possible, like you did before, to see more clearly what's happen. Best regards, CristiP - www.arhipac.ro ---------------------------------------------------------------------- Comment By: Bayu Cahya P (bayucahya) Date: 2009-02-27 15:53 Message: Hi Cristi, Could you give me a detail information about Product Planning Data for your product and your material? What is the value for 1. BOM & Formula 2. Workflow 3. Order Policy 4. Order Period 5. Order Qty 6. Safety Stock Qty 7. Yield Thanks and regards Bayu http://sistematika.web.id ---------------------------------------------------------------------- Comment By: Bayu Cahya P (bayucahya) Date: 2009-02-27 14:05 Message: Hi Cristi, Can we talk with Skype? Its so long to resolve this issues. I am online now with id bcahya regards Bayu http://sistematika.web.id ---------------------------------------------------------------------- Comment By: Cristi P (cristi_p) Date: 2009-02-23 20:02 Message: Hi Bayu, I followed your steps, with specification of step 7. 1. Create new client 2. Set org.eevolution.model.LiberoValidator on model validation classes in the client 3. Create new product 4. Create new BOM with 2 material 5. Create new Manufacturing Wf 6. Create product planning 7. Create PO with the product you want to manufacturing 8. Run MRP 9. Complete 1 MO and 2 Requisition. 10. Run MRP again and generate 1 more requisition My Test Case was next, similar to yours, but with some additional specifications: 1. I have a Client 2. org.eevolution.model.LiberoValidator on model validation classes is set for this client 3. I created 1 new warehouse 4. I created 3 new products 5. I created a new BOM with 2 material raw (created at previous step) 6. I created Product Planning for each of those 3 products 7. I created a new Manufacturing Workflow 8. I created a PO with the product you want to manufacturing (one of the three products created at step 4, which is not a raw material) 9. I ran MRP on warehouse created at step 3 10. Complete the 1 MO and 2 Requisitions generated after running. 11. I ran MRP again and generate me just 2 Notifications - MRP-060, which inform me to release the supply orders completed at previous step. The results were correct, the expected actually. I ask you why just one Requisition is generated an for which product is this Requisition generated. Can you give a more precisely Test Case, with quantities and exactly steps you follow? Also, I want to ask you again if you can reproduce your case with MRPTest engine? What are the results? Can you post screenshots of your MRP Info window, for each step when something change. On the other hand, I ask Victor or Enrique Ruibal to say if they can reproduce this issue. Best regards, CristiP - www.arhipac.ro ---------------------------------------------------------------------- Comment By: Bayu Cahya P (bayucahya) Date: 2009-02-23 16:51 Message: Hi Teo, Just try to : 1. Create new client 2. Set org.eevolution.model.LiberoValidator on model validation classes in the client 3. Create new product 4. Create new BOM with 2 material 5. Create new Manufacturing Wf 6. Create product planning 7. Run MRP 8. Complete 1 MO and 2 Requisition. 8. Run MRP again and generate 1 more requisition Still not working (no luck) I didn't understand this case finally though regards Bayu http://sistematika.web.id ---------------------------------------------------------------------- Comment By: Teo Sarca (teo_sarca) Date: 2009-02-17 23:00 Message: Hi Bayu, I suggest to start your test with a new product, just to isolate the test. Please confirm if it's working. In meantime i am setting the status to Pending. Best regards, Teo Sarca - www.arhipac.ro ---------------------------------------------------------------------- Comment By: Cristi P (cristi_p) Date: 2009-02-13 17:14 Message: Hi Bayu, There were some errors, at MRP-060 Notice and updating PP_MRP table (see the libero tracker). I suggest you to run "Create Record MRP" process, and things should be all right. Best regards, CristiP - www.arhipac.ro ---------------------------------------------------------------------- Comment By: Bayu Cahya P (bayucahya) Date: 2009-02-13 09:53 Message: Hi Cristi, I have take a look at MRPTest and run it without fail. The major concern is, the PP_MRP records. Please correct me if I am wrong. This test assumed that the PP_MRP records is there and have a synchronize data with the MO, Requisition and Purchase Order data. With my cases, it seems that our PP_MRP records is not in the synchronize status with our requisition. Just want to know about the gap of our configuration. Could you tell me about how to setup LiberoValidator in current trunk? Is it just set up to System model validator window or we have to setup it in the Client model validation classes? I could sent our samples database for you if you like. Thanks and regards Bayu http://sistematika.web.id ---------------------------------------------------------------------- Comment By: Cristi P (cristi_p) Date: 2009-02-11 17:38 Message: Hi Bayu, I can not backup our current test database because it contains a lot of data and a lot of customizations. But please, tell me if you can reproduce your issue with MRPTest engine? Best regards, CristiP - www.arhipac.ro ---------------------------------------------------------------------- Comment By: Bayu Cahya P (bayucahya) Date: 2009-02-11 16:08 Message: Hi Cristi, Instead of the database, yes, we are using the same resource. For further testing, if that's okay, could you backup your trial database and sent it to me? Thanks and regards Bayu http://sistematika.web.id ---------------------------------------------------------------------- Comment By: Cristi P (cristi_p) Date: 2009-02-11 15:33 Message: Hi Bayu, 1.;2. I don't use GardenWorld but I use original libero. Here is where you can find the framework: http://adempiere.svn.sourceforge.net/svnroot/adempiere/branches/libero 3. The MRP.java that I use you can find here (it's up to date): http://adempiere.svn.sourceforge.net/svnroot/adempiere/branches/libero/extension/eevolution/libero/src/main/java/org/eevolution/process/MRP.java Best regards, CristiP - www.arhipac.ro ---------------------------------------------------------------------- Comment By: Bayu Cahya P (bayucahya) Date: 2009-02-11 10:01 Message: Hi Cristi, It is so strange! Could you help me to answer my question 1. Are you using GardenWorld? 2. What is the value in the Model Validation Classes in the Client window? 3. Could you attach your MRP.java files? Thanks and regards Bayu http://sistematika.web.id ---------------------------------------------------------------------- Comment By: Cristi P (cristi_p) Date: 2009-02-10 20:02 Message: Hi Bayu, I wish to thank you the same for your involvment in this issue (MRP). Those are my results related to your request. In my case, I have the following BOM structure, where P1, P2, P3, P4, P5 are different products (P2, P4, P5 are raw material). P1 / \ P2 P3 / \ P4 P5 When I run Calculate Material Plan process, it gives me 2 MO (for P1 and P3) and 3 Requisition (for P2, P4, P5). After I set In progress 1 MO, it generate just 1 MO, 3 Requisition and 1 Notice - MRP-060. After that, I finalize the others 3 Requisition generated and run Calculate Material Plan again. The process generate just 1 MO and 4 Notice - MRP-060 - for 1 MO and the 3 Requisition. After I finalize the 5 documents, I receive 5 Notifications - MRP-060. MRP-060:Release Due For:Indicate that a supply order should be released. If it is a draft order , it must also be approved. I think this is the right result. So, I'm not receive your error. I ask for others opinion! WDYT? Best regards, CristiP - www.arhipac.ro ---------------------------------------------------------------------- Comment By: Bayu Cahya P (bayucahya) Date: 2009-02-10 08:50 Message: Hi Cristi, Thank you for getting involved in this issue. Today, I have build from both last trunk and libero. I created a new product called Dress (a Blouse) which requires 2 material: 1. Fabric 2. Button I am done with setting BOM, manufacture workflow, product planning and attached to specific resource. For MO, yes, now it works, while I set the status to InProgress or Complete, there are no additional MO created while running MRP. The weird things is for raw material. After completion requisition both for Fabric and Button, then the requisition was re-create again for the button only (and not for Fabric) after running MRP. Could you made a testing with at least two raw material and confirm your results? Thanks and regards Bayu ---------------------------------------------------------------------- Comment By: Cristi P (cristi_p) Date: 2009-02-06 22:07 Message: Hi Bayu, Teo and Victor I tested a similar case with the one you presented in your screenshots. My simple case is this: Initially I have a quantity of 0 in Warehouse from this product. I have a Requisition with folowing parameters: DatePromised = 27.02.2009 DateStartSchedule = 26.02.2009 TypeMRP = Supply (S) DocStatus = Draft (DR) Qty = 90 I have at the same time a Sales Order with folowing parameters: DatePromised = 27.02.2009 DateStartSchedule = 27.02.2009 TypeMRP = Demand (D) DocStatus = Completed (CO) Qty = 100 After I run the process Calculate Material Plan, it gives me a notification, MRP-060, and no Requisition. MRP-060 Indicate tha a supply order should be released. If it is a draft order, it must also be approved. I think, in my opinion, this is the right result. WDYT? Best regards, CristiP - www.arhipac.ro ---------------------------------------------------------------------- Comment By: Bayu Cahya P (bayucahya) Date: 2009-02-06 11:01 Message: Hi Teo, > To go back to your example, the right solution will be : > * to NOT generate more supply because you already have some planned orders > (i.e. your completed requisition) > * to trigger an MRP-060 notice which will tell you that you should release > your orders (i.e. transform the Qty into Scheduled Receipts by generating > the PO from that requisition) I am absolutely agree to both of your point. Here, with proprietary ones, they will generate an action messages (while we call it notice) to fulfill the demand. I just re-test, but, it seems that current codes still create more requisition and MO. Thanks and regards Bayu http://sistematika.web.id ---------------------------------------------------------------------- Comment By: Teo Sarca (teo_sarca) Date: 2009-02-04 17:10 Message: Fixed in libero branch. Please update & review it now. Revision: 8306 http://adempiere.svn.sourceforge.net/adempiere/?rev=8306&view=rev Author: teo_sarca Date: 2009-02-04 09:46:13 +0000 (Wed, 04 Feb 2009) Log Message: ----------- [ 2556150 ] MRP, more supply for a demand https://sourceforge.net/tracker/?func=detail&atid=879332&aid=2556150&group_id=176962 [ 2561164 ] Not received the notifications MRP-030 and MRP-040 https://sourceforge.net/tracker/?func=detail&atid=879332&aid=2561164&group_id=176962 * minor refactory Modified Paths: -------------- branches/libero/extension/eevolution/base/src/org/eevolution/model/MPPMRP.java branches/libero/extension/eevolution/base/src/org/eevolution/process/MRP.java ---------------------------------------------------------------------- Comment By: Teo Sarca (teo_sarca) Date: 2009-02-04 17:09 Message: Hi Bayu, I understand correctly your use-case and here are my comments: > Now, complete the Requisition and MO. At this level, still supply = > demand. Hmmm. Not really because in order to fulfill the demand (Gross Requirements) you will need Quantity On Hand (QOH) and firm supply (Scheduled Receipts). Firm supply is created by firm documents (e.g. purchase order). A requisition is not a firm document from this point of view, EVEN if is completed, because is not representing an agreement between you and your supplier (nothing sure). To go back to your example, the right solution will be : * to NOT generate more supply because you already have some planned orders (i.e. your completed requisition) * to trigger an MRP-060 notice which will tell you that you should release your orders (i.e. transform the Qty into Scheduled Receipts by generating the PO from that requisition) WDYT ? Best regards, Teo Sarca - www.arhipac.ro ---------------------------------------------------------------------- Comment By: Bayu Cahya P (bayucahya) Date: 2009-02-04 07:45 Message: Hi Teo, Victor, Let me clarify this issue. While I have a demand which comes from Sales Order like Fertilizer#50 qty 10, then system would be generated Requisition and Manufacturing Order supply. The generated Requisition and MO are to fulfill a Fertilizer#50 qty 10. Now, complete the Requisition and MO. At this level, still supply = demand. Next, we will run Calculate Material Plan (MRP) once again. In this stage, system will generated more Requisition and MO, which mean that total supply more than a demand. As Victor says, I have to expire our product. But I think, it might not a better solution. Imagine that we have a more Sales Order on this product, we have to run MRP for this products, rights? In other system I am familiar with, MRP would be calculated a supply from accumulated outstanding Requisition/Purchase Order, MO and Finish Goods. While total available projected qty doesn't sufficient, then they will generate more Requisition and MO to produce more Finish Goods. Thanks and regards Bayu ---------------------------------------------------------------------- Comment By: Teo Sarca (teo_sarca) Date: 2009-02-03 19:44 Message: Hi Bayu, I think this issues should be handled by following MRP notices: MRP-060 Release Due For Indicate tha a supply order should be released. if it is a draft order , it must also be approved. MRP-070 Release Past Due For Indicates that a supply order was not released when it was due, and should be either released or expedited now, or the demand rescheduled for a later date. Which are not implemented at the moment. Best regards, Teo Sarca - www.arhipac.ro ---------------------------------------------------------------------- Comment By: Bayu Cahya P (bayucahya) Date: 2009-02-02 08:44 Message: 14. system create 2 more requisition File Added: requisition.png ---------------------------------------------------------------------- Comment By: Bayu Cahya P (bayucahya) Date: 2009-02-02 08:39 Message: Adding screen shot for mrp-info2 File Added: mrp-info2.png ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=934929&aid=2556150&group_id=176962 |