Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0022716 | Openbravo ERP | 09. Financial management | public | 2013-01-02 10:37 | 2013-02-20 04:50 |
|
| Reporter | xabiermerino | |
| Assigned To | eduardo_Argal | |
| Priority | immediate | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | 3.0MP18.1 | |
| Target Version | 3.0MP20 | Fixed in Version | pi | |
| Merge Request Status | |
| Review Assigned To | mirurita |
| OBNetwork customer | OBPS |
| Web browser | |
| Modules | Core |
| Support ticket | 18367 |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0022716: Balance sheet shows wrong data |
| Description | With the standard configuraion of nodes the report does not show data of the account 55230 |
| Steps To Reproduce | -As Admin execute the balance sheet report
-realized that the report is balanced
-Create a GL Journal with these lines:
- Account: 55230 Credit: 900000
- Account: 55500 Debit: 900000
-Execute the report again
-Realize that the report is not balanced |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2013-01-02 10:37 | xabiermerino | New Issue | |
| 2013-01-02 10:37 | xabiermerino | Assigned To | => dmiguelez |
| 2013-01-02 10:37 | xabiermerino | Modules | => Core |
| 2013-01-02 10:37 | xabiermerino | OBNetwork customer | => Yes |
| 2013-01-02 10:37 | xabiermerino | Support ticket | => 18367 |
| 2013-01-02 10:37 | xabiermerino | Triggers an Emergency Pack | => No |
| 2013-01-02 10:38 | xabiermerino | Issue Monitored: networkb | |
| 2013-01-08 09:22 | dmiguelez | Assigned To | dmiguelez => jonalegriaesarte |
| 2013-01-09 11:25 | jonalegriaesarte | Target Version | 3.0MP19 => 3.0MP20 |
| 2013-01-24 11:18 | jonalegriaesarte | Target Version | 3.0MP20 => 3.0MP21 |
| 2013-02-07 12:13 | azabaleta | Issue Monitored: azabaleta | |
| 2013-02-07 20:19 | eduardo_Argal | Assigned To | jonalegriaesarte => eduardo_Argal |
| 2013-02-07 20:20 | eduardo_Argal | Status | new => scheduled |
| 2013-02-07 20:20 | eduardo_Argal | fix_in_branch | => pi |
| 2013-02-07 20:20 | eduardo_Argal | Priority | urgent => immediate |
| 2013-02-07 20:20 | eduardo_Argal | fix_in_branch | pi => |
| 2013-02-07 20:20 | eduardo_Argal | Target Version | 3.0MP21 => 3.0MP20 |
| 2013-02-07 20:53 | hgbot | Checkin | |
| 2013-02-07 20:53 | hgbot | Note Added: 0056274 | |
| 2013-02-07 20:53 | hgbot | Status | scheduled => resolved |
| 2013-02-07 20:53 | hgbot | Resolution | open => fixed |
| 2013-02-07 20:53 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/818ea56e7552ac5cd56fb26feb68c4a7898494a2 [^] |
| 2013-02-08 06:30 | hudsonbot | Checkin | |
| 2013-02-08 06:30 | hudsonbot | Note Added: 0056284 | |
| 2013-02-12 14:06 | hgbot | Checkin | |
| 2013-02-12 14:06 | hgbot | Note Added: 0056395 | |
| 2013-02-12 14:06 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/818ea56e7552ac5cd56fb26feb68c4a7898494a2 [^] => http://code.openbravo.com/erp/devel/pi/rev/4176f16824f24418d5f0492ddedd9cc0247c6b1b [^] |
| 2013-02-12 14:24 | mirurita | Review Assigned To | => mirurita |
| 2013-02-12 14:24 | mirurita | Note Added: 0056396 | |
| 2013-02-12 14:24 | mirurita | Status | resolved => closed |
| 2013-02-12 14:24 | mirurita | Fixed in Version | => pi |
| 2013-02-20 04:50 | hudsonbot | Checkin | |
| 2013-02-20 04:50 | hudsonbot | Note Added: 0056584 | |
|
Notes |
|
|
(0056274)
|
|
hgbot
|
|
2013-02-07 20:53
|
|
|
|
|
|
|
|
|
(0056395)
|
|
hgbot
|
|
2013-02-12 14:06
|
|
Repository: erp/devel/pi
Changeset: 4176f16824f24418d5f0492ddedd9cc0247c6b1b
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Tue Feb 12 14:01:39 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/4176f16824f24418d5f0492ddedd9cc0247c6b1b [^]
Fixes bug 22716
---
M src/org/openbravo/erpCommon/businessUtility/AccountTree.java
M src/org/openbravo/erpCommon/businessUtility/AccountTree_data.xsql
---
|
|
|
|
(0056396)
|
|
mirurita
|
|
2013-02-12 14:24
|
|
Testing Plan
1) Install source with pi changeset 19654:4c3694e1e6a9
2) Execute report with the following filters
General Ledger: F&B España, S.A. US/A/Euro
Show only accounts with value: true
Show Account codes: true
Accounting Report: Balance de Situación
Organization: F&B España, S.A
Account Level: Account
Year: 2012
As of Date: <empty>
Reference Year: 2012
As of Reference Date: <empty>
Initial page number: 1
Activo: -20.527.149,58
Pasivo: -20.527.149,58
Realize that the account 55230 is not displayed
3) Create a G/L Journal and post it
General Ledger: F&B España, S.A. US/A/Euro
Organization: F&B España, S.A
Currency: EUR
55230 debit (5000000) - credit (0)
55500 debit (0) - credit (5000000)
Possitive balance in the subaccount: +5000000€
4) Execute Balance sheet and P&L structure report with filters of step 2)
Activo
552A - Cuenta corriente con otras personas y entidades vinculadas 5.000.000,00
Pasivo
555 - Partidas pendientes de aplicación 5.000.000,00
5) Reactivate G/L Journal of step 3)
Create a G/L Journal and post it
General Ledger: F&B España, S.A. US/A/Euro
Organization: F&B España, S.A
Currency: EUR
55230 debit (0) - credit (5000000)
55500 debit (5000000) - credit (0)
Negative balance in the subaccount: -5000000€
6) Execute Balance sheet and P&L structure
General Ledger: F&B España, S.A. US/A/Euro
Show only accounts with value: true
Show Account codes: true
Accounting Report: Balance de Situación
Organization: F&B España, S.A
Account Level: SubAccount
Year: 2012
As of Date: <empty>
Reference Year: 2012
As of Reference Date: <empty>
Initial page number: 1
(5523) - Cuenta corriente con empresas del grupo 5.000.000,00
55500 - Partidas pendientes de aplicación -5.000.000,00
7) Change the account sign of 55230 account to Credit.
This change should be ignored because the 5523 account has the Debit sign.
8) Execute Balance sheet and P&L structure report with filters of step 6)
Pasivo
(5523) - Cuenta corriente con empresas del grupo 5.000.000,00
55500 - Partidas pendientes de aplicación -5.000.000,00
Nothing has changed. |
|
|
|
|
|