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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0009971

Openbravo ERP

06. Material requirement planning (MRP)

public

2009-07-20 20:17

2009-08-12 13:03

Reporter

networkb

Assigned To

rafaroda

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

no change required

Platform

OS Version

XP SP3

Product Version

2.40MP4

Target Version

2.50MP4

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

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

Additional Information