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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0022763
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 05. Production managementmajoralways2013-01-10 11:152013-03-05 13:29
ReporterVictorVillarView Statuspublic 
Assigned Tongarcia 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision9cc2d186f5ad
ProjectionnoneETAnoneTarget Version3.0MP21
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Merge Request Status
Review Assigned ToVictorVillar
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket18563
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0022763: Wrong calculation of Cost value on Sales invoice dimensional Report

DescriptionWrong calculation of Cost value on Sales invoice dimensional Report.
When there are invoices for a product which their cost has not been calculated and they have different lines net amounts, the cost is calculated in a proportional manner from transactions with cost, and the formula used is:

SUM(CONVCOST)*SUM(CONVAMOUNT)/SUM(COSTEDAMT) END AS CONVCOST

Now the COSTEDAMT is calculated by the sum of all the line net amount for the invoices (transactions) which their cost has been calculated by the costing engine, but should be the sum of all the lines net amount of all the invoices.
On the subquery ZZ, it is possible to check it
Steps To ReproduceAs group admin role,

Create two orders/shipments/invoices, for one product, with different line net amount. These transactions will have cost. Date: Today

create three invoices without shipments associated, and different lines net amount. one invoice --> Date: today, the other two --> DAte: two days before

Now it is possible to check on subquery ZZ of the ReportInvoiceCustomerDimensionalAnalysesJRData.java
that the COSTEDAMT value is not correct, should be the sum of all the lines net amount of all the invoices grouped in this moment.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00227563.0MP21 closedioritzCia Wrong behaviour in the sales invoice dimensional report 

-  Notes
(0056652)
hgbot (developer)
2013-02-20 18:39

 Repository: erp/devel/pi
Changeset: 9cc2d186f5adfc50cbb3c22501524e195b357938
Author: Naiara Garcia <naiara.garcia <at> openbravo.com>
Date: Wed Feb 20 12:40:11 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/9cc2d186f5adfc50cbb3c22501524e195b357938 [^]

Fixed issue 22763: Wrong calculation of Cost value on Sales invoice dimensional
 Report

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR.java
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
---
(0056700)
hudsonbot (viewer)
2013-02-21 17:48

 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/2add4de9509d [^]

Maturity status: Test
(0057047)
VictorVillar (viewer)
2013-03-05 13:29

 Veririfed

- Issue History
Date Modified Username Field Change
2013-01-10 11:15 VictorVillar New Issue
2013-01-10 11:15 VictorVillar Assigned To => dmiguelez
2013-01-10 11:15 VictorVillar Modules => Core
2013-01-10 11:15 VictorVillar OBNetwork customer => Yes
2013-01-10 11:15 VictorVillar Support ticket => 18563
2013-01-10 11:15 VictorVillar Resolution time => 1359846000
2013-01-10 11:15 VictorVillar Triggers an Emergency Pack => No
2013-01-10 11:16 VictorVillar Issue Monitored: networkb
2013-01-10 18:42 jonalegriaesarte Assigned To dmiguelez => ngarcia
2013-02-04 16:52 jonalegriaesarte Target Version 3.0MP20 => 3.0MP21
2013-02-20 18:39 hgbot Checkin
2013-02-20 18:39 hgbot Note Added: 0056652
2013-02-20 18:39 hgbot Status new => resolved
2013-02-20 18:39 hgbot Resolution open => fixed
2013-02-20 18:39 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/9cc2d186f5adfc50cbb3c22501524e195b357938 [^]
2013-02-21 17:48 hudsonbot Checkin
2013-02-21 17:48 hudsonbot Note Added: 0056700
2013-03-01 13:21 ioritzCia Relationship added related to 0022756
2013-03-05 13:29 VictorVillar Review Assigned To => VictorVillar
2013-03-05 13:29 VictorVillar Note Added: 0057047
2013-03-05 13:29 VictorVillar Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker