Openbravo Issue Tracking System - Openbravo ERP
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
"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.
| related to | defect | 0031901 | closed | caristu | decimal value can't be changed by trigger/observer after manual edition in form view |
DB.PNG (16,679) 2011-04-13 09:09https://issues.openbravo.com/file_download.php?file_id=3867&type=bug
salesorderline.PNG (51,099) 2011-04-13 09:10https://issues.openbravo.com/file_download.php?file_id=3868&type=bug
twolines.PNG (59,664) 2011-04-13 12:31https://issues.openbravo.com/file_download.php?file_id=3869&type=bug