Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010513Openbravo ERP07. Sales managementpublic2009-09-04 11:222009-10-12 08:40
Reporternetworkb 
Assigned Toharikrishnan 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS Version
Product Version2.40MP8 
Target Version2.40MP11Fixed in Version2.40MP10 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010513: 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
related to backport 0010637 closed harikrishnan In the Sales invoice reports the invoices with document type ''ar credit memo'' and are not subtracted 
blocks defect 00104892.40MP11 closed harikrishnan In the Sales invoice dimensional report the invoices with document type ar credit memo are not subtracted 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-09-08 10:56rafarodaTypedefect => backport
2009-09-08 10:56rafarodafix_in_branch => 2.40
2009-09-16 15:00hgbotCheckin
2009-09-16 15:00hgbotNote Added: 0020112
2009-09-16 15:00hgbotStatusscheduled => resolved
2009-09-16 15:00hgbotResolutionopen => fixed
2009-09-16 15:00hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/128a88189f81896dbd5bd848445fd2577ef75a30 [^]
2009-09-17 07:16rafarodaRelationship addedrelated to 0010637
2009-09-29 12:02hgbotCheckin
2009-09-29 12:02hgbotNote Added: 0020439
2009-09-29 12:02hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/128a88189f81896dbd5bd848445fd2577ef75a30 [^] => http://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/128a88189f81896dbd5bd848445fd2577ef75a30 [^]
2009-10-12 08:40sureshbabuStatusresolved => closed
2009-10-12 08:40sureshbabuNote Added: 0020931
2009-10-12 08:40sureshbabuFixed in Version => 2.40MP10

Notes
(0020112)
hgbot   
2009-09-16 15:00   
Repository: erp/stable/2.40
Changeset: 128a88189f81896dbd5bd848445fd2577ef75a30
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Wed Sep 16 18:28:31 2009 +0530
URL: http://code.openbravo.com/erp/stable/2.40/rev/128a88189f81896dbd5bd848445fd2577ef75a30 [^]

Issue Fixes 10513: 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
---
(0020439)
hgbot   
2009-09-29 12:02   
Repository: erp/stable/2.40_pageddatagrid
Changeset: 128a88189f81896dbd5bd848445fd2577ef75a30
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Wed Sep 16 18:28:31 2009 +0530
URL: http://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/128a88189f81896dbd5bd848445fd2577ef75a30 [^]

Issue Fixes 10513: 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
---
(0020931)
sureshbabu   
2009-10-12 08:40   
tested working fine