Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0014992Openbravo ERP09. Financial managementpublic2010-10-22 13:422010-12-21 00:00
networkb 
dalsasua 
urgentmajoralways
closedfixed 
20Community Appliance
2.40MP16 
2.50MP25 
Core
No
0014992: PDF format in general ledger journal does not group by date
In PDF format, the general ledger journal does not group by date, but in html format it is done
. Financial Management || Receivables & Payables || Transactions || Bank Statement || Header
 new record

. Financial Management || Receivables & Payables || Transactions || Bank Statement || Lines
  new line:
   line 10: create payment
            effective date and accounting date 10/10/2010
   line 20: create payment
            effective date and accounting date 11/10/2010

process and post
 html 2 journals separated by date
 pdf 1 journal
       
No tags attached.
depends on backport 00152652.50MP25 closed dalsasua PDF format in general ledger journal does not group by date 
pdf sample.pdf (1,782) 2010-10-22 13:42
https://issues.openbravo.com/file_download.php?file_id=3269&type=bug
png Pantallazo.png (217,357) 2010-10-22 13:43
https://issues.openbravo.com/file_download.php?file_id=3270&type=bug
png
Issue History
2010-10-22 13:42networkbNew Issue
2010-10-22 13:42networkbAssigned To => dalsasua
2010-10-22 13:42networkbFile Added: sample.pdf
2010-10-22 13:43networkbFile Added: Pantallazo.png
2010-10-22 13:46networkbversion => 2.40MP16
2010-11-17 17:48dalsasuaAssigned Todalsasua => adrianromero
2010-11-17 18:07adrianromeroAssigned Toadrianromero => dalsasua
2010-11-19 12:05adrianromeroTarget Version => 2.50MP25
2010-11-23 11:18dalsasuaStatusnew => scheduled
2010-11-23 11:18dalsasuaNote Added: 0032785
2010-11-23 11:18dalsasuafix_in_branch => pi
2010-11-23 12:33hgbotCheckin
2010-11-23 12:33hgbotNote Added: 0032786
2010-11-23 12:33hgbotStatusscheduled => resolved
2010-11-23 12:33hgbotResolutionopen => fixed
2010-11-23 12:33hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/45126bfbff2800f389b6b5c371b6c122c8f897ea [^]
2010-11-30 17:51hudsonbotCheckin
2010-11-30 17:51hudsonbotNote Added: 0032934
2010-12-20 12:16psarobeNote Added: 0033285
2010-12-20 12:16psarobeStatusresolved => closed
2010-12-21 00:00anonymoussf_bug_id0 => 3140998

Notes
(0032785)
dalsasua   
2010-11-23 11:18   
Issue is not in Journal report, but in DocBank servlet. When posting a bank statement, if the lines do not have all the same accounting date, it should assign a new FactAcctGroupId, so different entries are created. One only entry cannot have different dates for it's lines.
Proposed solution is to:
1- Sort the lines by accounting date
2- Each time the date of a bank statement lines is different from the one in the previous line, assign a new FactAcctGroupID
(0032786)
hgbot   
2010-11-23 12:33   
Repository: erp/devel/pi
Changeset: 45126bfbff2800f389b6b5c371b6c122c8f897ea
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Tue Nov 23 12:32:53 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/45126bfbff2800f389b6b5c371b6c122c8f897ea [^]

Fixes issue 14992: PDF format in general ledger journal does not group by date
Issue is not in Journal report, but in DocBank servlet. When posting a bank statement, if the lines do not have all the same accounting date, it should assign a new FactAcctGroupId, so different entries are created. One only entry cannot have different dates for it's lines.
Solution is to:
1- Sort the lines by accounting date
2- Each time the date of a bank statement lines is different from the one in the previous line, assign a new FactAcctGroupID

---
M src/org/openbravo/erpCommon/ad_forms/DocBank.java
M src/org/openbravo/erpCommon/ad_forms/DocLineBank_data.xsql
---
(0032934)
hudsonbot   
2010-11-30 17:51   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/45126bfbff28 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/7c27b4b566df [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.19017.obx [^]
(0033285)
psarobe   
2010-12-20 12:16   
Tested working fine