Openbravo Issue Tracking System - Openbravo ERP |
View Issue Details |
|
ID | Project | Category | View Status | Date Submitted | Last Update |
0035560 | Openbravo ERP | 09. Financial management | public | 2017-03-17 14:01 | 2017-03-30 17:27 |
|
Reporter | maite | |
Assigned To | markmm82 | |
Priority | immediate | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | |
Platform | | OS | 5 | OS Version | |
Product Version | | |
Target Version | | Fixed in Version | 3.0PR17Q2 | |
Merge Request Status | |
Review Assigned To | aferraz |
OBNetwork customer | |
Web browser | |
Modules | Core |
Support ticket | |
Regression level | Production - Confirmed Stable |
Regression date | 2015-04-24 |
Regression introduced in release | 3.0PR15Q3 |
Regression introduced by commit | https://code.openbravo.com/erp/devel/pi/rev/1881cfa4bb9c [^] |
Triggers an Emergency Pack | No |
|
Summary | 0035560: "Adjustment Period" not used when posting a GL Journal |
Description | In case Adjustment Period is defined for your calendar and user tries to post gl journal document in that period it is not properly done |
Steps To Reproduce | 1. Access Fiscal Calendar "US Calendar", go to Year 2017 and create new Period named "adjustment period", starting date=ending date=31-12-2017 and type= adjustment perio"
2. Access Open/Close period control window filter by "US Calendar" and "2017" year and run "Open period" process in adjustment period
3. Register GL Journal for "F&B US East Coast" organization, Date=31-12-2017, period= adjustment period and currency=USD
4. Add header setting "F&B International Group US/A/US Dollar" general ledger and verify that adjustment period is set
5. Add line for any account and any debit amount
6. Add another line for different account and same credit amount
7. Process header and post it
8. Access "Accounting transaction details" window and verify that period set is "Dec-17" instead of "adjustment period"
Moreover, you can verify that if you unpost journal, close Dec-17 period and try to post it again you will receive "Period closed" error. So period set in GL Journal document is not being considered |
Proposed Solution | |
Additional Information | |
Tags | No tags attached. |
Relationships | depends on | backport | 0035575 | 3.0PR17Q1.1 | closed | markmm82 | "Adjustment Period" not used when posting a GL Journal | depends on | backport | 0035576 | 3.0PR16Q4.4 | closed | markmm82 | "Adjustment Period" not used when posting a GL Journal | caused by | defect | 0028973 | | closed | reinaldoguerra | G/L Journal can be posted in a closed period. It cannot be unposted then |
|
Attached Files | |
|
Issue History |
Date Modified | Username | Field | Change |
2017-03-17 14:01 | maite | New Issue | |
2017-03-17 14:01 | maite | Assigned To | => Triage Finance |
2017-03-17 14:01 | maite | Modules | => Core |
2017-03-17 14:01 | maite | Resolution time | => 1491516000 |
2017-03-17 14:01 | maite | Triggers an Emergency Pack | => No |
2017-03-17 14:01 | maite | Issue Monitored: networkb | |
2017-03-17 14:06 | maite | Relationship added | caused by 0028973 |
2017-03-17 14:18 | eugeni | Issue Monitored: eugeni | |
2017-03-20 00:38 | markmm82 | Assigned To | Triage Finance => luisrs8608 |
2017-03-20 14:59 | markmm82 | Regression level | => Production - Confirmed Stable |
2017-03-20 14:59 | markmm82 | Regression date | => 2015-04-24 |
2017-03-20 14:59 | markmm82 | Regression introduced in release | => 3.0PR15Q3 |
2017-03-20 14:59 | markmm82 | Regression introduced by commit | => https://code.openbravo.com/erp/devel/pi/rev/1881cfa4bb9c [^] |
2017-03-20 15:00 | markmm82 | Status | new => scheduled |
2017-03-20 18:55 | hgbot | Checkin | |
2017-03-20 18:55 | hgbot | Note Added: 0095441 | |
2017-03-20 18:55 | hgbot | Status | scheduled => resolved |
2017-03-20 18:55 | hgbot | Resolution | open => fixed |
2017-03-20 18:55 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/9812b29fd4fa27988dd0f969844044edafc5789c [^] |
2017-03-20 19:06 | markmm82 | Assigned To | luisrs8608 => markmm82 |
2017-03-20 19:07 | markmm82 | Review Assigned To | => markmm82 |
2017-03-20 19:07 | markmm82 | Note Added: 0095444 | |
2017-03-20 19:07 | markmm82 | Status | resolved => closed |
2017-03-20 19:07 | markmm82 | Fixed in Version | => 3.0PR17Q2 |
2017-03-21 15:26 | hudsonbot | Checkin | |
2017-03-21 15:26 | hudsonbot | Note Added: 0095475 | |
2017-03-30 09:23 | aferraz | Review Assigned To | markmm82 => aferraz |
2017-03-30 10:26 | aferraz | Note Added: 0095690 | |
2017-03-30 10:26 | aferraz | Status | closed => new |
2017-03-30 10:26 | aferraz | Resolution | fixed => open |
2017-03-30 10:26 | aferraz | Fixed in Version | 3.0PR17Q2 => |
2017-03-30 10:27 | hgbot | Checkin | |
2017-03-30 10:27 | hgbot | Note Added: 0095691 | |
2017-03-30 11:40 | hgbot | Checkin | |
2017-03-30 11:40 | hgbot | Note Added: 0095703 | |
2017-03-30 12:34 | aferraz | Note Deleted: 0095444 | |
2017-03-30 12:34 | aferraz | Status | new => scheduled |
2017-03-30 12:34 | aferraz | Status | scheduled => resolved |
2017-03-30 12:34 | aferraz | Fixed in Version | => 3.0PR17Q2 |
2017-03-30 12:34 | aferraz | Resolution | open => fixed |
2017-03-30 12:35 | aferraz | Note Added: 0095705 | |
2017-03-30 12:35 | aferraz | Status | resolved => closed |
2017-03-30 17:27 | hudsonbot | Checkin | |
2017-03-30 17:27 | hudsonbot | Note Added: 0095729 | |
2017-03-30 17:27 | hudsonbot | Checkin | |
2017-03-30 17:27 | hudsonbot | Note Added: 0095731 | |
Notes |
|
(0095441)
|
hgbot
|
2017-03-20 18:55
|
|
Repository: erp/devel/pi
Changeset: 9812b29fd4fa27988dd0f969844044edafc5789c
Author: Mark <markmm82 <at> gmail.com>
Date: Mon Mar 20 13:14:16 2017 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/9812b29fd4fa27988dd0f969844044edafc5789c [^]
Fixes issue 35560: "Adjustment Period" not used when posting a GL Journal
In case Adjustment Period was defined for a calendar and user tries to post gl journal document in that period it was not properly done.
It was fixed re-structuring the affected queries using the C_PERIOD_ID column of GL_JOURNAL and C_PERIOD tables, always retrieving this value as C_PERIOD_ID instead of "period" alias
---
M src/org/openbravo/erpCommon/ad_forms/DocGLJournal_data.xsql
---
|
|
|
|
|
|
|
Reopened because it was causing issue 0028973 to be reproducible again. |
|
|
(0095691)
|
hgbot
|
2017-03-30 10:27
|
|
Repository: erp/devel/pi
Changeset: a998052fc4257f6f143fff8ebb8ffec68dea1302
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Thu Mar 30 10:25:21 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a998052fc4257f6f143fff8ebb8ffec68dea1302 [^]
Related to issue 35560: Code review improvements
Backout fixes of issues 35560 & 28973 and fix issue 28973 properly:
DocGLJournal.isperiodOpen method was not correctly checking if DocGLJournalData.periodOpen retrieves no period.
---
M src/org/openbravo/erpCommon/ad_forms/DocGLJournal.java
M src/org/openbravo/erpCommon/ad_forms/DocGLJournal_data.xsql
---
|
|
|
(0095703)
|
hgbot
|
2017-03-30 11:40
|
|
|
|
|
|
|
|
|
|
|
|