Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0010636Openbravo ERP07. Sales managementpublic2009-09-17 07:112009-10-06 11:51
harikrishnan 
harikrishnan 
urgentmajoralways
closedfixed 
5
2.40 
2.50MP6 
Core
No
0010636: In the Sales invoice reports the invoices with document type ''ar credit memo'' and are not subtracted
Sales 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
Sales 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
No tags attached.
related to defect 00104892.40MP11 closed harikrishnan In the Sales invoice dimensional report the invoices with document type ar credit memo are not subtracted 
depends on backport 0010637 closed harikrishnan In the Sales invoice reports the invoices with document type ''ar credit memo'' and are not subtracted 
Issue History
2009-09-17 07:11harikrishnanNew Issue
2009-09-17 07:11harikrishnanAssigned To => rafaroda
2009-09-17 07:12harikrishnanDescription Updated
2009-09-17 07:12harikrishnanProposed Solution updated
2009-09-17 07:16rafarodaAssigned Torafaroda => harikrishnan
2009-09-17 07:16rafarodaPrioritynormal => urgent
2009-09-17 07:16rafarodaversion => 2.40
2009-09-17 07:16rafarodaStatusnew => scheduled
2009-09-17 07:16rafarodafix_in_branch => pi
2009-09-17 07:16rafarodaRelationship addedrelated to 0010489
2009-09-22 09:14hgbotCheckin
2009-09-22 09:14hgbotNote Added: 0020252
2009-09-22 09:14hgbotStatusscheduled => resolved
2009-09-22 09:14hgbotResolutionopen => fixed
2009-09-22 09:14hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f99d3ab60d7db503ecbf8b0c455cfdf834074100 [^]
2009-09-22 13:21psarobeStatusresolved => closed
2009-09-22 13:21psarobeNote Added: 0020270
2009-09-22 13:21psarobeFixed in Version => 2.50MP6
2009-09-23 00:00anonymoussf_bug_id0 => 2864618
2009-09-29 14:14hgbotCheckin
2009-09-29 14:14hgbotNote Added: 0020492
2009-09-29 14:14hgbotStatusclosed => resolved
2009-09-29 14:14hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/f99d3ab60d7db503ecbf8b0c455cfdf834074100 [^] => http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/f99d3ab60d7db503ecbf8b0c455cfdf834074100 [^]
2009-10-06 11:51psarobeStatusresolved => closed
2009-10-06 11:51psarobeNote Added: 0020771

Notes
(0020252)
hgbot   
2009-09-22 09:14   
Repository: erp/devel/pi
Changeset: f99d3ab60d7db503ecbf8b0c455cfdf834074100
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Tue Sep 22 12:42:56 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/f99d3ab60d7db503ecbf8b0c455cfdf834074100 [^]

Issue Fixes 10636: 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
---
(0020270)
psarobe   
2009-09-22 13:21   
Tested working fine
(0020492)
hgbot   
2009-09-29 14:14   
Repository: erp/devel/pi-pageddatagrid
Changeset: f99d3ab60d7db503ecbf8b0c455cfdf834074100
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Tue Sep 22 12:42:56 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi-pageddatagrid/rev/f99d3ab60d7db503ecbf8b0c455cfdf834074100 [^]

Issue Fixes 10636: 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
---
(0020771)
psarobe   
2009-10-06 11:51   
Closed again because hudson has reopened without no reason