Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010637Openbravo ERP07. Sales managementpublic2009-09-17 07:112009-10-12 09:17
Reporterharikrishnan 
Assigned Toharikrishnan 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version2.40MP10 
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
Summary0010637: In the Sales invoice reports the invoices with document type ''ar credit memo'' and are not subtracted
DescriptionSales Management:
In the Sales invoice reports 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.

Procurement Management:

The same thing is happening for the Purchase invoice with document type "AP Credit Memo".The amount of the "Ap Credit Memo" invoices have to be subtracted because this documents are used to cancel the invoices.

These are the places where needed to be corrected.

* Procurement Management || Analysis Tools || Purchase Invoice Dimensional Report
* Procurement Management || Analysis Tools || Vendor Invoice Report
Steps To ReproduceSales Management

Create an sales invoice as "Ar credit memo" with lines.
-complete and post it. see that the accounting is different that in the standard invoices. this document works as a return.
-Go to Sales Management || Analysis Tools || Customer Invoice Report || Customer Invoice Report
select the conditions to show the new invoice
and see that the amount is not subtracted.

Some other reports are also to be corrected.
* Sales Management || Analysis Tools || Discount Invoice Report
* Sales Management || Analysis Tools || Invoiced Sales Order Report


Procurement management :

Create an Purchase invoice as "Ap credit memo" with lines.
-complete and post it. see that the accounting is different that in the standard invoices. this document works as a return.
-Go to Procurement Management || Analysis Tools || Purchase Invoice Dimensional Report || Purchase Invoice Dimensional Report
select the conditions to show the new invoice
and see that the amount is not subtracted.

Some other reports are also to be corrected.
* Procurement Management || Analysis Tools || Vendor Invoice Report || Vendor Invoice Report
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to backport 00105132.40MP11 closed harikrishnan In the Sales invoice dimensional report the invoices with document type ar credit memo are not subtracted 
blocks 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-17 07:16rafarodaTypedefect => backport
2009-09-17 07:16rafarodafix_in_branch => 2.40
2009-09-17 07:16rafarodaRelationship addedrelated to 0010513
2009-09-22 08:41hgbotCheckin
2009-09-22 08:41hgbotNote Added: 0020251
2009-09-22 08:41hgbotStatusscheduled => resolved
2009-09-22 08:41hgbotResolutionopen => fixed
2009-09-22 08:41hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/658e7bf2c4ce5dcc2ac3d3ea4bcc8d8791dcf6fe [^]
2009-09-29 12:02hgbotCheckin
2009-09-29 12:02hgbotNote Added: 0020442
2009-09-29 12:02hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/658e7bf2c4ce5dcc2ac3d3ea4bcc8d8791dcf6fe [^] => http://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/658e7bf2c4ce5dcc2ac3d3ea4bcc8d8791dcf6fe [^]
2009-10-12 09:17arunkumarStatusresolved => closed
2009-10-12 09:17arunkumarNote Added: 0020936
2009-10-12 09:17arunkumarFixed in Version => 2.40MP10

Notes
(0020251)
hgbot   
2009-09-22 08:41   
Repository: erp/stable/2.40
Changeset: 658e7bf2c4ce5dcc2ac3d3ea4bcc8d8791dcf6fe
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Tue Sep 22 12:09:48 2009 +0530
URL: http://code.openbravo.com/erp/stable/2.40/rev/658e7bf2c4ce5dcc2ac3d3ea4bcc8d8791dcf6fe [^]

Issue Fixes 10637: In the Sales invoice reports the invoices with document type ''ar credit memo'' and are not subtracted

---
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src/org/openbravo/erpCommon/ad_reports/InvoiceCustomerEdition_data.xsql
M src/org/openbravo/erpCommon/ad_reports/InvoiceEdition_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscount_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesJR_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoiced_data.xsql
---
(0020442)
hgbot   
2009-09-29 12:02   
Repository: erp/stable/2.40_pageddatagrid
Changeset: 658e7bf2c4ce5dcc2ac3d3ea4bcc8d8791dcf6fe
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Tue Sep 22 12:09:48 2009 +0530
URL: http://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/658e7bf2c4ce5dcc2ac3d3ea4bcc8d8791dcf6fe [^]

Issue Fixes 10637: In the Sales invoice reports the invoices with document type ''ar credit memo'' and are not subtracted

---
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src/org/openbravo/erpCommon/ad_reports/InvoiceCustomerEdition_data.xsql
M src/org/openbravo/erpCommon/ad_reports/InvoiceEdition_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscount_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesJR_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoiced_data.xsql
---
(0020936)
arunkumar   
2009-10-12 09:17   
Tested & Working Fine