Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024595Openbravo ERP07. Sales managementpublic2013-08-27 12:122013-09-30 14:01
ReporterVictorVillar 
Assigned Tocaristu 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP28Fixed in Version 
Merge Request Status
Review Assigned ToVictorVillar
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket22142
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0024595: Sales Invoice Dimensional Report shows wrong cost value under some circunstancies
DescriptionSales Invoice Dimensional Report shows wrong cost value under some circunstancies
Steps To ReproduceAs group Admin role,
Create 3 different Goods shipments for the same Business Partner(Alimentos) and the same Product (Cerveza Ale), Qty: 1 per each. Date: today
Create the 3 Sales invoices related to them.

Create one Goods Shipment more, for the same Business Partner(Alimentos) and the same Product (Cerveza Ale), Qty: -1. Date today
Create the Sales invoice related to it.

Launch the Costing background process, realise that the transactions of the Cerveza Ale have been calculated.

Launch the Sales invoice Dimensional Report for today, group by product.
Realise that the qty is 2, it is correct, but the Cost showed up is the sum of all the transaction cost (4), but it should be only for two, because one transaction cost is negative which voids one of the other. (attached the report)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00274613.0PR15Q1 closed vmromanos The cost on the Sales invoice Dimensional Report should be different for Credit Memo invoices 
Attached Filespdf ReportInvoiceCustomerDimensionalAnalysesNoComparativeJR.jrxml.pdf (2,365) 2013-08-27 12:12
https://issues.openbravo.com/file_download.php?file_id=6344&type=bug
Issue History
Date ModifiedUsernameFieldChange
2013-08-27 12:12VictorVillarNew Issue
2013-08-27 12:12VictorVillarAssigned To => dmiguelez
2013-08-27 12:12VictorVillarFile Added: ReportInvoiceCustomerDimensionalAnalysesNoComparativeJR.jrxml.pdf
2013-08-27 12:12VictorVillarModules => Core
2013-08-27 12:12VictorVillarOBNetwork customer => Yes
2013-08-27 12:12VictorVillarSupport ticket => 22142
2013-08-27 12:12VictorVillarResolution time => 1381874400
2013-08-27 12:12VictorVillarTriggers an Emergency Pack => No
2013-08-27 12:12VictorVillarIssue Monitored: networkb
2013-08-28 13:56dmiguelezAssigned Todmiguelez => jonalegriaesarte
2013-09-04 09:49jonalegriaesarteAssigned Tojonalegriaesarte => caristu
2013-09-18 10:20caristuStatusnew => scheduled
2013-09-18 10:20caristufix_in_branch => pi
2013-09-26 18:47ngarciaNote Added: 0061430
2013-09-26 18:47ngarciaIssue Monitored: ngarcia
2013-09-27 09:08hgbotCheckin
2013-09-27 09:08hgbotNote Added: 0061437
2013-09-27 09:09hgbotStatusscheduled => resolved
2013-09-27 09:09hgbotResolutionopen => fixed
2013-09-27 09:09hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/39c319cf63625c88e142ab579aad305e934c715a [^]
2013-09-27 22:28hudsonbotCheckin
2013-09-27 22:28hudsonbotNote Added: 0061454
2013-09-30 14:01VictorVillarReview Assigned To => VictorVillar
2013-09-30 14:01VictorVillarNote Added: 0061485
2013-09-30 14:01VictorVillarStatusresolved => closed
2014-08-25 14:24VictorVillarRelationship addedrelated to 0027461

Notes
(0061430)
ngarcia   
2013-09-26 18:47   
The cost of an invoice line with negative quantity should be negative
(0061437)
hgbot   
2013-09-27 09:08   
Repository: erp/devel/pi
Changeset: 39c319cf63625c88e142ab579aad305e934c715a
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Fri Sep 27 09:08:02 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/39c319cf63625c88e142ab579aad305e934c715a [^]

fixes issue 24595: Sales Invoice Dimensional Report shows wrong cost value
 under some circunstancies

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
---
(0061454)
hudsonbot   
2013-09-27 22:28   
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/d3e738d010f4 [^]

Maturity status: Test
(0061485)
VictorVillar   
2013-09-30 14:01   
Verified