Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023199Openbravo ERP06. Material requirement planning (MRP)public2013-02-28 19:492013-03-04 15:49
Reporterumartirena 
Assigned Toumartirena 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0MP21 
Merge Request Status
Review Assigned Togorkaion
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023199: Process Purchase Plan is ordering also by HHMMSSSS while taking into account pending Purchase Orders and Sales Orders
DescriptionWhile executing Process Purchase Plan in Purchasing Plan window, if there are pending Purchase Orders and Sales Orders of the same planneddate, they have also HHMMSSSS and the Sales Order has previous date, while ordering to see the needed qty it will put before the Purchase Order. What is wrong.
Steps To ReproduceRun Purchasing Plan with Pending Sales Order and Pending Purchase Order with planned date with data of time. Create the sales order to the same date by earlier time.
See that while ordering it will take into account before the Purchase Order.
Proposed SolutionChange: ORDER BY pl.planneddate, priority and replace by ORDER BY TRUNC(pl.planneddate), priority
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-02-28 19:49umartirenaNew Issue
2013-02-28 19:49umartirenaAssigned To => dmiguelez
2013-02-28 19:49umartirenaModules => Core
2013-02-28 19:49umartirenaTriggers an Emergency Pack => No
2013-02-28 20:06umartirenaAssigned Todmiguelez => umartirena
2013-02-28 20:14umartirenaStatusnew => scheduled
2013-02-28 20:14umartirenafix_in_branch => pi
2013-02-28 20:28hgbotCheckin
2013-02-28 20:28hgbotNote Added: 0056863
2013-02-28 20:28hgbotStatusscheduled => resolved
2013-02-28 20:28hgbotResolutionopen => fixed
2013-02-28 20:28hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6525ba36c9625f2c8afa1ced47c34d7907bf20e7 [^]
2013-03-02 05:48hudsonbotCheckin
2013-03-02 05:48hudsonbotNote Added: 0056935
2013-03-04 15:49gorkaionReview Assigned To => gorkaion
2013-03-04 15:49gorkaionStatusresolved => closed
2013-03-04 15:49gorkaionFixed in Version => 3.0MP21

Notes
(0056863)
hgbot   
2013-02-28 20:28   
Repository: erp/devel/pi
Changeset: 6525ba36c9625f2c8afa1ced47c34d7907bf20e7
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Thu Feb 28 20:24:19 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/6525ba36c9625f2c8afa1ced47c34d7907bf20e7 [^]

Fixes Issue 0023199: Not order by time Purchasing Plan

---
M src-db/database/model/functions/MRP_PURCHASEPLAN.xml
---
(0056935)
hudsonbot   
2013-03-02 05:48   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/f5db629e7058 [^]

Maturity status: Test