Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0005976

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

defect

[Openbravo ERP] 06. Material requirement planning (MRP)

major

always

2008-11-14 21:43

2009-04-21 11:07

Reporter

slava_u

View Status

public

Assigned To

gorkaion

Priority

high

Resolution

fixed

Fixed in Version

Status

closed

Fix in branch

Fixed in SCM revision

Projection

none

ETA

none

Target Version

OS

Any

Database

Any

Java version

1.6

OS Version

Database version

Ant version

1.7

Product Version

2.40

SCM revision

Merge Request Status

Review Assigned To

OBNetwork customer

No

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0005976: When MRP creates Material Requisitions, it does not put UOM in requisition lines

Description

When MRP creates Material Requisitions, it does not put UOM in requisition lines (and it's not possible to change it because they are grayed). It means it's impossible to create Purchase order from the Requisitions that were produced by MRP later.
In the source code of MRP_REQUISITION.xml it's simply missing part which inserts UOM-s to the M_REQUISITIONLINE

Steps To Reproduce

Just process MRP-> "Generate Material Requisitions".
All Requsitions lines will be with empty UOM.

Proposed Solution

Something like it:

--- MRP_REQUISITION.xml 2008-11-14 21:14:32.000000000 +0100
+++ n/MRP_REQUISITION.xml 2008-11-14 21:15:24.000000000 +0100
@@ -95,11 +95,12 @@
     );

     FOR Cur_workproposal IN (
- SELECT *
- FROM MRP_RUN_PRODUCTIONLINE
+ SELECT MRP_RUN_PRODUCTIONLINE.*, M_PRODUCT.C_UOM_ID
+ FROM MRP_RUN_PRODUCTIONLINE,M_PRODUCT
       WHERE MRP_RUN_PRODUCTION_ID = v_Record_ID
         AND INOUTTRXTYPE = 'MP'
         AND M_REQUISITIONLINE_ID IS NULL
+ AND MRP_RUN_PRODUCTIONLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID
       ORDER BY PLANNEDDATE
       ) LOOP
       v_ResultStr:='Create Requisition';
@@ -110,12 +111,12 @@
         M_REQUISITIONLINE_ID, AD_CLIENT_ID, AD_ORG_ID,
         ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY,
         M_REQUISITION_ID, NEEDBYDATE, M_PRODUCT_ID,
- QTY, LINE
+ QTY, LINE, C_UOM_ID
       ) VALUES (
         v_MRequisitionLine_ID, v_Client_ID, v_Org_ID,
         'Y', now(), v_User_ID, now(), v_User_ID,
         v_MRequisition_ID, Cur_workproposal.PLANNEDDATE, Cur_workproposal.M_PRODUCT_ID,
- Cur_workproposal.QTY, v_Line
+ Cur_workproposal.QTY, v_Line, Cur_workproposal.C_UOM_ID
       );

       UPDATE MRP_RUN_PRODUCTIONLINE

Tags

No tags attached.

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0010434) rafaroda (viewer) 2008-11-20 10:49	Please detail a simple example step by step so later on QA team will verify if it's fixed or not

(0010548) rafaroda (viewer) 2008-11-24 11:59	Reminder sent to: slava_u Please detail a simple example step by step so later on QA team will verify if it's fixed or not

(0011208) svnbot (viewer) 2008-12-11 19:27	Repository: openbravo Revision: 11130 Author: gorkaion Date: 2008-12-11 19:27:48 +0100 (Thu, 11 Dec 2008) Fixed bug 5976. Modified the procedure to include the C_UOM_ID in the insert statement. --- U trunk/src-db/database/model/functions/MRP_REQUISITION.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=11130&sc=1 [^]

(0011209) gorkaion (viewer) 2008-12-11 19:32	Steps to reproduce/verify: Create a new Manufacturing Plan in: Material Requirement Planning (MRP) \|\| Transactions \|\| Manufacturing Plan \|\| Header Create a line filling all the fields except the requisition line combo. In the transaction type select suggested material requirement. Go back to the header and click the 'Generate Material Requisitions' button to generate the requisition. check that the generated requisitionline has the proper C_UOM_ID

Issue History
Date Modified	Username	Field	Change
2008-11-14 21:43	slava_u	New Issue
2008-11-14 21:43	slava_u	Assigned To	=> rafaroda
2008-11-14 21:43	slava_u	sf_bug_id	0 => 2286207
2008-11-20 10:49	rafaroda	Note Added: 0010434
2008-11-20 10:49	rafaroda	Status	new => feedback
2008-11-24 11:59	rafaroda	Assigned To	rafaroda => gorkaion
2008-11-24 11:59	rafaroda	Note Added: 0010548
2008-12-03 19:03	pjuvara	Priority	normal => high
2008-12-11 19:27	svnbot	Checkin
2008-12-11 19:27	svnbot	Note Added: 0011208
2008-12-11 19:27	svnbot	Status	feedback => resolved
2008-12-11 19:27	svnbot	Resolution	open => fixed
2008-12-11 19:27	svnbot	svn_revision	=> 11130
2008-12-11 19:32	gorkaion	Note Added: 0011209
2009-04-21 11:07	psarobe	Status	resolved => closed

Copyright © 2000 - 2009 MantisBT Group