Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0008266

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

defect

[Openbravo ERP] 07. Sales management

major

always

2009-03-24 16:04

2009-06-09 00:00

Reporter

villind

View Status

public

Assigned To

gorkaion

Priority

high

Resolution

fixed

Fixed in Version

pi

Status

closed

Fix in branch

pi

Fixed in SCM revision

Projection

none

ETA

none

Target Version

OS

Any

Database

Any

Java version

OS Version

Database version

Ant version

Product Version

2.40MP3

SCM revision

Review Assigned To

Web browser

Modules

Core

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0008266: Function M_INOUT_CREATE (Create/Generate Shipments) delivers from locators where the quantity is negative

Description

Create Shipments happily delivers from the locators where the quantity is negative.

Proposed Solution

Don't deliver if the stock quantity is negative. See the attached patch.

Tags

r13959.diff [^] (673 bytes) 2009-03-24 16:04 [Show Content] [Hide Content]

Index: src-db/database/model/functions/M_INOUT_CREATE.xml
===================================================================
--- src-db/database/model/functions/M_INOUT_CREATE.xml	(revision 13958)
+++ src-db/database/model/functions/M_INOUT_CREATE.xml	(revision 13959)
@@ -107,7 +107,7 @@
       T.C_UOM_ID=p_UOM AND
       COALESCE(T.M_PRODUCT_UOM_ID, 0)=COALESCE(p_Product_UOM, 0) AND
       COALESCE(T.M_ATTRIBUTESETINSTANCE_ID, 0)=COALESCE(p_Attribute, COALESCE(T.M_ATTRIBUTESETINSTANCE_ID, 0)) AND
-      COALESCE(T.QtyOnHand, 0)<>0
+      COALESCE(T.QtyOnHand, 0)>0
     ORDER BY L.PRIORITYNO,
       T.M_ATTRIBUTESETINSTANCE_ID;
     v_storage Cur_Storage%ROWTYPE;

Relationships [ Relation Graph ] [ Dependency Graph ]

depends on	backport	0008352		closed	gorkaion	Function M_INOUT_CREATE (Create/Generate Shipments) delivers from locators where the quantity is negative
depends on	backport	0010842		closed	rafaroda	Function M_INOUT_CREATE (Create/Generate Shipments) delivers from locators where the quantity is negative
related to	defect	0008524		closed	rafaroda	Duplicate lines are added to sales invoice, when the user create's Sales order (POS) for a product which has negative inventory

Notes
(0016006) hgbot (developer) 2009-05-04 12:00	Repository: erp/devel/pi Changeset: afae9719930fe4dfb51aaffa9510e4ca6532e04c Author: Ainhoa Pagola <ainhoa.pagola <at> openbravo.com> Date: Mon May 04 11:59:44 2009 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/afae9719930fe4dfb51aaffa9510e4ca6532e04c [^] Fixes bug 8266: Function M_INOUT_CREATE delivers from locators where quantity is negative --- M src-db/database/model/functions/M_INOUT_CREATE.xml ---

(0017110) sureshbabu (reporter) 2009-06-08 16:58	Tested working fine

Issue History
Date Modified	Username	Field	Change
2009-03-24 16:04	villind	New Issue
2009-03-24 16:04	villind	Assigned To	=> rafaroda
2009-03-24 16:04	villind	File Added: r13959.diff
2009-03-24 16:04	villind	Regression testing	=> No
2009-03-24 16:08	villind	version	=> 2.40MP3
2009-03-24 16:11	rafaroda	Assigned To	rafaroda => gorkaion
2009-03-25 07:02	pjuvara	Priority	normal => high
2009-03-25 07:02	pjuvara	Severity	critical => major
2009-03-30 19:41	psarobe	Status	new => scheduled
2009-03-30 19:41	psarobe	fix_in_branch	=> pi
2009-04-23 16:05	psarobe	Tag Attached: 250MP1
2009-05-04 12:00	hgbot	Checkin
2009-05-04 12:00	hgbot	Note Added: 0016006
2009-05-04 12:00	hgbot	Status	scheduled => resolved
2009-05-04 12:00	hgbot	Resolution	open => fixed
2009-05-04 12:00	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/afae9719930fe4dfb51aaffa9510e4ca6532e04c [^]
2009-06-08 16:58	sureshbabu	Status	resolved => closed
2009-06-08 16:58	sureshbabu	Note Added: 0017110
2009-06-08 16:58	sureshbabu	Fixed in Version	2.50MP1 => pi
2009-06-09 00:00	anonymous	sf_bug_id	0 => 2803187
2009-10-01 13:30	rafaroda	Relationship added	related to 0008524
2009-10-02 14:32	rafaroda	Relationship added	depends on 0010842

Copyright © 2000 - 2009 MantisBT Group