Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023328Openbravo ERP09. Financial managementpublic2013-03-18 12:302013-03-21 11:58
Reporterdmiguelez 
Assigned Todmiguelez 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Topramakrishnan
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023328: Customer Statement Report
DescriptionCreate Customer Statement Report.

Description:
A Report that displays Accounting information of a Customer between two dates.

Specs:
  - When launching the Report, a Pop-Up will be shown to select the filters used for printing the Report.
  - The filters are:
    - Organization
    - General Ledger
    - Business Partner
    - Starting Date
    - Ending Date
  - The Report will show Accounting information for a particular Customer. The information will be retrieved from the Accounting records related to the Customer Accounts, which are Customer Receivables and Cusotmer Prepayments.
    - http://wiki.openbravo.com/wiki/Business_Partner#Customer_Accounting [^]
  - The Report will show information related to the Tables C_Invoice, FIN_Payment, FIN_Finacc_Transaction_ and FIN_Reconciliation.
  - The filters Starting Date and Ending Date are optional. If introduced, the information should be filtered accordingly.
  - Each line of the Report will show:
    - Date
    - Document Type
    - Description
    - Debit
    - Credit
    - Net
Steps To ReproduceCreate Customer Statement Report.

Description:
A Report that displays Accounting information of a Customer between two dates.

Specs:
  - When launching the Report, a Pop-Up will be shown to select the filters used for printing the Report.
  - The filters are:
    - Organization
    - General Ledger
    - Business Partner
    - Starting Date
    - Ending Date
  - The Report will show Accounting information for a particular Customer. The information will be retrieved from the Accounting records related to the Customer Accounts, which are Customer Receivables and Cusotmer Prepayments.
    - http://wiki.openbravo.com/wiki/Business_Partner#Customer_Accounting [^]
  - The Report will show information related to the Tables C_Invoice, FIN_Payment, FIN_Finacc_Transaction_ and FIN_Reconciliation.
  - The filters Starting Date and Ending Date are optional. If introduced, the information should be filtered accordingly.
  - Each line of the Report will show:
    - Date
    - Document Type
    - Description
    - Debit
    - Credit
    - Net
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-03-18 12:30dmiguelezNew Issue
2013-03-18 12:30dmiguelezAssigned To => dmiguelez
2013-03-18 12:30dmiguelezModules => Core
2013-03-18 12:30dmiguelezTriggers an Emergency Pack => No
2013-03-21 10:12hgbotCheckin
2013-03-21 10:12hgbotNote Added: 0057345
2013-03-21 10:12hgbotStatusnew => resolved
2013-03-21 10:12hgbotResolutionopen => fixed
2013-03-21 10:12hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f76c31b8b96bdffdea84524537558ec45bc6875b [^]
2013-03-21 10:52pramakrishnanReview Assigned To => pramakrishnan
2013-03-21 10:52pramakrishnanNote Added: 0057351
2013-03-21 10:52pramakrishnanStatusresolved => closed
2013-03-21 11:56hgbotCheckin
2013-03-21 11:56hgbotNote Added: 0057355
2013-03-21 11:58hgbotCheckin
2013-03-21 11:58hgbotNote Added: 0057356

Notes
(0057345)
hgbot   
2013-03-21 10:12   
Repository: erp/devel/pi
Changeset: f76c31b8b96bdffdea84524537558ec45bc6875b
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Thu Mar 21 10:09:14 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/f76c31b8b96bdffdea84524537558ec45bc6875b [^]

Fixes Issue 23328: Customer Statement Report.

---
M src-db/database/sourcedata/AD_MENU.xml
M src-db/database/sourcedata/AD_PROCESS.xml
M src-db/database/sourcedata/AD_PROCESS_PARA.xml
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src-db/database/sourcedata/AD_TREENODE.xml
M src-db/database/sourcedata/AD_VAL_RULE.xml
A src/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml
---
(0057351)
pramakrishnan   
2013-03-21 10:52   
Code Review + Testing - OK.
(0057355)
hgbot   
2013-03-21 11:56   
Repository: erp/devel/api-checks
Changeset: 7a1216e80eba651313c0edf7ffd1302176c916bf
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Thu Mar 21 11:56:32 2013 +0100
URL: http://code.openbravo.com/erp/devel/api-checks/rev/7a1216e80eba651313c0edf7ffd1302176c916bf [^]

Related to Issue 23328. Fixes false API-Checks positive.

---
M model/src-db/database/sourcedata/AD_PROCESS_PARA.xml
---
(0057356)
hgbot   
2013-03-21 11:58   
Repository: erp/devel/pi
Changeset: 0ac1f03d51d41f6d0b25724adf8e4047049d40b3
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Thu Mar 21 11:57:55 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/0ac1f03d51d41f6d0b25724adf8e4047049d40b3 [^]

Related to Issue 23328. Fixes DBConsistency.

---
M src-db/database/sourcedata/AD_PROCESS_PARA.xml
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
---