Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023389Openbravo ERP05. Production managementpublic2013-03-25 18:312013-04-07 01:03
Reportercaristu 
Assigned Tojonalegriaesarte 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelProduction - QA Approved
Regression date
Regression introduced in release
Regression introduced by commit http://code.openbravo.com/erp/devel/pi/rev/9cc2d186f5adfc50cbb3c22501524e195b357938 [^]
Triggers an Emergency PackNo
Summary0023389: Sales invoice dimensional Report returns a division by zero error under some circumstaces
DescriptionIf we have some invoices which their transaction cost associated have not been calculated and also one of that invoices has an invoice line which includes a product that is defined as non-stockable and also its type is not "Item", then if we execute the Sales invoice dimensional report for a period that includes those invoices, the report crashes.
Steps To Reproduce1) Unschedule the costing background process
2) Create a new goods shipment and create a new sales invoice related.
3) Create a new goods shipment and a new sales invoice related to it for the same date and for the same business partner. This invoice must have a line with a product marked as non-stockable and type different from Item
4) Run the Sales invoice dimensional Report for the date of the invoices.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-03-25 18:31caristuNew Issue
2013-03-25 18:31caristuAssigned To => dmiguelez
2013-03-25 18:31caristuModules => Core
2013-03-25 18:31caristuTriggers an Emergency Pack => No
2013-03-25 18:34caristuRegression level => Production - QA Approved
2013-03-25 18:34caristuRegression introduced by commit => http://code.openbravo.com/erp/devel/pi/rev/9cc2d186f5adfc50cbb3c22501524e195b357938 [^]
2013-03-26 18:30caristuIssue Monitored: networkb
2013-03-27 13:15caristuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=4541#r4541
2013-03-27 17:39dmiguelezAssigned Todmiguelez => jonalegriaesarte
2013-04-02 18:33hgbotCheckin
2013-04-02 18:33hgbotNote Added: 0057571
2013-04-02 18:33hgbotStatusnew => resolved
2013-04-02 18:33hgbotResolutionopen => fixed
2013-04-02 18:33hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/b212efecbee133f9875b3bc57f27ffce5f866861 [^]
2013-04-02 19:42caristuReview Assigned To => caristu
2013-04-02 19:42caristuNote Added: 0057572
2013-04-02 19:42caristuStatusresolved => closed
2013-04-07 01:03hudsonbotCheckin
2013-04-07 01:03hudsonbotNote Added: 0057757

Notes
(0057571)
hgbot   
2013-04-02 18:33   
Repository: erp/devel/pi
Changeset: b212efecbee133f9875b3bc57f27ffce5f866861
Author: Naiara Garcia <naiara.garcia <at> openbravo.com>
Date: Tue Apr 02 18:33:05 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/b212efecbee133f9875b3bc57f27ffce5f866861 [^]

Fixed issue 23389: Sales invoice dimensional Report returns a division by zero
 error under some circumstaces

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
---
(0057572)
caristu   
2013-04-02 19:42   
Verified
(0057757)
hudsonbot   
2013-04-07 01:03   
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/b03a336bd23b [^]

Maturity status: Test