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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0010489
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementminoralways2009-09-04 11:222009-10-06 11:28
ReporternetworkbView Statuspublic 
Assigned Toharikrishnan 
PriorityhighResolutionfixedFixed in Version2.50MP6
StatusclosedFix in branchpiFixed in SCM revision338865a1d7f7
ProjectionnoneETAnoneTarget Version2.40MP11
OSLinux 64 bitDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product Version2.40MP8SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010489: 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)
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 00105132.40MP11 closedharikrishnan In the Sales invoice dimensional report the invoices with document type ar credit memo are not subtracted 
related to defect 0010636 closedharikrishnan In the Sales invoice reports the invoices with document type ''ar credit memo'' and are not subtracted 

-  Notes
(0019520)
rafaroda (developer)
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 (developer)
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 (reporter)
2009-09-17 10:01

Tested working in Sales invoice dimensional report
(0020473)
hgbot (developer)
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 (manager)
2009-10-06 11:27

Closed again because hudson has reopened without no reason

- Issue History
Date Modified Username Field Change
2009-09-04 11:22 networkb New Issue
2009-09-04 11:22 networkb Assigned To => rafaroda
2009-09-08 10:56 rafaroda Note Added: 0019520
2009-09-08 10:56 rafaroda Assigned To rafaroda => harikrishnan
2009-09-08 10:56 rafaroda Priority immediate => high
2009-09-08 10:56 rafaroda Description Updated
2009-09-08 10:56 rafaroda Proposed Solution updated
2009-09-08 10:56 rafaroda Steps to Reproduce Updated
2009-09-08 10:56 rafaroda Status new => scheduled
2009-09-08 10:56 rafaroda fix_in_branch => pi
2009-09-16 12:26 rafaroda Note Edited: 0019520
2009-09-16 15:08 hgbot Checkin
2009-09-16 15:08 hgbot Note Added: 0020114
2009-09-16 15:08 hgbot Status scheduled => resolved
2009-09-16 15:08 hgbot Resolution open => fixed
2009-09-16 15:08 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/338865a1d7f72ae6f0517f5d57bcc359ba2b51c5 [^]
2009-09-17 07:16 rafaroda Relationship added related to 0010636
2009-09-17 10:01 sureshbabu Status resolved => closed
2009-09-17 10:01 sureshbabu Note Added: 0020124
2009-09-17 10:01 sureshbabu Fixed in Version => 2.50MP6
2009-09-18 00:00 anonymous sf_bug_id 0 => 2861008
2009-09-29 14:12 hgbot Checkin
2009-09-29 14:12 hgbot Note Added: 0020473
2009-09-29 14:12 hgbot Status closed => resolved
2009-09-29 14:12 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/338865a1d7f72ae6f0517f5d57bcc359ba2b51c5 [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/338865a1d7f72ae6f0517f5d57bcc359ba2b51c5 [^]
2009-10-06 11:27 psarobe Status resolved => closed
2009-10-06 11:27 psarobe Note Added: 0020759


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker