Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0016789 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | critical | always | 2011-04-13 09:09 | 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 | Fixed in SCM revision | a3d7655c758f | ||||
| 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 | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0016789: What you enter through the ERP it is different from what it is stored in the DB | |||||||
| Description | For example if you type in the qty of the sales order line 11.2 in the db is stored a different qty making later on everything related with the sales order fail Example: You enter 11.2 in ERP In the DB you have:11.199999999999999289457264239899814128875732421875 Please see attach DB.png Notice as well that the column taxbaseamt is calculated and has the same problem. This makes even worse the issue But the consequences are really bad if you execute the steps. Look at the following screenshot: DElivered.png : Although they have been delivered it says still not delivered since you can pick them salesorderline.png: You can see it says 11,2 and 11,2 but still you can delivered Because of this you cannot even select it in the "create lines from" in sales invoice header | |||||||
| Steps To Reproduce | Login with: "User name": Openbravo "Password": openbravo Change the role to QA Testing Admin Go to Sales management || Transactions || Sales order Click New and select: "Transaction Document": Standard Order "Business partner": Type CUSA and press enter key. Customer A value should be showed instead Once you have the business partner Customer A in place, verify: "Partner Address": .Pamplona, Street Customer center nº1 "Invoice Address": .Pamplona, Street Customer center nº1 "Invoice terms": Customer Schedule After Delivery "Warehouse": Spain warehouse "Price List": Customer A "Payment method": 1 (Spain) "Payment Terms": 30 days, 5 Click Save and move to lines Click new and type FGA for the product and press Enter key. Verify: "Product": Final good A "UOM": Bag "Net Unit Price": 2.00 "Net List Price": 2.00 "Tax": VAT(3)+CHARGE(0.5) "Line Net Amount": 2.00 Change the "Ordered Quantity" to 11.2 and verify the "Line Net Amount" is 22.40 Click Save and move back to the Header tab Click Complete button and press OK Go to Sales management || Transactions || Sales order Click New and select: "Document Type": MM Shipment "Business partner": Type CUSA and press enter key. Customer A value should be showed instead Once you have the business partner Customer A in place, verify: "Partner Address": .Pamplona, Street Customer center nº1 "Warehouse": Spain warehouse "Price List": Customer A, 5 Click "Create Lines From". A pop-up gets opened. Do: Click the Warehouse icon and select the record (spain111) Select the sales order created in [SALa010] In the grid it will appear one record. Marl the record and press the OK button A green success message will appear: Process completed successfully Move to Lines tab. Select the record and enter in form view Click the icon for the product. A pop-up will be opened. Select the record and press OK Verify: "Attribute Set Value": L56 "Storage bin": spain111 "Movement Quantity": 11.2 Click Save and move back to the Header tab Click Complete button Press OK and verify: A green success message appears: Process completed successfully "Document Status": Completed At this point side effects in: 1. If you go to "Create Shipments from orders" you can still see the order although has been fully delivered. 2. If you try to create the sales invoice based on this order you cannot because the Sales order is not in the combo box 3. If you go again to "Create shipment from orders" and pick it again you have a new shipment with qty=1 !!!!!!! 4. If you go again to the sales invoice and click "Create lines from" you now see the order. You select it and complete but has two lines!!. See attach twolines.png 5. But the worst thing is that the order will remain in the combo box forever and if you select it you have a line with qty=0. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  DB.PNG [^] (16,679 bytes) 2011-04-13 09:09
salesorderline.PNG [^] (51,099 bytes) 2011-04-13 09:10
twolines.PNG [^] (59,664 bytes) 2011-04-13 12:31
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0035927) hgbot (developer) 2011-04-14 06:29 |
Repository: erp/devel/pi Changeset: a3d7655c758f5f6726b9444415c90bc86aa915a5 Author: Martin Taal <martin.taal <at> openbravo.com> Date: Thu Apr 14 06:28:51 2011 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/a3d7655c758f5f6726b9444415c90bc86aa915a5 [^] Fixes issue 16789: What you enter through the ERP it is different from what it is stored in the DB --- M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/ob-formitem-widgets.js M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/ob-view-form.js M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/ob-view-grid.js M modules/org.openbravo.service.json/src/org/openbravo/service/json/JsonToDataConverter.java --- |
|
(0035936) psarobe (manager) 2011-04-14 11:35 |
Fixed |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2011-04-13 09:09 | psarobe | New Issue | |
| 2011-04-13 09:09 | psarobe | Assigned To | => mtaal |
| 2011-04-13 09:09 | psarobe | File Added: DB.PNG | |
| 2011-04-13 09:09 | psarobe | Modules | => Core |
| 2011-04-13 09:10 | psarobe | File Added: salesorderline.PNG | |
| 2011-04-13 09:10 | psarobe | Status | new => scheduled |
| 2011-04-13 09:10 | psarobe | fix_in_branch | => pi |
| 2011-04-13 12:31 | psarobe | fix_in_branch | pi => |
| 2011-04-13 12:31 | psarobe | Steps to Reproduce Updated | View Revisions |
| 2011-04-13 12:31 | psarobe | File Added: twolines.PNG | |
| 2011-04-14 06:29 | hgbot | Checkin | |
| 2011-04-14 06:29 | hgbot | Note Added: 0035927 | |
| 2011-04-14 06:29 | hgbot | Status | scheduled => resolved |
| 2011-04-14 06:29 | hgbot | Resolution | open => fixed |
| 2011-04-14 06:29 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/a3d7655c758f5f6726b9444415c90bc86aa915a5 [^] |
| 2011-04-14 11:35 | psarobe | Note Added: 0035936 | |
| 2011-04-14 11:35 | psarobe | Status | resolved => closed |
| 2011-04-14 11:35 | psarobe | Fixed in Version | => 3.0RC6 |
| 2011-04-15 00:00 | anonymous | sf_bug_id | 0 => 3286835 |
| 2016-01-19 11:09 | alostale | Relationship added | related to 0031901 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |