details: https://code.openbravo.com/erp/devel/pi/rev/7716d145ea66
changeset: 20476:7716d145ea66
user: Jon AlegrÃa <jon.alegria <at> openbravo.com>
date: Mon May 27 17:54:17 2013 +0200
summary: Fixes issue 0023923: Book POS order is failing under some conditions
diffstat:
src-db/database/model/functions/C_INVOICE_CREATE.xml | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diffs (22 lines):
diff -r 8a750c29825c -r 7716d145ea66
src-db/database/model/functions/C_INVOICE_CREATE.xml
--- a/src-db/database/model/functions/C_INVOICE_CREATE.xml Mon May 27
17:09:04 2013 +0200
+++ b/src-db/database/model/functions/C_INVOICE_CREATE.xml Mon May 27
17:54:17 2013 +0200
@@ -544,14 +544,14 @@
v_Reference, NULL, 0, 0,
0, 0, 0, NULL,
0, NULL, NULL, 0,
- ptr_ol.explode, (SELECT c_invoiceline_id
+ ptr_sl.explode, (SELECT c_invoiceline_id
FROM c_invoiceline
WHERE c_invoice_id=p_Invoice_ID
and c_orderline_id = (SELECT
BOM_parent_id
FROM
c_orderline
- WHERE
c_orderline_id = ptr_ol.c_orderline_id)),
- ptr_ol.C_Project_ID, ptr_ol.C_Bpartner_ID,
ptr_ol.A_Asset_ID,
- ptr_ol.C_Costcenter_ID, ptr_ol.User1_ID, ptr_ol.User2_ID
+ WHERE
c_orderline_id = ptr_sl.c_orderline_id)),
+ ptr_sl.C_Project_ID, ptr_sl.C_Bpartner_ID,
ptr_sl.A_Asset_ID,
+ ptr_sl.C_Costcenter_ID, ptr_sl.User1_ID, ptr_sl.User2_ID
)
;
END IF;
------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
