0008583: 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

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0008439

closed

gorkaion

Manufacturing calculates quantity incorrectly when we have 2 sales orders exactly the same

Notes
(0016170) hgbot (developer) 2009-05-08 11:44	Repository: erp/stable/2.40 Changeset: eb154ffd8378539437729d3af16585f74fb5300e Author: Gorka Ion Damián <gorkaion.damian <at> openbravo.com> Date: Fri May 08 11:44:16 2009 +0200 URL: http://code.openbravo.com/erp/stable/2.40/rev/eb154ffd8378539437729d3af16585f74fb5300e [^] Fixed bug 8583. 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 ---

(0016547) sureshbabu (reporter) 2009-05-21 08:15	Tested working fine

Issue History
Date Modified	Username	Field	Change
2009-04-15 22:10	psarobe	Type	defect => backport
2009-04-15 22:10	psarobe	fix_in_branch	=> 2.40
2009-04-23 13:52	rafaroda	Assigned To	rafaroda => gorkaion
2009-05-08 11:44	hgbot	Checkin
2009-05-08 11:44	hgbot	Note Added: 0016170
2009-05-08 11:44	hgbot	Status	scheduled => resolved
2009-05-08 11:44	hgbot	Resolution	open => fixed
2009-05-08 11:44	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/stable/2.40/rev/eb154ffd8378539437729d3af16585f74fb5300e [^]
2009-05-08 12:09	villind	Issue Monitored: villind
2009-05-10 19:37	psarobe	Fixed in Version	=> 2.40MP4
2009-05-21 08:15	sureshbabu	Regression testing	=> No
2009-05-21 08:15	sureshbabu	Status	resolved => closed
2009-05-21 08:15	sureshbabu	Note Added: 0016547