Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 06. Material requirement planning (MRP)majoralways2013-02-28 19:492013-03-04 15:49
ReporterumartirenaView Statuspublic 
Assigned Toumartirena 
PriorityhighResolutionfixedFixed in Version3.0MP21
StatusclosedFix in branchpiFixed in SCM revision6525ba36c962
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Togorkaion
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0023199: 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
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
hgbot (developer)
2013-02-28 20:28

Repository: erp/devel/pi
Changeset: 6525ba36c9625f2c8afa1ced47c34d7907bf20e7
Author: Unai Martirena <unai.martirena <at>>
Date: Thu Feb 28 20:24:19 2013 +0100
URL: [^]

Fixes Issue 0023199: Not order by time Purchasing Plan

M src-db/database/model/functions/MRP_PURCHASEPLAN.xml
hudsonbot (developer)
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: [^]

Maturity status: Test

- Issue History
Date Modified Username Field Change
2013-02-28 19:49 umartirena New Issue
2013-02-28 19:49 umartirena Assigned To => dmiguelez
2013-02-28 19:49 umartirena Modules => Core
2013-02-28 19:49 umartirena Triggers an Emergency Pack => No
2013-02-28 20:06 umartirena Assigned To dmiguelez => umartirena
2013-02-28 20:14 umartirena Status new => scheduled
2013-02-28 20:14 umartirena fix_in_branch => pi
2013-02-28 20:28 hgbot Checkin
2013-02-28 20:28 hgbot Note Added: 0056863
2013-02-28 20:28 hgbot Status scheduled => resolved
2013-02-28 20:28 hgbot Resolution open => fixed
2013-02-28 20:28 hgbot Fixed in SCM revision => [^]
2013-03-02 05:48 hudsonbot Checkin
2013-03-02 05:48 hudsonbot Note Added: 0056935
2013-03-04 15:49 gorkaion Review Assigned To => gorkaion
2013-03-04 15:49 gorkaion Status resolved => closed
2013-03-04 15:49 gorkaion Fixed in Version => 3.0MP21

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker