Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0023091Openbravo ERP09. Financial managementpublic2013-02-17 21:462013-03-05 18:37
pjuvara 
dmiguelez 
normalmajoralways
closedfixed 
5
3.0MP19.1 
pi 
Core
No
0023091: Cannot unpost transactions dated 31-Dec-2012 when adjustment periods are used.
MP18 introduced the concept of 13th period for adjustment. That introduces overalapping periods in Dec, for example:
Dec-12 goes from 01-Dec-2012 to 31-Dec-2012
13th Period-12 goes from 31-Dec-2012 to 31-Dec-2012

If you create transactions (Financial Account transactions, invoices, payments, etc.) on Dec-31st they are supposed to be posted on Dec-12 but they are posted on 13th-Period-12 (see defect 23090).

As a side effect, if you try to unpost such a transaction, you get an error that states that the period is not open.

I guess that in the select statement, 2 periods are returned instead of 1 and that is caught by the same exception handler as if there were no open periods.
1) Define a Fiscal Calendar with an adjustment period. That creates overlapping periods; for example:
Dec-12 goes from 01-Dec-2012 to 31-Dec-2012
13th Period-12 goes from 31-Dec-2012 to 31-Dec-2012
See http://wiki.openbravo.com/wiki/Fiscal_Calendar#Year [^] [^]

2) Create a Financial Account transaction of type G/L Item dated 31-Dec-2012 and post it.

3) Try to unpost it.
No tags attached.
Issue History
2013-02-17 21:46pjuvaraNew Issue
2013-02-17 21:46pjuvaraAssigned To => dmiguelez
2013-02-17 21:46pjuvaraModules => Core
2013-02-17 21:46pjuvaraTriggers an Emergency Pack => No
2013-02-17 21:46pjuvaraNote Added: 0056502
2013-03-05 18:37dmiguelezNote Added: 0057065
2013-03-05 18:37dmiguelezStatusnew => closed
2013-03-05 18:37dmiguelezResolutionopen => fixed
2013-03-05 18:37dmiguelezFixed in Version => pi

Notes
(0056502)
pjuvara   
2013-02-17 21:46   
This issue is related to 23090.
(0057065)
dmiguelez   
2013-03-05 18:37   
Fixed in commit:
https://code.openbravo.com/erp/devel/pi/rev/c6c76a1ab1c726c043c0fdc21dfc7c1274f5abf3 [^]