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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0015899
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementmajoralways2011-02-09 13:412011-04-01 18:39
ReporterjonalegriaesarteView Statuspublic 
Assigned Todalsasua 
PriorityurgentResolutionfixedFixed in Version2.50MP28
StatusclosedFix in branchFixed in SCM revision631470a72993
ProjectionnoneETAnoneTarget Version2.50MP27
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP26SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015899: The general ledger journal should show an "Add and keep going..." a "Total" and a "Previous Sums" sections

DescriptionThe general ledger journal should show a "Add and keep going..." section at the end of each page and a total section at the end of the report that show the total debit amount and the total credit amount.
At the beginning of each report or page it should show total amount of the previous report or page.
Steps To Reproduce- Financial Management || Accounting || Analysis Tools || General Ledger Journal

Note that these sections do not appear.
Proposed SolutionThe General Ledger jounarl must be changed as described below:

(1) There should be a "Sumas Anteriores" section ("Previous sums") at the application path: "Financial Management || Accounting || Analysis Tools || General Ledger Report || General Ledger Report" where end-user can enter below information:
1.1 the "Previous Debit Sum" amount
1.2 the "Previous Credit Sum" amount
coming from the previously launched General Ledger Report (by example January- 2011 General Ledger Report).
Those amounts must be taken into account in the new General Ledger Report (by example February - 2011 General Ledger Report), in order to keep adding and going.
Therefore these previous sum amounts must be shown only at the begining of the page 1 of the new report.

(2) At the end of each page of the General Ledger Report, there should be an "Add and Keep going.." section, for both the "Debit" and the "Credit" columns, named "Add and keep going". The system will show in that line the total debit amount and the total credit amounts for the current page + the previous sum amounts (see point 1)

Therefore these amounts must be shown first at the end of the page 1 of the new report and so on..

(3) At the begining of each page of the General Ledger Report, there should be an "Accumulated Amounts" section, for both the "Debit" and the "Credti" columns.
The system will show in that line the total debit amount and the total credit amount coming from the previous page.

Therefore these accumulated amounts must be shown first at the begining of the page 2 of the new report and so on..




TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0016426 closednaiaramartinez General Ledger Journal and Trial Balance report use different terms to refer the same concept 
blocks defect 0015932 closeddalsasua The general ledger journal should show an "Add and keep going..." a "Total" and a "Previous Sums" sections 

-  Notes
(0034124)
psanjuan (manager)
2011-02-10 09:44

As described by the end-customer:

4) Sumas Anteriores, debe dar posibilidad (como en el ejemplo adjunto, que es la primera página del segundo libro de diario de 2009) a incorporar el total de sumas de debe y haber del libro anterior, para continuar sumando los importes de debe y haber de los asientos del nuevo libro.

5) Suma y sigue, al final de cada página y al final del listado tiene que presentar la suma de debe y haber y en el caso de libros sucesivos al primero, como se explica en el punto anterior, iniciar la suma en el importe de sumas anteriores.
(0034131)
dalsasua (reporter)
2011-02-10 12:58

Which is the scope of the fix? Just PDF output (printing), or also HTML (shown in display).
(0034132)
psanjuan (manager)
2011-02-10 15:41

Please take into account both:
pdf format
and xls format
as both of them can be printed.

there is no need for the html format
(0034187)
dmitry_mezentsev (developer)
2011-02-14 18:49

Hi All,

Legal requirements we received from Spain. Are they valid (helpful) for rest of the countries cause our report in core should be generic? If not we should not be changing core but think about doing some localization.
(0034188)
dalsasua (reporter)
2011-02-14 19:02

Hi Dmitry,

Yes, I already raised that topic, and we agreed that this can be useful worldwide, but in order not to change current behavior, old report will also be kept: user will be able to show/hide this fields.

In any case, Spanish localization can set the default value to show, and core to not to show. The only way to have this report modified in the Spanish localization would be duplicating code.

Regards.
(0034191)
dmitry_mezentsev (developer)
2011-02-14 19:54

David,

OK, clear, thanks.
(0034198)
psanjuan (manager)
2011-02-15 13:27

These requirements are coming form the Spanish market/law
This issue can be approached as a Spanish General Ledger Journal localization.
We are now in the process of taking a final solution.
(0034234)
rmorley (reporter)
2011-02-16 15:40

Please implement this as a generic solution.
The requirement is not specific to Spain.
(0034514)
hgbot (developer)
2011-03-03 04:55

Repository: erp/stable/2.50
Changeset: 631470a72993b26089e08e8b957664c7cbc3f240
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Tue Feb 22 16:34:54 2011 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/631470a72993b26089e08e8b957664c7cbc3f240 [^]

