Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0015899 | Openbravo ERP | 09. Financial management | public | 2011-02-09 13:41 | 2011-04-01 18:39 |
|
| Reporter | jonalegriaesarte | |
| Assigned To | dalsasua | |
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | 2.50MP26 | |
| Target Version | 2.50MP27 | Fixed in Version | 2.50MP28 | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0015899: The general ledger journal should show an "Add and keep going..." a "Total" and a "Previous Sums" sections |
| Description | The 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 Solution | The 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..
|
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | related to | defect | 0016426 | | closed | naiaramartinez | General Ledger Journal and Trial Balance report use different terms to refer the same concept | | blocks | defect | 0015932 | | closed | dalsasua | The general ledger journal should show an "Add and keep going..." a "Total" and a "Previous Sums" sections |
|
| Attached Files | |
|
| 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 |
|
Notes |
|
|
|
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.
|
|
|
|
|
|
Which is the scope of the fix? Just PDF output (printing), or also HTML (shown in display). |
|
|
|
|
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 |
|
|
|
|
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. |
|
|
|
|
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. |
|
|
|
|
David,
OK, clear, thanks. |
|
|
|
|
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. |
|
|
|
|
Please implement this as a generic solution.
The requirement is not specific to Spain. |
|
|
|
(0034514)
|
|
hgbot
|
|
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
---
|
|
|
|
|
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. |
|
|
|
|
|
|
|
|
Guys,
What about my comment? |
|