Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0016521
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 06. Material requirement planning (MRP)majoralways2011-03-28 18:102011-04-05 00:00
ReporteradrianromeroView Statuspublic 
Assigned Toadrianromero 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisiond175cba664f5
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0016521: Wrong quantity in Suggested Purchase Order when running Purchasing Plan

DescriptionWrong quantity in Suggested Purchase Order when running Purchasing Plan: Quantity of suggested purchase order should be sum of quantities of pending sales order
Steps To Reproduce1. Master Data Management || Product || Product : search for Hammer
2. Master Data Management || Product || Product >> Purchasing : add record for Mcgiver with "current vendor " checked
3. Master Data Management || Product || Product >> Org Specific : add record for Main and Capacity=10000 and Safety Stock=0
4. Warehouse Management || Transactions || Physical Inventory || Header : set stock for hammers to 0 units
5. Material Requirement (MRP) || Transactions || Purchasing Plan || Header : create record for
  - Main
  - 02/03/2011
  - time horizon=10
  - safety = 0
  - vendor= mcgiver
  - product=hammer
Material Requirement (MRP) || Transactions || Purchasing Plan || Header >> Lines : add lines
  - line1: hammer + quantities= 0 + dates=02/03/2011 + type= Stock + fixed=Y
  - line2: hammer + quantities= 0 + dates=02/03/2011 + type= MinStock + fixed=Y
  - line3: hammer + quantities= -5 + dates=02/03/2011 + type= PendingSalesOrder + fixed=Y
  - line4: hammer + quantities= -3 + dates=02/03/2011 + type= PendingSalesOrder + fixed=Y
  - line5: hammer + quantities= -2 + dates=02/03/2011 + type= PendingSalesOrder + fixed=Y
6. Come back to Purchasing Plan header and press"Process Purchase Plan". Relize that line of type "Suggested Purchase Order" has Quantity different from 10 (which is sum of 5+3+2)
Proposed Solutionin line 139 of function mrp_purchaseplan should be added
v_neededqty_old := v_neededqty_new;
because actually this variable only is being updated when executing "IF" clause but not "ELSE" clause.

As same block:
v_neededqty_old := v_neededqty_new;
v_qty_old := v_qty_new;
v_stock := v_stock + v_qty_new;
will be executed in IF and ELSE they can be put outside
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks backport 00161052.50MP28 closedadrianromero Wrong quantity in Suggested Purchase Order when running Purchasing Plan 

-  Notes
(0035283)
hgbot (developer)
2011-03-28 18:14

Repository: erp/devel/pi
Changeset: d175cba664f579906fcc99607d4bd3f9689f8e1c
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Mon Mar 28 18:13:13 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d175cba664f579906fcc99607d4bd3f9689f8e1c [^]

Fixes issue 0016521: Wrong quantity in Suggested Purchase Order when running Purchasing Plan
It has been added the missing instruction so set the old needed quantity in all cases

---
M src-db/database/model/functions/MRP_PURCHASEPLAN.xml
---
(0035287)
adrianromero (manager)
2011-03-28 19:08

* Testing the issue

Follow the steps to test and verify that now the line generated of type "Suggested Purchase Order" has a quantity of 10.

Verify also that other combination of purchasing plan lines also generates the line "Suggested Purchase Order" with the correct quantity.

* Other areas affected.

No other areas affected. It has only been modified the purchase plan process.
(0035531)
maite (developer)
2011-04-04 12:43

verified

- Issue History
Date Modified Username Field Change
2011-03-28 18:10 adrianromero New Issue
2011-03-28 18:10 adrianromero Assigned To => adrianromero
2011-03-28 18:10 adrianromero Modules => Core
2011-03-28 18:10 adrianromero Issue generated from 0016105
2011-03-28 18:10 adrianromero Relationship added blocks 0016105
2011-03-28 18:14 hgbot Checkin
2011-03-28 18:14 hgbot Note Added: 0035283
2011-03-28 18:14 hgbot Status new => resolved
2011-03-28 18:14 hgbot Resolution open => fixed
2011-03-28 18:14 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d175cba664f579906fcc99607d4bd3f9689f8e1c [^]
2011-03-28 19:08 adrianromero Note Added: 0035287
2011-04-04 12:43 maite Note Added: 0035531
2011-04-04 12:43 maite Status resolved => closed
2011-04-05 00:00 anonymous sf_bug_id 0 => 3274932


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker