Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0014632Openbravo ERP09. Financial managementpublic2010-09-21 12:212011-01-27 10:11
Reporteradrianromero 
Assigned Tosivaraman 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP12 
Target Version2.40MP13Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0014632: You can process a Bank Statement with a Line with invalid Accounting Date
DescriptionYou can process a Bank Statement with a Line with invalid Accounting Date
Steps To Reproduce0. Financial Management || Accounting || Setup || Fiscal Calendar || Calendar >> Year : create year 2010 and press "Create Periods" button
0. Financial Management || Accounting || Setup || Fiscal Calendar || Calendar >> Year >> Period : search for September period and press "Open/Close all" button to open it

1. Financial Management || Receivables & Payables || Transactions || Bank Statement || Header : create record for 17-09-2010
2. Press "Create Lines From" and select any payment.
3. Go to Financial Management || Receivables & Payables || Transactions || Bank Statement || Header >> Lines : modify Effective Date and Accounting Date to 17-09-2345
4. Come back to header: PROCESS and POST. Bankstatement is posted
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
duplicate of backport 00131042.40MP13 closed sathiyan You can process a Bank Statement when its period is not open 
blocks defect 00146062.40MP13 closed dalsasua You can process a Bank Statement with a Line with invalid Accounting Date 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-09-21 12:21adrianromeroNew Issue
2010-09-21 12:21adrianromeroAssigned To => dalsasua
2010-09-21 12:21adrianromeroOBNetwork customer => Yes
2010-09-21 12:21adrianromeroIssue generated from0014606
2010-09-21 12:21adrianromeroRelationship addedblocks 0014606
2010-09-22 13:30sivaramanAssigned Todalsasua => sivaraman
2010-09-22 13:33sivaramanRelationship addedduplicate of 0013104
2010-09-22 13:33sivaramanNote Added: 0031296
2010-09-22 13:33sivaramanStatusnew => closed
2010-09-22 13:33sivaramanResolutionopen => duplicate
2010-09-22 13:33sivaramanFixed in Version => 2.40
2010-09-29 11:03networkbNote Added: 0031441
2010-09-29 11:03networkbStatusclosed => new
2010-09-29 11:03networkbResolutionduplicate => open
2010-09-29 11:03networkbFixed in Version2.40 =>
2010-09-29 11:06networkbSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=937#r937
2010-10-08 12:21hgbotCheckin
2010-10-08 12:21hgbotNote Added: 0031680
2010-10-08 12:21hgbotStatusnew => resolved
2010-10-08 12:21hgbotResolutionopen => fixed
2010-10-08 12:21hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/2d0912981d125efc8a6a5651565b50471a1e1696 [^]
2010-10-08 12:28sivaramanNote Added: 0031681
2011-01-27 10:11psarobeNote Added: 0033898
2011-01-27 10:11psarobeStatusresolved => closed

Notes
(0031296)
sivaraman   
2010-09-22 13:33   
Issue is not reproducible. The expected functionality is working fine as described in the issue 13104. Hence, It's rejected.
(0031441)
networkb   
2010-09-29 11:03   
I can still reproduce it on http://live.builds.openbravo.com/erp_stable_2.40-full-pgsql/security/Menu.html [^]

Probably you are obtained the error because period is not open.
I update Steps to Reproduce to indicate that period should be opened first.
(0031680)
hgbot   
2010-10-08 12:21   
Repository: erp/stable/2.40
Changeset: 2d0912981d125efc8a6a5651565b50471a1e1696
Author: Sivaraman Rajagopal <sivaraman.rajagopal <at> openbravo.com>
Date: Fri Oct 08 15:49:17 2010 +0530
URL: http://code.openbravo.com/erp/stable/2.40/rev/2d0912981d125efc8a6a5651565b50471a1e1696 [^]

Fixes issue 14632: You can process a Bank Statement with a Line with invalid Accounting Date

GL_Period_Open function is used to find out whether the account period is open for the given date or not. The both effective and accounting dates are verified for opened period. If either of those is closed, then error message will be shown when the document is processed.

No Impacts

---
M src-db/database/model/functions/C_BANKSTATEMENT_POST.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
---
(0031681)
sivaraman   
2010-10-08 12:28   
Steps to test:

1. Financial Management || Accounting || Setup || Fiscal Calendar || Calendar >> Year : create year 2010 and press "Create Periods" button
2. Financial Management || Accounting || Setup || Fiscal Calendar || Calendar >> Year >> Period : search for September period and press "Open/Close all" button to open it
3. Financial Management || Receivables & Payables || Transactions || Bank Statement || Header : create record for 17-09-2010
4. Press "Create Lines From" and select any payment.
5. Go to Financial Management || Receivables & Payables || Transactions || Bank Statement || Header >> Lines : modify Effective Date and Accounting Date to 17-09-2345
6. Come back to header and click process button
7. Verify if error is shown as 'The Period does not exist or it is not opened'
(0033898)
psarobe   
2011-01-27 10:11   
Tested working fine