Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010489Openbravo ERP07. Sales managementpublic2009-09-04 11:222009-10-06 11:28
Reporternetworkb 
Assigned Toharikrishnan 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS Version
Product Version2.40MP8 
Target Version2.40MP11Fixed in Version2.50MP6 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010489: In the Sales invoice dimensional report the invoices with document type ar credit memo are not subtracted
DescriptionIn the Sales invoice dimensional report the invoices with document type ar credit memo are not subtracted. The amount of the ar credit memo invoices have to be subtracted because this documents are used to cancel the invoices.
The ar credit memo invoices are posted with negative amount if they have a positive amount so the report should have into account this functionality and work in the same way.
Steps To Reproduce-Create an invoice as credit memo with lines.
-complete and post it. see that the accounting is different that in the standar invoices. this document works as a return.
-Go to Sales Management || Analysis Tools || Sales Invoice Dimensional Report || Sales Invoice Dimensional Report
select the conditions to show the new invoice
and see that the amount is not subtracted.
Proposed SolutionTake the QUANTITIES for AR Credit Memo invoice lines as negatives (AMOUNT = QUANTITY X PRICE)
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00105132.40MP11 closed harikrishnan In the Sales invoice dimensional report the invoices with document type ar credit memo are not subtracted 
related to defect 0010636 closed harikrishnan In the Sales invoice reports the invoices with document type ''ar credit memo'' and are not subtracted 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-09-04 11:22networkbNew Issue
2009-09-04 11:22networkbAssigned To => rafaroda
2009-09-08 10:56rafarodaNote Added: 0019520
2009-09-08 10:56rafarodaAssigned Torafaroda => harikrishnan
2009-09-08 10:56rafarodaPriorityimmediate => high
2009-09-08 10:56rafarodaDescription Updated
2009-09-08 10:56rafarodaProposed Solution updated
2009-09-08 10:56rafarodaSteps to Reproduce Updated
2009-09-08 10:56rafarodaStatusnew => scheduled
2009-09-08 10:56rafarodafix_in_branch => pi
2009-09-16 12:26rafarodaNote Edited: 0019520
2009-09-16 15:08hgbotCheckin
2009-09-16 15:08hgbotNote Added: 0020114
2009-09-16 15:08hgbotStatusscheduled => resolved
2009-09-16 15:08hgbotResolutionopen => fixed
2009-09-16 15:08hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/338865a1d7f72ae6f0517f5d57bcc359ba2b51c5 [^]
2009-09-17 07:16rafarodaRelationship addedrelated to 0010636
2009-09-17 10:01sureshbabuStatusresolved => closed
2009-09-17 10:01sureshbabuNote Added: 0020124
2009-09-17 10:01sureshbabuFixed in Version => 2.50MP6
2009-09-18 00:00anonymoussf_bug_id0 => 2861008
2009-09-29 14:12hgbotCheckin
2009-09-29 14:12hgbotNote Added: 0020473
2009-09-29 14:12hgbotStatusclosed => resolved
2009-09-29 14:12hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/338865a1d7f72ae6f0517f5d57bcc359ba2b51c5 [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/338865a1d7f72ae6f0517f5d57bcc359ba2b51c5 [^]
2009-10-06 11:27psarobeStatusresolved => closed
2009-10-06 11:27psarobeNote Added: 0020759

Notes
(0019520)
rafaroda   
2009-09-08 10:56   
(edited on: 2009-09-16 12:26)
This happens also in other Sales Invoice reports. Please log a different issue for:
* Sales Management || Analysis Tools || Customer Invoice Report
* Sales Management || Analysis Tools || Discount Invoice Report
* Sales Management || Analysis Tools || Invoiced Sales Order Report
* Procurement Management || Analysis Tools || Purchase Invoice Dimensional Report
* Procurement Management || Analysis Tools || Vendor Invoice Report

Follow the example of Sales Management || Analysis Tools || Invoice Detail which is doing it properly.
(0020114)
hgbot   
2009-09-16 15:08   
Repository: erp/devel/pi
Changeset: 338865a1d7f72ae6f0517f5d57bcc359ba2b51c5
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Wed Sep 16 18:37:31 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/338865a1d7f72ae6f0517f5d57bcc359ba2b51c5 [^]

Issue Fixes 10489: In the Sales invoice dimensional report the invoices with document type ar credit memo are not subtracted

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
---
(0020124)
sureshbabu   
2009-09-17 10:01   
Tested working in Sales invoice dimensional report
(0020473)
hgbot   
2009-09-29 14:12   
Repository: erp/devel/pi-pageddatagrid
Changeset: 338865a1d7f72ae6f0517f5d57bcc359ba2b51c5
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Wed Sep 16 18:37:31 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/338865a1d7f72ae6f0517f5d57bcc359ba2b51c5 [^]

Issue Fixes 10489: In the Sales invoice dimensional report the invoices with document type ar credit memo are not subtracted

---
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql
---
(0020759)
psarobe   
2009-10-06 11:27   
Closed again because hudson has reopened without no reason