Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0015127 | Openbravo ERP | 07. Sales management | public | 2010-11-08 15:40 | 2012-03-07 12:30 |
|
| Reporter | zardi | |
| Assigned To | Sandrahuguet | |
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | out of date | |
| Platform | | OS | 20 | OS Version | Ubuntu 9.10 |
| Product Version | pi | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0015127: Copy product template in simple sales order does not work |
| Description | When clicking Copy product template the following error is thrown :
ERROR: invalid input syntax for type numeric "......"
The problem is in the PL/SQL function m_copy_product_template. |
| Steps To Reproduce | - Create a simpe sale order
- Select a Business Partner with 'Product template'
- Copy products from the business partner's template |
| Proposed Solution | I checked the function 'src-db/database/model/functions/M_COPY_PRODUCT_TEMPLATE.xml'and found
- Line 41: v_BillTo has data type numeric and should be a character variable.
- Line 43: v_PriceList has data type character variable and should be a numeric.
- Line 47 : v_Discount has data type character variable and should be a numeric.
- Line 128 : if a model product is not in the selected price list, v_Pricelist is set to zero and an error "division by zero" will be raised. Execute statement, only if Pricelist<> 0
|
| Additional Information | |
| Tags | OB3-Reviewed, UUID project, VMA-Reviewed |
| Relationships | |
| Attached Files |  m_copy_product_template.txt (7,729) 2011-05-10 17:44
https://issues.openbravo.com/file_download.php?file_id=3966&type=bug |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2010-11-08 15:40 | zardi | New Issue | |
| 2010-11-08 15:40 | zardi | Assigned To | => adrianromero |
| 2011-05-10 17:44 | rashid | File Added: m_copy_product_template.txt | |
| 2011-05-10 17:44 | rashid | Note Added: 0036648 | |
| 2011-05-11 16:05 | shuehner | Issue Monitored: shuehner | |
| 2011-05-11 16:05 | shuehner | Tag Attached: UUID project | |
| 2011-06-03 10:58 | dalsasua | Assigned To | adrianromero => dalsasua |
| 2011-07-20 18:16 | dalsasua | Assigned To | dalsasua => jonalegriaesarte |
| 2011-09-19 11:14 | psarobe | Priority | normal => high |
| 2011-09-19 11:14 | psarobe | Severity | minor => major |
| 2011-09-19 11:14 | psarobe | Status | new => scheduled |
| 2011-09-19 11:14 | psarobe | version | 2.50MP23 => pi |
| 2011-10-29 21:44 | psarobe | Tag Attached: OB3-Reviewed | |
| 2012-02-15 19:04 | iciordia | Assigned To | jonalegriaesarte => vmromanos |
| 2012-02-16 17:31 | vmromanos | Tag Attached: VMA-Reviewed | |
| 2012-03-07 12:15 | Sandrahuguet | Assigned To | vmromanos => Sandrahuguet |
| 2012-03-07 12:30 | Sandrahuguet | Note Added: 0046128 | |
| 2012-03-07 12:30 | Sandrahuguet | Status | scheduled => closed |
| 2012-03-07 12:30 | Sandrahuguet | Resolution | open => out of date |