Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031563Openbravo ERP04. Warehouse managementpublic2015-11-23 19:442015-12-02 00:10
ReporterVictorVillar 
Assigned ToAtulOpenbravo 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tovmromanos
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket39195
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0031563: BOM production report is not showing the whole information
DescriptionBOM production report is not showing the whole information
Steps To ReproduceAs group admin role,
  Go to Product window,
     define Bebida Energética as Bill of materials
    Navigate to Bill of material tab
       add: agua 1
   Verify BOm
  Go to Product window,
     define Cola de Cereza as Bill of material
    Navigate to Bill of material tab
       add: Vino 1
Verify BOM

Go to Bill of materials production
 create a new one for 20/11/2015
     Add: Bebida Energética
     qty: 20
 Create and process the production
 create a new one for 30/11/2015
     Add: Cola de cereza
     qty: 50
 Create and process the production

Go to BOM Production report.
  Launch the report between 01/11/2015 and 30/11/2015
 Realise that the information regarding Cola de cereza does not appear in the information consolidated.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-11-23 19:44VictorVillarNew Issue
2015-11-23 19:44VictorVillarAssigned To => Triage Finance
2015-11-23 19:44VictorVillarOBNetwork customer => Yes
2015-11-23 19:44VictorVillarModules => Core
2015-11-23 19:44VictorVillarSupport ticket => 39195
2015-11-23 19:44VictorVillarResolution time => 1450652400
2015-11-23 19:44VictorVillarTriggers an Emergency Pack => No
2015-11-30 15:49AtulOpenbravoAssigned ToTriage Finance => AtulOpenbravo
2015-11-30 15:53AtulOpenbravoStatusnew => scheduled
2015-11-30 15:53AtulOpenbravoNote Added: 0082471
2015-12-01 10:24hgbotCheckin
2015-12-01 10:24hgbotNote Added: 0082478
2015-12-01 10:24hgbotStatusscheduled => resolved
2015-12-01 10:24hgbotResolutionopen => fixed
2015-12-01 10:24hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f2e13b05a16cc6291c44428dc86eb73e3b41fa05 [^]
2015-12-01 10:24hgbotCheckin
2015-12-01 10:24hgbotNote Added: 0082479
2015-12-01 10:25vmromanosReview Assigned To => vmromanos
2015-12-01 10:25vmromanosNote Added: 0082480
2015-12-01 10:25vmromanosStatusresolved => closed
2015-12-02 00:10hudsonbotCheckin
2015-12-02 00:10hudsonbotNote Added: 0082508
2015-12-02 00:10hudsonbotCheckin
2015-12-02 00:10hudsonbotNote Added: 0082509

Notes
(0082471)
AtulOpenbravo   
2015-11-30 15:53   
Test Plan

- Login as group admin role,
- Go to Product window,
  - Define Bebida Energética as Bill of materials
  - Navigate to Bill of material tab
      - Add: Agua, Quantity = 1
  - Verify BOm

-Go to Product window,
  - Define Cola de Cereza as Bill of material
  - Navigate to Bill of material tab
      - Add: Vino, Quantity = 1
  - Verify BOM

- Go to Bill of materials production create a new one for 20/11/2015
    - Set Product: Bebida Energética, Qty: 20
    - Create and process the production

- Create a new one for 30/11/2015, Set Product:Cola de cereza, Quantity:50
    - Create and process the production

- Go to BOM Production report.
  - Launch the report between 01/11/2015 and 30/11/2015
  - Check that the information regarding both Bebida Energética & Cola de cereza appears in the consolidated information.
(0082478)
hgbot   
2015-12-01 10:24   
Repository: erp/devel/pi
Changeset: f2e13b05a16cc6291c44428dc86eb73e3b41fa05
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Mon Nov 30 17:55:31 2015 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/f2e13b05a16cc6291c44428dc86eb73e3b41fa05 [^]

Fixes Issue 31563:BOM production report is not showing the whole information

Where clause excluded the BOM record on To Date of report filter. Now it is
updated to consider such records.

---
M src/org/openbravo/erpCommon/ad_reports/productionSubReport.jrxml
---
(0082479)
hgbot   
2015-12-01 10:24   
Repository: erp/devel/pi
Changeset: d55b978161d6c89121598fc1b161ae4c91c9378b
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Tue Dec 01 10:16:54 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/d55b978161d6c89121598fc1b161ae4c91c9378b [^]

Related to issue 31563: code review improvements

Truncated MovementDate to be sure the <= and >= comparations work fine with the datetime field

---
M src/org/openbravo/erpCommon/ad_reports/productionSubReport.jrxml
---
(0082480)
vmromanos   
2015-12-01 10:25   
Code review + testing OK
(0082508)
hudsonbot   
2015-12-02 00:10   
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/a52bb700bbaf [^]
Maturity status: Test
(0082509)
hudsonbot   
2015-12-02 00:10   
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/a52bb700bbaf [^]
Maturity status: Test