Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0024010

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

defect

[Openbravo ERP] 03. Procurement management

major

have not tried

2013-06-06 12:59

2013-06-20 02:07

Reporter

jonalegriaesarte

View Status

public

Assigned To

dmiguelez

Priority

immediate

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

OS Version

Database version

Ant version

Product Version

3.0MP21

SCM revision

Review Assigned To

pramakrishnan

Web browser

Modules

Core

Regression level

Production - Confirmed Stable

Regression date

2013-02-27

Regression introduced in release

Regression introduced by commit

https://code.openbravo.com/erp/devel/pi/rev/2e4dccb63f7d [^]

Triggers an Emergency Pack

No

Summary

0024010: Generate receipt from invoices fails

Description

Generate receipt from invoices fails, because of the changeset related to bom-non stocked functionality, pushed here:
https://code.openbravo.com/erp/devel/pi/rev/2e4dccb63f7d [^]

Steps To Reproduce

- As System administrator display the button generate receipt from invoice in purchase invoice window
- Create a new purchase invoice with one line. Book it
- Generate receipt from invoices fails

Proposed Solution

Attached a possible patch

Tags

No tags attached.

inoutcreate.diff [^] (1,426 bytes) 2013-06-06 12:59 [Show Content] [Hide Content]

diff --git a/src-db/database/model/functions/M_INOUT_CREATE.xml b/src-db/database/model/functions/M_INOUT_CREATE.xml
--- a/src-db/database/model/functions/M_INOUT_CREATE.xml
+++ b/src-db/database/model/functions/M_INOUT_CREATE.xml
@@ -894,10 +894,10 @@
             Cur_Lines.QuantityOrder, Cur_Lines.M_Product_Uom_ID, Cur_Lines.M_ATTRIBUTESETINSTANCE_ID,
             coalesce(Cur_Lines.C_Project_ID, Cur_Invoice.C_Project_ID), coalesce(Cur_Lines.A_Asset_ID, Cur_Invoice.A_Asset_ID), 
             coalesce(Cur_Lines.C_CostCenter_ID, Cur_Invoice.C_CostCenter_ID), coalesce(Cur_Lines.User1_ID, Cur_Invoice.User1_ID),
-            coalesce(Cur_Lines.User2_ID, Cur_Invoice.User2_ID), ol.explode, (select m_inoutline_id 
-                                     from m_inoutline 
-                                     where m_inout_id = p_InOut_ID
-                                       and c_orderline_id = (SELECT BOM_parent_id from c_orderline WHERE c_orderline_id = ol.C_OrderLine_ID)));
+            coalesce(Cur_Lines.User2_ID, Cur_Invoice.User2_ID), Cur_Lines.explode, (select m_inoutline_id 
+                                     from c_invoiceline
+                                     where c_invoice_id = Cur_Lines.C_Invoice_ID
+                                       and c_invoiceline_id = Cur_Lines.BOM_parent_id));
           UPDATE C_INVOICELINE
           SET M_INOUTLINE_ID=v_NextNo,
               Updated=now(),

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0059274) hgbot (developer) 2013-06-07 12:31	Repository: erp/devel/pi Changeset: b26d7d7c6a2c5147700c483d3a1ddc9011313937 Author: Sandra Huguet <sandra.huguet <at> openbravo.com> Date: Fri Jun 07 12:31:18 2013 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/b26d7d7c6a2c5147700c483d3a1ddc9011313937 [^] Fixed bug 24010 Generate receipt from invoices fails --- M src-db/database/model/functions/M_INOUT_CREATE.xml ---

(0059330) pramakrishnan (developer) 2013-06-11 12:32	Code Review + Testing - OK.

(0059555) hudsonbot (developer) 2013-06-20 02:07	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/5caf871044ad [^] Maturity status: Test

Issue History
Date Modified	Username	Field	Change
2013-06-06 12:59	jonalegriaesarte	New Issue
2013-06-06 12:59	jonalegriaesarte	Assigned To	=> dmiguelez
2013-06-06 12:59	jonalegriaesarte	File Added: inoutcreate.diff
2013-06-06 12:59	jonalegriaesarte	Modules	=> Core
2013-06-06 12:59	jonalegriaesarte	Triggers an Emergency Pack	=> No
2013-06-06 13:00	jonalegriaesarte	Regression level	=> Production - Confirmed Stable
2013-06-06 13:00	jonalegriaesarte	Regression date	=> 2013-02-27
2013-06-06 13:00	jonalegriaesarte	Regression introduced by commit	=> https://code.openbravo.com/erp/devel/pi/rev/2e4dccb63f7d [^]
2013-06-07 12:31	hgbot	Checkin
2013-06-07 12:31	hgbot	Note Added: 0059274
2013-06-07 12:31	hgbot	Status	new => resolved
2013-06-07 12:31	hgbot	Resolution	open => fixed
2013-06-07 12:31	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/b26d7d7c6a2c5147700c483d3a1ddc9011313937 [^]
2013-06-11 12:32	pramakrishnan	Review Assigned To	=> pramakrishnan
2013-06-11 12:32	pramakrishnan	Note Added: 0059330
2013-06-11 12:32	pramakrishnan	Status	resolved => closed
2013-06-20 02:07	hudsonbot	Checkin
2013-06-20 02:07	hudsonbot	Note Added: 0059555

Copyright © 2000 - 2009 MantisBT Group