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

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 07. Sales managementmajorhave not tried2011-03-28 12:562011-04-13 12:46
ReporterAinhoaPagolaView Statuspublic 
Assigned ToAinhoaPagola 
PriorityurgentResolutionfixedFixed in Version2.50MP29
StatusclosedFix in branch2.50Fixed in SCM revision1d7dfcf437a7
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.5
OS VersionUbuntu 8.4Database version8.3Ant version1.7
Product VersionSCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0016645: Error when creating shipments with negative quantities for products with negative stock

DescriptionA "null value in column "c_uom_id" violates not-null constraint" error is displayed when a POS sales order with two lines with a negative amount of a product without stock is completed.
Steps To Reproduce- Create a product and check as stocked. Link it to a pricelist
- Make sure the client allows negative stock
- Create a POS sales order with one line and a positive amount of the product. The product will have a negative amount on stock. Complete the order. The shipment and invoice will be created.
- Create a POS sales order with two lines. Both of them with negative amounts of the product. Complete the order. The error will be thrown because the shipment can not be created.
Proposed SolutionThe problem may be related to the Cursor Cur_Storage in the function m_inout_create.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0016512 closedAinhoaPagola Error when creating shipments with negative quantities for products with negative stock 

-  Notes
hgbot (developer)
2011-04-08 15:19

Repository: erp/stable/2.50
Changeset: 1d7dfcf437a782253f3c7357555ae9a8fa6d646b
Author: Ainhoa Pagola <ainhoa.pagola <at>>
Date: Wed Apr 06 17:22:43 2011 +0200
URL: [^]

Fixes bug 16645. Error creating shipments with negative quantites

M src-db/database/model/functions/M_INOUT_CREATE.xml
maite (developer)
2011-04-13 12:46

Verified that situation reported is not reproducible any more.
As change affects to M_INOUT_CREATE procedure have also been tested that:
* POS order with more than one positive line, one positive and another negative, only one line... works fine.
* Same for Warehouse Order, as it also creates shipment
* Process Generate Receipt from Invoice has also been tested as it calls to M_INOUT_CREATE procedure

- Issue History
Date Modified Username Field Change
2011-04-05 13:11 AinhoaPagola Type defect => backport
2011-04-05 13:11 AinhoaPagola fix_in_branch => 2.50
2011-04-08 15:19 hgbot Checkin
2011-04-08 15:19 hgbot Note Added: 0035787
2011-04-08 15:19 hgbot Status scheduled => resolved
2011-04-08 15:19 hgbot Resolution open => fixed
2011-04-08 15:19 hgbot Fixed in SCM revision => [^]
2011-04-13 12:46 maite Note Added: 0035900
2011-04-13 12:46 maite Status resolved => closed
2011-04-13 12:46 maite Fixed in Version => 2.50MP29

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker