Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0008439 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 06. Material requirement planning (MRP) | major | always | 2009-04-04 15:05 | 2009-07-20 20:17 | |||
| Reporter | rdc02272 | View Status | public | |||||
| Assigned To | gorkaion | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 2.50MP1 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 941009ac6a78 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Windows | Database | PostgreSQL | Java version | 1.5 | |||
| OS Version | XP SP3 | Database version | 8.3 | Ant version | 1.7.1 | |||
| Product Version | 2.40MP4 | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0008439: Manufacturing calculates quantity incorrectly when we have 2 sales orders exactly the same | |||||||
| Description | When we create two sales orders for the same manufactured product with the same delivery date no work requirement will be suggested for the second order. | |||||||
| Steps To Reproduce | Just to make things simple. Product: some manufactured product; lets call it "Truck". Safety stock=0 ; Minimum quantity=0 ; Quantity on hand=0 ; Capacity=0 ; Pending purchases orders=0 1)Create two sales order, with the same delivery date and customer, for 500 units of "Truck" 2)Create manufacturing plan 2.1)Observe that one of the sales order will have a suggested work requirement of zero! Even though, there is no stock available for product "Truck". So we have a total of 1000 units of "Truck" ordered but only 500 units are suggested as work requirements. 3)It should suggest two work requirements of 500 units each. | |||||||
| Proposed Solution | I've attached the original Postgres mrp_processplan_plan function and the new version. I've tracked down the bug to function mrp_processplan_plan. The original version puts the sales order data after the work requirements data thus giving an incorrect stock value. All changes to the stock level should be process before the work requirements changes... I've same some tests (see table below) and it seems to working just fine. However the development has the full requirements so they can test it more thoroughly. Safety Minimum Order1 Order2 Stock quantity QOH Quant. Quant. TestResult 0 0 0 600 600 Ok 10 700 0 600 600 Ok 10 1210 0 600 600 Ok 0 0 500 600 600 Ok | |||||||
| Tags | 250MP1 | |||||||
| Attached Files |  mrp_processplan_plan.zip [^] (11,191 bytes) 2009-04-04 15:05 | |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0015201) rdc02272 (reporter) 2009-04-04 15:06 |
I've forgot to write this: This also happens in Openbravo 2.5 |
|
(0015942) hgbot (developer) 2009-04-29 18:20 |
Repository: erp/devel/pi Changeset: 941009ac6a78e7b58da9b4e3834b6e0a069d64bb Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com> Date: Wed Apr 29 18:19:42 2009 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/941009ac6a78e7b58da9b4e3834b6e0a069d64bb [^] Fixed bug 8439. Fixed the mrp_processplan_plan to track the available stock. The procedure now keeps track of the available stock and not only the actual stock taking into account the demand associated to the productions. --- M src-db/database/model/functions/MRP_PROCESSPLAN_PLAN.xml --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-04-04 15:05 | rdc02272 | New Issue | |
| 2009-04-04 15:05 | rdc02272 | Assigned To | => rafaroda |
| 2009-04-04 15:05 | rdc02272 | File Added: mrp_processplan_plan.zip | |
| 2009-04-04 15:06 | rdc02272 | Note Added: 0015201 | |
| 2009-04-15 22:10 | psarobe | Severity | critical => major |
| 2009-04-15 22:10 | psarobe | Status | new => scheduled |
| 2009-04-15 22:10 | psarobe | Assigned To | rafaroda => gorkaion |
| 2009-04-15 22:10 | psarobe | fix_in_branch | => pi |
| 2009-04-15 22:10 | psarobe | Priority | normal => urgent |
| 2009-04-15 22:10 | psarobe | fix_in_branch | pi => |
| 2009-04-23 16:05 | psarobe | Tag Attached: 250MP1 | |
| 2009-04-29 18:20 | hgbot | Checkin | |
| 2009-04-29 18:20 | hgbot | Note Added: 0015942 | |
| 2009-04-29 18:20 | hgbot | Status | scheduled => resolved |
| 2009-04-29 18:20 | hgbot | Resolution | open => fixed |
| 2009-04-29 18:20 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/941009ac6a78e7b58da9b4e3834b6e0a069d64bb [^] |
| 2009-05-09 20:51 | psarobe | Regression testing | => No |
| 2009-05-09 20:51 | psarobe | Status | resolved => closed |
| 2009-05-10 00:00 | anonymous | sf_bug_id | 0 => 2789539 |
| 2009-07-20 20:17 | rafaroda | Issue cloned | 0009971 |
| 2009-07-20 20:17 | rafaroda | Relationship added | depends on 0009971 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |