Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0020699 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 07. Sales management | minor | always | 2012-06-07 12:37 | 2012-08-22 10:35 | |||
Reporter | caristu | View Status | public | |||||
Assigned To | jecharri | |||||||
Priority | high | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | d38f82392f3a | ||||
Projection | none | ETA | none | Target Version | 3.0MP15 | |||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Review Assigned To | caristu | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0020699: Some candidate orders can't be selected using the Create Lines From button | |||||||
Description | If we have a sales order with "After Delivery" Invoice Terms, and its order lines have a sum of the quantity delivered equals to zero having negative quantities, we can't select this order in the [Sales Invoice] window when using the Create Lines From button. | |||||||
Steps To Reproduce | 1) Go to [Sales Order] windows, create a Warehouse Order with After Delivery Invoice Terms 2) Create two order lines: one with order quantity equal to 1 and the other with order quantity equal to -1 (the sum is zero) 3) Book the order 4) Go to [Sales Invoice] and create a new record. Use the "Create Lines From" button. 5) Notice that we can select the lines from the associated shipment, but not by the sales order. | |||||||
Proposed Solution | The query for select the orders when we click the orders combo, called selectFromPOSOTrxCombo, is defined in CreateFrom_Invoice_data.xsql. This function uses a view (c_invoice_candidate_v) that have a column (qtydelivered) that stores the sum of the quantity delivered for every line of the order. When the invoice term is After Delivery, the function checks that the value of qtydelivered is different from zero. And is not taking into account that we can possibly have negative values that make the result of the sum be zero. The solution should verify if every line in the order have a quantity delivered equals to zero, instead of the sum. | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0051037) jonalegriaesarte (reporter) 2012-07-31 17:17 |
Moved to MP15 due to other priorities |
(0051364) hgbot (developer) 2012-08-20 12:46 |
Repository: erp/devel/pi Changeset: d38f82392f3a8547fd27a08bdd895a70fdc1fcaf Author: Javier Etxarri <javier.echarri <at> openbravo.com> Date: Mon Aug 20 12:45:47 2012 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/d38f82392f3a8547fd27a08bdd895a70fdc1fcaf [^] Fixes issue 20699: Some candidate orders can't be selected using the Create Lines From button --- M src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml --- |
(0051449) caristu (developer) 2012-08-22 10:35 |
Verified |
Issue History | |||
Date Modified | Username | Field | Change |
2012-06-07 12:37 | caristu | New Issue | |
2012-06-07 12:37 | caristu | Assigned To | => mirurita |
2012-06-07 12:37 | caristu | Modules | => Core |
2012-06-07 12:37 | caristu | Resolution time | => 1345500000 |
2012-06-07 12:44 | caristu | Reproducibility | have not tried => always |
2012-06-07 13:06 | caristu | Proposed Solution updated | |
2012-06-07 13:06 | caristu | Issue Monitored: networkb | |
2012-06-07 13:16 | mirurita | Assigned To | mirurita => jonalegriaesarte |
2012-06-08 08:22 | jonalegriaesarte | Assigned To | jonalegriaesarte => jecharri |
2012-06-11 16:13 | jecharri | Assigned To | jecharri => ioritzCia |
2012-07-31 17:17 | jonalegriaesarte | Note Added: 0051037 | |
2012-07-31 17:17 | jonalegriaesarte | Target Version | 3.0MP14 => 3.0MP15 |
2012-08-10 10:15 | ioritzCia | Assigned To | ioritzCia => jonalegriaesarte |
2012-08-10 11:06 | jonalegriaesarte | Assigned To | jonalegriaesarte => jecharri |
2012-08-20 12:46 | hgbot | Checkin | |
2012-08-20 12:46 | hgbot | Note Added: 0051364 | |
2012-08-20 12:46 | hgbot | Status | new => resolved |
2012-08-20 12:46 | hgbot | Resolution | open => fixed |
2012-08-20 12:46 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/d38f82392f3a8547fd27a08bdd895a70fdc1fcaf [^] |
2012-08-22 10:35 | caristu | Closed by | => caristu |
2012-08-22 10:35 | caristu | Note Added: 0051449 | |
2012-08-22 10:35 | caristu | Status | resolved => closed |
Copyright © 2000 - 2009 MantisBT Group |