Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0030061Openbravo ERPZ. Otherspublic2015-06-01 13:522015-06-08 11:09
maite 
AtulOpenbravo 
urgentmajoralways
closedfixed 
5
 
3.0PR15Q3 
dmiguelez
Core
No
0030061: Customer Statement report is not considering all required tables
Report is only considering Sales Invoices, Payment In, Financial Transactions and Reconciliations tables, when some other tables such as GL Journal, Remittance and so on needs to be considered in order to obtain proper customer balance
1. Register Sales Invoice for any customer. Process and Post
2. Register Remittance, include previous invoice in remittance. Process and Post
3. Run Customer Statement report for this customer and organization and realize that balance is not zero

patch attached
No tags attached.
diff 30061.diff (769) 2015-06-01 13:52
https://issues.openbravo.com/file_download.php?file_id=8146&type=bug
Issue History
2015-06-01 13:52maiteNew Issue
2015-06-01 13:52maiteAssigned To => Triage Finance
2015-06-01 13:52maiteModules => Core
2015-06-01 13:52maiteTriggers an Emergency Pack => No
2015-06-01 13:52maiteFile Added: 30061.diff
2015-06-01 13:53maiteTarget Version => 3.0PR15Q3
2015-06-01 17:47maiteTypedesign defect => defect
2015-06-05 11:41AtulOpenbravoAssigned ToTriage Finance => AtulOpenbravo
2015-06-05 11:46AtulOpenbravoStatusnew => scheduled
2015-06-08 04:54hgbotCheckin
2015-06-08 04:54hgbotNote Added: 0078139
2015-06-08 04:54hgbotStatusscheduled => resolved
2015-06-08 04:54hgbotResolutionopen => fixed
2015-06-08 04:54hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8acbd2d2afa51ef1c8f6808a29d1c21fda0c35e1 [^]
2015-06-08 04:57AtulOpenbravoNote Added: 0078140
2015-06-08 10:57dmiguelezReview Assigned To => dmiguelez
2015-06-08 10:57dmiguelezNote Added: 0078142
2015-06-08 10:57dmiguelezStatusresolved => closed
2015-06-08 11:09hudsonbotCheckin
2015-06-08 11:09hudsonbotNote Added: 0078144

Notes
(0078139)
hgbot   
2015-06-08 04:54   
Repository: erp/devel/pi
Changeset: 8acbd2d2afa51ef1c8f6808a29d1c21fda0c35e1
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Sun Jun 07 21:27:32 2015 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/8acbd2d2afa51ef1c8f6808a29d1c21fda0c35e1 [^]

Fixes Issue 30061:Customer Statement report is not considering all required
tables

All tables are considered now except C_Period which is not needed here.

---
M src/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml
---
(0078140)
AtulOpenbravo   
2015-06-08 04:57   
Test Plan
- Register Sales Invoice for any customer. Process and Post.
- Register Remittance, include previous invoice in remittance. Process and Post.
- Run Customer Statement report for this customer and organization and realize that balance is zero.
(0078142)
dmiguelez   
2015-06-08 10:57   
Code Review + Testing Ok
(0078144)
hudsonbot   
2015-06-08 11:09   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/129a8588e600 [^]
Maturity status: Test