Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015932Openbravo ERP09. Financial managementpublic2011-02-10 16:242011-05-10 15:46
Reporteradrianromero 
Assigned Todalsasua 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0015932: 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..




Additional Information
TagsNo tags attached.
Relationships
depends on backport 00158992.50MP27 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 ModifiedUsernameFieldChange
2011-02-10 16:24adrianromeroNew Issue
2011-02-10 16:24adrianromeroAssigned To => dalsasua
2011-02-10 16:24adrianromeroModules => Core
2011-02-10 16:24adrianromeroOBNetwork customer => Yes
2011-02-10 16:24adrianromeroIssue generated from0015899
2011-02-10 16:24adrianromeroRelationship addeddepends on 0015899
2011-02-10 16:24adrianromeroStatusnew => scheduled
2011-02-10 16:24adrianromerofix_in_branch => pi
2011-03-04 12:19hgbotCheckin
2011-03-04 12:19hgbotNote Added: 0034551
2011-03-04 12:19hgbotStatusscheduled => resolved
2011-03-04 12:19hgbotResolutionopen => fixed
2011-03-04 12:19hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c849db4f722d6b3be857f053a3aebaf839ebc4f5 [^]
2011-05-10 15:46psanjuanNote Added: 0036633
2011-05-10 15:46psanjuanStatusresolved => closed
2011-05-10 15:46psanjuanfix_in_branchpi =>

Notes
(0034551)
hgbot   
2011-03-04 12:19   
Repository: erp/devel/pi
Changeset: c849db4f722d6b3be857f053a3aebaf839ebc4f5
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Fri Mar 04 12:17:03 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/c849db4f722d6b3be857f053a3aebaf839ebc4f5 [^]

Fixes issue 15932. Fixes issue 15933. Fixes issue 15934. Fixes issue 15840.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
---
(0036633)
psanjuan   
2011-05-10 15:46   
fixed and working