Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039889Openbravo ERP09. Financial managementpublic2019-01-09 11:092019-03-28 14:55
Reporterngarcia 
Assigned ToAtulOpenbravo 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR19Q2 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression levelProduction - QA Approved
Regression date2018-06-20
Regression introduced in release3.0PR18Q4
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/58cf1a94960f [^]
Triggers an Emergency PackNo
Summary0039889: Cannot process a Simple G/L Journal with Open Items option selected on a line
DescriptionCannot process a Simple G/L Journal with Open Items option selected on a line
Steps To ReproduceAs group admin role:
   Create a Simple G/L Journal:
      Organization: F&B US East Coast
      General Ledger: F&B International Group US/A/US Dollar
   Add a line to it:
      Account: 1110 - Checking Account
      Debit: 100
      Open Items: Y
      Select Financial Account, Payment Method, G/L Item and Payment Date
   Add another line to it:
      Account: 1120 - Funds In-Transfer
      Credit: 100
      Open Items: N
   Try to complete it and check the following error is shown:
      java.lang.IllegalArgumentException: Type specified for TypedQuery [org.openbravo.erpCommon.ad_forms.AcctSchema] is incompatible with query return type [class org.openbravo.model.financialmgmt.accounting.coa.AcctSchema]
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00398913.0PR19Q1 closed AtulOpenbravo Cannot process a Simple G/L Journal with Open Items option selected on a line 
depends on backport 00398923.0PR18Q4.2 closed AtulOpenbravo Cannot process a Simple G/L Journal with Open Items option selected on a line 
caused by feature request 0037064 closed caristu upgrade hibernate to 5.3.2 
blocks defect 0039895 closed AtulOpenbravo Simple G/L Journal line can be removed although it has related payment. Payment can be deleted although the journal is processed 
Attached Filesdiff 39889_Proposed.diff (1,496) 2019-01-09 13:12
https://issues.openbravo.com/file_download.php?file_id=12494&type=bug
Issue History
Date ModifiedUsernameFieldChange
2019-01-09 11:09ngarciaNew Issue
2019-01-09 11:09ngarciaAssigned To => Triage Finance
2019-01-09 11:09ngarciaModules => Core
2019-01-09 11:09ngarciaTriggers an Emergency Pack => No
2019-01-09 11:11ngarciaIssue Monitored: networkb
2019-01-09 11:22SandrahuguetAssigned ToTriage Finance => AtulOpenbravo
2019-01-09 12:50AtulOpenbravoRegression date => 2018-06-20
2019-01-09 12:50AtulOpenbravoRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/58cf1a94960f [^]
2019-01-09 12:52SandrahuguetRegression level => Production - QA Approved
2019-01-09 12:54AtulOpenbravoStatusnew => scheduled
2019-01-09 12:54SandrahuguetRegression introduced in release => 3.0PR18Q4
2019-01-09 12:56AtulOpenbravoNote Added: 0108867
2019-01-09 12:56AtulOpenbravoStatusscheduled => acknowledged
2019-01-09 13:04AtulOpenbravoStatusacknowledged => scheduled
2019-01-09 13:12AtulOpenbravoFile Added: 39889_Proposed.diff
2019-01-09 13:21ngarciaSummaryCannot process a Simple G/L Item with Open Items option selected on a line => Cannot process a Simple G/L Journal with Open Items option selected on a line
2019-01-09 13:21ngarciaDescription Updatedbug_revision_view_page.php?rev_id=18094#r18094
2019-01-09 13:21ngarciaDescription Updatedbug_revision_view_page.php?rev_id=18097#r18097
2019-01-09 13:29ngarciaRelationship addedblocks 0039895
2019-01-09 13:35ngarciaResolution time => 1548802800
2019-01-10 10:19hgbotCheckin
2019-01-10 10:19hgbotNote Added: 0108882
2019-01-10 10:19hgbotStatusscheduled => resolved
2019-01-10 10:19hgbotResolutionopen => fixed
2019-01-10 10:19hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/aa95d094046650f81968414c12e9fa38543dc117 [^]
2019-01-10 10:20SandrahuguetReview Assigned To => Sandrahuguet
2019-01-10 10:20SandrahuguetNote Added: 0108885
2019-01-10 10:20SandrahuguetStatusresolved => closed
2019-01-10 10:20SandrahuguetFixed in Version => 3.0PR19Q2
2019-01-11 11:09alostaleRelationship addedcaused by 0037064
2019-03-28 14:55hudsonbotCheckin
2019-03-28 14:55hudsonbotNote Added: 0110718

Notes
(0108867)
AtulOpenbravo   
2019-01-09 12:56   
Test Plan

- As group admin role:
- Create a Simple G/L Journal:
      Organization: F&B US East Coast
      General Ledger: F&B International Group US/A/US Dollar
- Add a line to it:
      Account: 1110 - Checking Account
      Debit: 100
      Open Items: Y
      Select Financial Account, Payment Method, G/L Item and Payment Date.
- Add another line to it:
      Account: 1120 - Funds In-Transfer
      Credit: 100
      Open Items: N
- Try to complete it.
- Realize that Journal is completed successfully.
(0108882)
hgbot   
2019-01-10 10:19   
Repository: erp/devel/pi
Changeset: aa95d094046650f81968414c12e9fa38543dc117
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Thu Jan 10 12:26:05 2019 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/aa95d094046650f81968414c12e9fa38543dc117 [^]

Fixes Issue 39889:Cannot process a Simple G/L Journal with
Open Items option selected on a line

Type of typed query was wrongly mentioned during hibernate
upgrade, org.openbravo.model.financialmgmt.accounting.coa.AcctSchema
required instead of org.openbravo.erpCommon.ad_forms.AcctSchema

---
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/process/FIN_AddPaymentFromJournalLine.java
---
(0108885)
Sandrahuguet   
2019-01-10 10:20   
Code review + testing ok
(0110718)
hudsonbot   
2019-03-28 14:55   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/b2fbc1588df4 [^]
Maturity status: Test