0023091: Cannot unpost transactions dated 31-Dec-2012 when adjustment periods are used.

Description

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.

Steps To Reproduce

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.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0056502) pjuvara (viewer) 2013-02-17 21:46	This issue is related to 23090.

(0057065) dmiguelez (viewer) 2013-03-05 18:37	Fixed in commit: https://code.openbravo.com/erp/devel/pi/rev/c6c76a1ab1c726c043c0fdc21dfc7c1274f5abf3 [^]

Issue History
Date Modified	Username	Field	Change
2013-02-17 21:46	pjuvara	New Issue
2013-02-17 21:46	pjuvara	Assigned To	=> dmiguelez
2013-02-17 21:46	pjuvara	Modules	=> Core
2013-02-17 21:46	pjuvara	Triggers an Emergency Pack	=> No
2013-02-17 21:46	pjuvara	Note Added: 0056502
2013-03-05 18:37	dmiguelez	Note Added: 0057065
2013-03-05 18:37	dmiguelez	Status	new => closed
2013-03-05 18:37	dmiguelez	Resolution	open => fixed
2013-03-05 18:37	dmiguelez	Fixed in Version	=> pi