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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0007901
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 02. Master data managementminorhave not tried2009-03-02 18:102012-06-13 17:29
ReportershuehnerView Statuspublic 
Assigned ToSandrahuguet 
PrioritylowResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision8bb97e60e1d0
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40MP2SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0007901: isactive is ignored for table m_product_bom (Bill of Materials tab in Product window)

DescriptionThe code for i.e. calculated Quantity on hand or prices for products which have a bill of materials does not check the isactive flag.

So deactivating of BOM entries seems not possible without deleting an entry.
Steps To ReproduceCheck the code of i.e. one of the following functions:

BOM_PRICELIMIT, BOM_PRICELIST, ...

to see that the iteration of the BOM is done without respecting the isactive flag of the m_product_bom table.
TagsClean-up, OB3-Reviewed
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to design defect 0007902 acknowledgedmirurita Check that isactive is used when it exists in a table 

-  Notes
(0048571)
Sandrahuguet (developer)
2012-05-11 09:50
edited on: 2012-05-11 10:18

 Test Plan:
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=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:p1, active: yes
   -bom product:p2, active: yes
 -Click Verify BOM

Go to sales invoice and create one
 -Organization: F&B US, Inc.
 -Business partner: Healthy Food Supermarkets, Co.
 -Payment Terms: 30 days
 -Payment Method: Wire Transfer
 -Line tab: product=p, net unit price=0, line net amout=0
 -Click complete
 -Notice that you can only see active bill of material products in sales invoice lines.
(0049819)
dmiguelez (developer)
2012-06-13 17:27

 Code Review + Testing OK
(0049820)
hgbot (developer)
2012-06-13 17:28

 Repository: erp/devel/pi
Changeset: 8bb97e60e1d0e799505ae26893b906488b636db5
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Fri May 11 09:25:47 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/8bb97e60e1d0e799505ae26893b906488b636db5 [^]

Fixed bug 7901 Add flag isactive=Y when used m_product_bom table

---
M src-db/database/model/functions/C_INVOICE_POST.xml
M src-db/database/model/functions/C_ORDER_POST1.xml
M src-db/database/model/functions/M_BOM_PRICELIMIT.xml
M src-db/database/model/functions/M_BOM_PRICELIST.xml
M src-db/database/model/functions/M_BOM_PRICESTD.xml
M src-db/database/model/functions/M_BOM_QTY_ONHAND.xml
M src-db/database/model/functions/M_BOM_QTY_ORDERED.xml
M src-db/database/model/functions/M_BOM_QTY_RESERVED.xml
M src-db/database/model/functions/M_PRODUCTION_RUN.xml
M src-db/database/model/functions/M_PRODUCT_BOM_CHECK.xml
---

- Issue History
Date Modified Username Field Change
2009-03-02 18:10 shuehner New Issue
2009-03-02 18:10 shuehner Assigned To => rafaroda
2009-03-02 18:10 shuehner Regression testing => No
2009-03-02 18:13 shuehner Relationship added related to 0007902
2009-03-04 08:43 rafaroda Tag Attached: Clean-up
2009-03-04 08:44 rafaroda Assigned To rafaroda => shuehner
2009-03-04 08:44 rafaroda Priority normal => low
2009-03-04 08:44 rafaroda Status new => acknowledged
2009-03-04 08:44 rafaroda Assigned To shuehner => gorkaion
2011-11-25 10:20 gorkaion Tag Attached: OB3-Reviewed
2012-05-10 12:05 Sandrahuguet Status acknowledged => scheduled
2012-05-10 12:05 Sandrahuguet Assigned To gorkaion => Sandrahuguet
2012-05-10 12:05 Sandrahuguet fix_in_branch => pi
2012-05-11 09:50 Sandrahuguet Note Added: 0048571
2012-05-11 10:09 Sandrahuguet Note Edited: 0048571 View Revisions
2012-05-11 10:18 Sandrahuguet Note Edited: 0048571 View Revisions
2012-06-13 17:27 dmiguelez Note Added: 0049819
2012-06-13 17:28 hgbot Checkin
2012-06-13 17:28 hgbot Note Added: 0049820
2012-06-13 17:28 hgbot Status scheduled => resolved
2012-06-13 17:28 hgbot Resolution open => fixed
2012-06-13 17:28 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8bb97e60e1d0e799505ae26893b906488b636db5 [^]
2012-06-13 17:29 dmiguelez Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker