Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0016785 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] A. Platform | major | always | 2011-04-12 18:03 | 2011-04-15 00:00 | |||
Reporter | psarobe | View Status | public | |||||
Assigned To | mtaal | |||||||
Priority | immediate | Resolution | fixed | Fixed in Version | 3.0RC6 | |||
Status | closed | Fix in branch | pi | Fixed in SCM revision | 11571 | |||
Projection | none | ETA | none | Target Version | 3.0RC6 | |||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | pi | SCM revision | ||||||
Merge Request Status | ||||||||
Review Assigned To | ||||||||
OBNetwork customer | No | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Support ticket | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0016785: When a date field is being used in a call-outs, the call-out fails | |||||||
Description | This happens across the whole ERP. The problem is with "getStringParameter" used for a date field. When you type 12-04-2011 the ERP gets 2011-04-12T00:00:00 and fails In case you use Oracle, the error that shows the log is: "java.sql.SQLDataException: ORA-01861: literal does not match format string" | |||||||
Steps To Reproduce | 1. Login as Openbravo/openbravo 2. Change role to QA testing Admin 3. Go to Requisition window. Click new and select Vendor A as bpartner 4. Move to lines (form view) and fill: 4.1 Needed by date: Current system date 4.2 Select the product rmb Notice that "unit price" is empty. This is wrong. It should be filled with 2.00 5. If you do this other way it works: 5.1 Select the product rmb. the call-out puts the unit price 2.00 5.2 Put the date The problem is because the call-out is not receiving the correct date because of the format Another example: 1. Go to G/L Journal window. Fill the mandatory fields (description) and save 2. Go to header and change the period to Apr-11 Expected behaviour: The accounting date must change to the last date of the April and it doesn't | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
![]() |
||||||||
|
![]() |
|
(0035875) shuehner (administrator) 2011-04-12 18:52 |
Note: getStringParameter is a standard function to read any parameter. And afaik doesn'T do any formatting. Probably the client side is just sending wrongly formatted values again, looks like js-dateformat seems to be used instead of the classic format. Probably same/similar issue as the 'Create From'/Create Lines psa reported some days ago. |
(0035876) psarobe (viewer) 2011-04-12 19:05 |
Thanks Stefan. https://issues.openbravo.com/view.php?id=16702 [^] |
(0035878) mtaal (viewer) 2011-04-13 00:03 |
Hi, I tested this and the G/L window works fine for me. For the requisition case, I get the message that no price list can be found for the product/date combination. I don't see an actual error in the log, did you see this? gr. Martin |
(0035880) psarobe (viewer) 2011-04-13 00:28 |
Hi Martin, Requisition: Does the unit price gets filled with 2.00? G/L journal, header tab: Does the accounting date change to the last day of April? |
(0035882) psarobe (viewer) 2011-04-13 00:44 |
I can reproduce it in requisition window I cannot reproduce it in G/L journal. This is crazy |
(0035894) mtaal (viewer) 2011-04-13 11:02 |
Repository: erp/devel/pi Changeset: 4092392748d8106f4141ec9778676837162f77a3 Author: Martin Taal <martin.taal <at> openbravo.com> Date: Wed Apr 13 10:59:01 2011 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/4092392748d8106f4141ec9778676837162f77a3 [^] [^] Fixes issue 16777: Autosave is triggered when using the Create new widget from the navigation tool bar. Sales order --- M modules/org.openbravo.client.application/src/org/openbravo/client/application/window/FormInitializationComponent.java M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/ob-standard-view.js M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/ob-toolbar.js M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/ob-view-form.js M modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/reference/NumberUIDefinition.java M modules/org.openbravo.userinterface.selector/web/org.openbravo.userinterface.selector/js/ob-selector-item.js |
(0035896) mtaal (viewer) 2011-04-13 11:22 |
For testing this change also test actions from the toolbar such as complete order, copy lines, print and export, etc. |
(0035938) psarobe (viewer) 2011-04-14 11:46 |
Fixed |
![]() |
|||
Date Modified | Username | Field | Change |
2011-04-12 18:03 | psarobe | New Issue | |
2011-04-12 18:03 | psarobe | Assigned To | => mtaal |
2011-04-12 18:03 | psarobe | Modules | => Core |
2011-04-12 18:03 | psarobe | OBNetwork customer | => No |
2011-04-12 18:04 | psarobe | Status | new => scheduled |
2011-04-12 18:04 | psarobe | fix_in_branch | => pi |
2011-04-12 18:05 | psarobe | fix_in_branch | pi => |
2011-04-12 18:05 | psarobe | Summary | When a date field is using in call-outs, the call-out fails => When a date field is being used in a call-outs, the call-out fails |
2011-04-12 18:52 | shuehner | Note Added: 0035875 | |
2011-04-12 19:05 | psarobe | Note Added: 0035876 | |
2011-04-13 00:03 | mtaal | Note Added: 0035878 | |
2011-04-13 00:03 | mtaal | Status | scheduled => feedback |
2011-04-13 00:28 | psarobe | Note Added: 0035880 | |
2011-04-13 00:44 | psarobe | Note Added: 0035882 | |
2011-04-13 09:11 | psarobe | Status | feedback => scheduled |
2011-04-13 09:11 | psarobe | fix_in_branch | => pi |
2011-04-13 11:02 | mtaal | Note Added: 0035894 | |
2011-04-13 11:02 | mtaal | Status | scheduled => resolved |
2011-04-13 11:02 | mtaal | Fixed in SCM revision | => 11571 |
2011-04-13 11:02 | mtaal | Resolution | open => fixed |
2011-04-13 11:22 | mtaal | Note Added: 0035896 | |
2011-04-13 13:28 | psarobe | Relationship added | related to 0016795 |
2011-04-14 11:46 | psarobe | Note Added: 0035938 | |
2011-04-14 11:46 | psarobe | Status | resolved => closed |
2011-04-14 11:46 | psarobe | Fixed in Version | => 3.0RC6 |
2011-04-15 00:00 | anonymous | sf_bug_id | 0 => 3286833 |
Copyright © 2000 - 2009 MantisBT Group |