Fixes issue 15899. Fixes issue 15911. Fixes issue 15920. Fixes issue 16017.
Several changes done to Report General Ledger Journal:
- Show Regularization / Opening / Closing checks now works in this way: if, and only if, the check is active, the corresponding entry type will be shown.
- Show Regular Entries check is added. This way, user can choose what entry types to include (checkbox active) or exclude (not-active checkbox) in the report output. By default, all the types will be shown
- ONLY WHEN PRINTING TO PDF, an initial entry number can be set. This way, entries will be numbered starting with the provided number.
- ONLY WHEN PRINTING TO PDF, the accumulated amounts for debit and credit is calculated and shown.
- ONLY WHEN PRINTING TO PDF, an initial debit and credit amount can be provided, and will be used as initial value of debit and credit accumulated amounts.
- ONLY WHEN PRINTING TO PDF, user can choose whether to show the subaccount description in each entry line (as of now), or the entry line description. PLEASE NOTICE THAT USER WILL SET THE DESIRED SQL DESCRIPTION IN THE CORRESPONDING TABLES, UNDER ACCOUNTING SCHEMA TAB, IN ORDER TO AVOID DUPLICATED LINES IN THE ENTRIES.
- Trial Balance Report is modified in order to make coherent both terms for corry forward amounts

---
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.html
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.java
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.xml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal_data.xsql
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.html
---
(0034538)
dmitry_mezentsev (developer)
2011-03-03 18:15

Hello David,

As discussed could you please register for the future unification issue (linked to this one) to move similar changes to the HTML (to make all outputs of this report consistent)?


Thanks.
(0035274)
jonalegriaesarte (reporter)
2011-03-28 16:20

Verified
(0035483)
dmitry_mezentsev (developer)
2011-04-01 18:39

Guys,

What about my comment?

- Issue History
Date Modified Username Field Change
2011-02-09 13:41 jonalegriaesarte New Issue
2011-02-09 13:41 jonalegriaesarte Assigned To => adrianromero
2011-02-09 13:41 jonalegriaesarte Modules => Core
2011-02-09 13:41 jonalegriaesarte Issue Monitored: networkb
2011-02-10 09:44 psanjuan Note Added: 0034124
2011-02-10 09:44 psanjuan Proposed Solution updated
2011-02-10 10:13 psanjuan Summary The general ledger journal should show an "Add and keep going..." section and a "Total" section => The general ledger journal should show an "Add and keep going..." a "Total" and a "Previous Sums" sections
2011-02-10 10:13 psanjuan Proposed Solution updated
2011-02-10 12:58 dalsasua Note Added: 0034131
2011-02-10 12:58 dalsasua Assigned To adrianromero => jonalegriaesarte
2011-02-10 12:58 dalsasua Status new => feedback
2011-02-10 15:41 psanjuan Note Added: 0034132
2011-02-10 15:41 psanjuan Status feedback => new
2011-02-10 16:23 adrianromero Status new => scheduled
2011-02-10 16:23 adrianromero Assigned To jonalegriaesarte => dalsasua
2011-02-10 16:23 adrianromero fix_in_branch => pi
2011-02-10 16:23 adrianromero Type defect => backport
2011-02-10 16:23 adrianromero fix_in_branch pi =>
2011-02-10 16:24 adrianromero Issue cloned 0015932
2011-02-10 16:24 adrianromero Relationship added blocks 0015932
2011-02-14 18:49 dmitry_mezentsev Note Added: 0034187
2011-02-14 19:02 dalsasua Note Added: 0034188
2011-02-14 19:54 dmitry_mezentsev Note Added: 0034191
2011-02-15 13:27 psanjuan Note Added: 0034198
2011-02-16 15:40 rmorley Note Added: 0034234
2011-03-03 04:55 hgbot Checkin
2011-03-03 04:55 hgbot Note Added: 0034514
2011-03-03 04:55 hgbot Status scheduled => resolved
2011-03-03 04:55 hgbot Resolution open => fixed
2011-03-03 04:55 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/631470a72993b26089e08e8b957664c7cbc3f240 [^]
2011-03-03 18:15 dmitry_mezentsev Note Added: 0034538
2011-03-28 16:20 jonalegriaesarte Note Added: 0035274
2011-03-28 16:20 jonalegriaesarte Status resolved => closed
2011-03-28 16:20 jonalegriaesarte Fixed in Version => 2.50MP28
2011-04-01 18:39 dmitry_mezentsev Note Added: 0035483
2011-04-04 08:52 dalsasua Relationship added related to 0016426


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker