Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0023328
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] 09. Financial managementmajoralways2013-03-18 12:302013-03-21 11:58
ReporterdmiguelezView Statuspublic 
Assigned Todmiguelez 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionf76c31b8b96b
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
Merge Request Status
Review Assigned Topramakrishnan
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0023328: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0057345)
hgbot (developer)
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 (viewer)
2013-03-21 10:52

 Code Review + Testing - OK.
(0057355)
hgbot (developer)
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 (developer)
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
---

- Issue History
Date Modified Username Field Change
2013-03-18 12:30 dmiguelez New Issue
2013-03-18 12:30 dmiguelez Assigned To => dmiguelez
2013-03-18 12:30 dmiguelez Modules => Core
2013-03-18 12:30 dmiguelez OBNetwork customer => No
2013-03-18 12:30 dmiguelez Triggers an Emergency Pack => No
2013-03-21 10:12 hgbot Checkin
2013-03-21 10:12 hgbot Note Added: 0057345
2013-03-21 10:12 hgbot Status new => resolved
2013-03-21 10:12 hgbot Resolution open => fixed
2013-03-21 10:12 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f76c31b8b96bdffdea84524537558ec45bc6875b [^]
2013-03-21 10:52 pramakrishnan Review Assigned To => pramakrishnan
2013-03-21 10:52 pramakrishnan Note Added: 0057351
2013-03-21 10:52 pramakrishnan Status resolved => closed
2013-03-21 11:56 hgbot Checkin
2013-03-21 11:56 hgbot Note Added: 0057355
2013-03-21 11:58 hgbot Checkin
2013-03-21 11:58 hgbot Note Added: 0057356

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker