Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018209Openbravo ERP09. Financial managementpublic2011-08-04 22:002011-08-23 14:56
Reporterjaime_chamorro 
Assigned Togorkaion 
PriorityhighSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version2.50MP31 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browserMozilla Firefox
ModulesAdvanced Payables and Receivables Mngmt
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0018209: The Tab Accounting in Financial Account do not summarize posting by bank accounting account.
DescriptionThe tab accounting in the financial account does no summarize by bank accounting account when there is an split into the bank statement line. As you can check in the picture attached the bank accounting account (57200005) is showed in two lines instead of just one as the bank statement line imported through “cuaderno 43”.

This is a mandatory request for Tanzania client.
Steps To ReproduceTo reproduce the bug just split a bank statement line imported in two or more different amounts.
Proposed SolutionFollowing the example attached the tab must be shown this way:
Value Name Debit Credit
57200005 La Caixa 0 45299,72
41000 Acreedores por prestaciones de servicios (euros) 24388,36 0
41000 Acreedores por prestaciones de servicios (euros) 10917,36 0
41000 Acreedores por prestaciones de servicios (euros) 4130 0
41000 Acreedores por prestaciones de servicios (euros) 5664 0
62600 Servicios bancarios y similares 200 0
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0018071 scheduled mirurita It is required to improve the performance of the tab "Accounting" of the Financial Account window by using filters 
Attached Files? Accounting tab.bmp (695,014) 2011-08-04 22:00
https://issues.openbravo.com/file_download.php?file_id=4421&type=bug
png AccountingView.png (91,393) 2011-08-11 09:01
https://issues.openbravo.com/file_download.php?file_id=4437&type=bug
png

png BankStatement.png (54,030) 2011-08-11 09:01
https://issues.openbravo.com/file_download.php?file_id=4438&type=bug
png

png Posting.png (36,828) 2011-08-11 09:01
https://issues.openbravo.com/file_download.php?file_id=4439&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2011-08-04 22:00jaime_chamorroNew Issue
2011-08-04 22:00jaime_chamorroAssigned To => jonalegriaesarte
2011-08-04 22:00jaime_chamorroFile Added: Accounting tab.bmp
2011-08-04 22:00jaime_chamorroWeb browser => Mozilla Firefox
2011-08-04 22:00jaime_chamorroModules => Advanced Payables and Receivables Mngmt
2011-08-04 23:12jonalegriaesarteAssigned Tojonalegriaesarte => gorkaion
2011-08-11 09:00miruritaNote Added: 0040098
2011-08-11 09:00miruritaStatusnew => feedback
2011-08-11 09:01miruritaFile Added: AccountingView.png
2011-08-11 09:01miruritaFile Added: BankStatement.png
2011-08-11 09:01miruritaFile Added: Posting.png
2011-08-18 14:13psanjuanNote Added: 0040315
2011-08-23 14:55psanjuanNote Added: 0040448
2011-08-23 14:55psanjuanRelationship addedrelated to 0018071
2011-08-23 14:56psanjuanNote Edited: 0040448bug_revision_view_page.php?bugnote_id=0040448#r2596
2011-08-23 14:56psanjuanWeb browserMozilla Firefox => Mozilla Firefox
2011-08-23 14:56psanjuanStatusfeedback => new
2011-08-23 14:56psanjuanTypedefect => feature request

Notes
(0040098)
mirurita   
2011-08-11 09:00   
IMHO the accounting view should not group:
-Assume a line is split in two and one is matched against a GL Item and the other against a Bank Fee (see attached screenshot AccountingView.png). In this case you don't want to group because each line provides valuable information (Name, Description...) that are different.
- if you go to imported bank statement lines you will see split lines (see attached BankStatement.png). To be consistent both views (bank statement lines and accounting view) should display the same information.

Furthermore, accounting engine will treat split lines as standard lines, ie, if they have the same date they will be grouped in the same accounting entry (see attached screenshot Posting.png).
(0040315)
psanjuan   
2011-08-18 14:13   
This is not a defect as the accounting window is not supposed to group transaction postings anyhow, but just to show each transaction posting.
We believe it is not worth to add more complexity in the Accounting tab because that it will impact performance. This one is just a view. Accounting info should be inquiried
in accounting windows/reports such as the general ledger report.
End-user is just complaining about 572000XX account but what about the others?
(0040448)
psanjuan   
2011-08-23 14:55   
(edited on: 2011-08-23 14:56)
once discussed with the end-customer they need to get a summarize account entry just for 572XXX account by each bank statement line. We are going to handle this as a feature request.

this feature request is going to have a direct impact on performace that's why this entry is linked to entry 18071