Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0020752
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2012-06-13 17:232012-06-27 05:29
ReporterdmiguelezView Statuspublic 
Assigned Todmiguelez 
PrioritynormalResolutionfixedFixed in Version3.0MP13
StatusclosedFix in branchpiFixed in SCM revisiona5a731ef968c
ProjectionnoneETAnoneTarget Versionpi
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
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
Summary

0020752: 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"
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0049818)
dmiguelez (viewer)
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 (developer)
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 (viewer)
2012-06-22 08:48

 code review + testing OK
(0050152)
hudsonbot (viewer)
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

- Issue History
Date Modified Username Field Change
2012-06-13 17:23 dmiguelez New Issue
2012-06-13 17:23 dmiguelez Assigned To => dmiguelez
2012-06-13 17:23 dmiguelez Modules => Core
2012-06-13 17:23 dmiguelez OBNetwork customer => No
2012-06-13 17:24 dmiguelez Status new => acknowledged
2012-06-13 17:24 dmiguelez Status acknowledged => scheduled
2012-06-13 17:24 dmiguelez fix_in_branch => pi
2012-06-13 17:25 dmiguelez Note Added: 0049818
2012-06-22 08:46 hgbot Checkin
2012-06-22 08:46 hgbot Note Added: 0050002
2012-06-22 08:46 hgbot Status scheduled => resolved
2012-06-22 08:46 hgbot Resolution open => fixed
2012-06-22 08:46 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a5a731ef968c40f8dc3297b1c9a1cddea3b5b0d0 [^]
2012-06-22 08:48 mirurita Note Added: 0050005
2012-06-22 08:48 mirurita Status resolved => closed
2012-06-22 08:48 mirurita Fixed in Version => 3.0MP13
2012-06-27 05:29 hudsonbot Checkin
2012-06-27 05:29 hudsonbot Note Added: 0050152

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker