Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0030061Openbravo ERPZ. Otherspublic2015-06-01 13:522015-06-08 11:09
Reportermaite 
Assigned ToAtulOpenbravo 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q3Fixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0030061: Customer Statement report is not considering all required tables
DescriptionReport 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
Steps To Reproduce1. 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

Proposed Solutionpatch attached
Additional Information
TagsNo tags attached.
Relationships
Attached Filesdiff 30061.diff (769) 2015-06-01 13:52
https://issues.openbravo.com/file_download.php?file_id=8146&type=bug
Issue History
Date ModifiedUsernameFieldChange
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:53maiteResolution time => 1436133600
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