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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0015932
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2011-02-10 16:242011-05-10 15:46
ReporteradrianromeroView Statuspublic 
Assigned Todalsasua 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionc849db4f722d
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015932: 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 ]
depends on backport 00158992.50MP27 closeddalsasua The general ledger journal should show an "Add and keep going..." a "Total" and a "Previous Sums" sections 

-  Notes
(0034551)
hgbot (developer)
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 (manager)
2011-05-10 15:46

fixed and working

- Issue History
Date Modified Username Field Change
2011-02-10 16:24 adrianromero New Issue
2011-02-10 16:24 adrianromero Assigned To => dalsasua
2011-02-10 16:24 adrianromero Modules => Core
2011-02-10 16:24 adrianromero Issue generated from 0015899
2011-02-10 16:24 adrianromero Relationship added depends on 0015899
2011-02-10 16:24 adrianromero Status new => scheduled
2011-02-10 16:24 adrianromero fix_in_branch => pi
2011-03-04 12:19 hgbot Checkin
2011-03-04 12:19 hgbot Note Added: 0034551
2011-03-04 12:19 hgbot Status scheduled => resolved
2011-03-04 12:19 hgbot Resolution open => fixed
2011-03-04 12:19 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c849db4f722d6b3be857f053a3aebaf839ebc4f5 [^]
2011-05-10 15:46 psanjuan Note Added: 0036633
2011-05-10 15:46 psanjuan Status resolved => closed
2011-05-10 15:46 psanjuan fix_in_branch pi =>


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker