Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0010331Openbravo ERP07. Sales managementpublic2009-08-19 09:582009-08-21 00:00
arunkumar 
mtaal 
urgentmajorhave not tried
closedfixed 
5
pi 
pi 
Core
No
0010331: While posting mass invoice , exception thrown as "SQL command not ended properly"
While posting mass invoice , exception is thrown as "SQL command not ended properly"
Prerequisite:

PI context should be installed with two modules
(1) Multiple business partner selector
(2) mass Invoicing

Login as Openbravo/openbravo in the role of Openbravo Admin.
Go to Sales Management || Transactions || Mass Invoicing || Mass Invoicing
Select the Organization as Main, Invoice date as 25-08-2009, Business partner - The Stones Foundries, Template - TestMain.
Click next button.
In the next page click "Generate" button.

You will see an exception error thrown as "SQL command not ended properly".

No tags attached.
jpg post1.JPG (171,508) 2009-08-19 10:00
https://issues.openbravo.com/file_download.php?file_id=1660&type=bug
jpg
Issue History
2009-08-19 09:58arunkumarNew Issue
2009-08-19 09:58arunkumarAssigned To => rafaroda
2009-08-19 09:58arunkumarFile Added: post1.JPG
2009-08-19 09:58arunkumarFile Deleted: post1.JPG
2009-08-19 10:00arunkumarFile Added: post1.JPG
2009-08-19 12:50rafarodaAssigned Torafaroda => mtaal
2009-08-19 12:50rafarodaPrioritynormal => urgent
2009-08-19 12:50rafarodaStatusnew => scheduled
2009-08-19 17:36hgbotCheckin
2009-08-19 17:36hgbotNote Added: 0019066
2009-08-19 17:36hgbotStatusscheduled => resolved
2009-08-19 17:36hgbotResolutionopen => fixed
2009-08-19 17:36hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/1a6ef8a0637f727b8839ad2a921bdeff75ad2018 [^]
2009-08-20 08:33arunkumarStatusresolved => closed
2009-08-20 08:33arunkumarNote Added: 0019087
2009-08-20 08:33arunkumarFixed in Version => pi
2009-08-21 00:00anonymoussf_bug_id0 => 2841484

Notes
(0019066)
hgbot   
2009-08-19 17:36   
Repository: erp/devel/pi
Changeset: 1a6ef8a0637f727b8839ad2a921bdeff75ad2018
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Wed Aug 19 17:35:36 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/1a6ef8a0637f727b8839ad2a921bdeff75ad2018 [^]

fixes issue 10331: While posting mass invoice , exception thrown as \"SQL command not ended properly\"

---
M src/org/openbravo/service/db/CallProcess.java
---
(0019087)
arunkumar   
2009-08-20 08:33   
This issue has been fixed.