Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020752Openbravo ERP04. Warehouse managementpublic2012-06-13 17:232012-06-27 05:29
Reporterdmiguelez 
Assigned Todmiguelez 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target VersionpiFixed in Version3.0MP13 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020752: Null C_UOM_ID when creating a BOM Production
DescriptionWhen creating a BOM Production, it returns an error message: "null value in column "c_uom_id" violates not-null constraint"
Steps To ReproduceLogin as Openbravo/openbravo

Go to product and create:
Product p11
 -Organization: F&B US, Inc.
 -Name:p11
 -stocked=Y
 -bill of materials:N
 -tab price: price list: general sales, net unit price=5, net list price=5
Product p12
 -Organization: F&B US, Inc.
 -Name:p12
 -stocked=Y
 -bill of materials:N
 -tab price: price list: general sales, net unit price=6, net list price=6
Product p1
 -Organization: F&B US, Inc.
 -Name:p1
 -stocked=N
 -bill of materials:y
 -tab price: price list: general sales, net unit price=0, net list price=0
 -tab Bill of matenials
   -bom product:p11, active:yes
   -bom product:p12, active:no
 -Click Verify BOM
Product p2
 -Organization: F&B US, Inc.
 -Name:p2
 -stocked=Y
 -bill of materials:N
 -tab price: price list: general sales, net unit price=1.5, net list price=1.5
Product p
 -Organization: F&B US, Inc.
 -Name:p
 -stocked=Y
 -bill of materials:y
 -tab price: price list: general sales, net unit price=0, net list price=0
 -tab Bill of matenials
   -bom product:p1, active: yes
   -bom product:p2, active: yes
 -Click Verify BOM

Go to Bill of Materials Production.
Create a new record:
"Organization": F&B US
"Name": BoMPT
Move to Production Plan tab and create a new record:
"Product": p
"Production Quantity": 10
"Storage Bin": WC-1-0-0

Click on "Create/Process Production" and OK

A message would appear:
"null value in column "c_uom_id" violates not-null constraint"
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-06-13 17:23dmiguelezNew Issue
2012-06-13 17:23dmiguelezAssigned To => dmiguelez
2012-06-13 17:23dmiguelezModules => Core
2012-06-13 17:23dmiguelezOBNetwork customer => No
2012-06-13 17:24dmiguelezStatusnew => acknowledged
2012-06-13 17:24dmiguelezStatusacknowledged => scheduled
2012-06-13 17:24dmiguelezfix_in_branch => pi
2012-06-13 17:25dmiguelezNote Added: 0049818
2012-06-22 08:46hgbotCheckin
2012-06-22 08:46hgbotNote Added: 0050002
2012-06-22 08:46hgbotStatusscheduled => resolved
2012-06-22 08:46hgbotResolutionopen => fixed
2012-06-22 08:46hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a5a731ef968c40f8dc3297b1c9a1cddea3b5b0d0 [^]
2012-06-22 08:48miruritaNote Added: 0050005
2012-06-22 08:48miruritaStatusresolved => closed
2012-06-22 08:48miruritaFixed in Version => 3.0MP13
2012-06-27 05:29hudsonbotCheckin
2012-06-27 05:29hudsonbotNote Added: 0050152

Notes
(0049818)
dmiguelez   
2012-06-13 17:25   
Test Plan:

Login as Openbravo/openbravo

Go to product and create:
Product p11
 -Organization: F&B US, Inc.
 -Name:p11
 -stocked=Y
 -bill of materials:N
 -tab price: price list: general sales, net unit price=5, net list price=5
Product p12
 -Organization: F&B US, Inc.
 -Name:p12
 -stocked=Y
 -bill of materials:N
 -tab price: price list: general sales, net unit price=6, net list price=6
Product p1
 -Organization: F&B US, Inc.
 -Name:p1
 -stocked=N
 -bill of materials:y
 -tab price: price list: general sales, net unit price=0, net list price=0
 -tab Bill of matenials
   -bom product:p11, active:yes
   -bom product:p12, active:no
 -Click Verify BOM
Product p2
 -Organization: F&B US, Inc.
 -Name:p2
 -stocked=Y
 -bill of materials:N
 -tab price: price list: general sales, net unit price=1.5, net list price=1.5
Product p
 -Organization: F&B US, Inc.
 -Name:p
 -stocked=Y
 -bill of materials:y
 -tab price: price list: general sales, net unit price=0, net list price=0
 -tab Bill of matenials
   -bom product:p1, active: yes
   -bom product:p2, active: yes
 -Click Verify BOM

Go to Bill of Materials Production.
Create a new record:
"Organization": F&B US
"Name": BoMPT
Move to Production Plan tab and create a new record:
"Product": p
"Production Quantity": 10
"Storage Bin": WC-1-0-0

Click on "Create/Process Production" and OK
A success message would appear.
Click again and another message of success would appear again.
(0050002)
hgbot   
2012-06-22 08:46   
Repository: erp/devel/pi
Changeset: a5a731ef968c40f8dc3297b1c9a1cddea3b5b0d0
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Wed Jun 13 17:31:33 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a5a731ef968c40f8dc3297b1c9a1cddea3b5b0d0 [^]

Fixes issue 20752: Inserts C_UOM_ID so it's no longer null.

---
M src-db/database/model/functions/M_PRODUCTION_RUN.xml
---
(0050005)
mirurita   
2012-06-22 08:48   
code review + testing OK
(0050152)
hudsonbot   
2012-06-27 05:29   
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/cf3a7135839f [^]

Maturity status: Test