details: https://code.openbravo.com/erp/devel/pi/rev/62df562c95c7
changeset: 19112:62df562c95c7
user: Ioritz Cia <ioritz.cia <at> openbravo.com>
date: Wed Dec 26 16:44:06 2012 +0100
summary: Fixes issue 21998: After completing a sales order/invoice,
the BOM product does not appear. Fix the consistency and fix the invoice
completion.
diffstat:
src-db/database/model/functions/C_INVOICE_POST.xml | 2 +-
src-db/database/model/functions/C_ORDER_POST1.xml | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
diffs (24 lines):
diff -r 9f2e21bb3583 -r 62df562c95c7
src-db/database/model/functions/C_INVOICE_POST.xml
--- a/src-db/database/model/functions/C_INVOICE_POST.xml Wed Dec 26
12:07:36 2012 +0100
+++ b/src-db/database/model/functions/C_INVOICE_POST.xml Wed Dec 26
16:44:06 2012 +0100
@@ -1215,7 +1215,7 @@
LineNetAmt=0,
ChargeAmt=0,
Description=
- (SELECT p.NAME || ' ' || C_INVOICELINE.Description
+ (SELECT p.NAME || ' ' ||
COALESCE(TO_CHAR(C_INVOICELINE.Description), '')
FROM M_PRODUCT p
WHERE p.M_Product_ID=CUR_BOM_Line.M_Product_ID
),
diff -r 9f2e21bb3583 -r 62df562c95c7
src-db/database/model/functions/C_ORDER_POST1.xml
--- a/src-db/database/model/functions/C_ORDER_POST1.xml Wed Dec 26 12:07:36
2012 +0100
+++ b/src-db/database/model/functions/C_ORDER_POST1.xml Wed Dec 26 16:44:06
2012 +0100
@@ -1055,7 +1055,7 @@
FreightAmt=0,
ChargeAmt=0,
Description=
- (SELECT p.NAME || ' ' || COALESCE(C_ORDERLINE.Description,
'')
+ (SELECT p.NAME || ' ' ||
COALESCE(TO_CHAR(C_ORDERLINE.Description), '')
FROM M_PRODUCT p
WHERE p.M_Product_ID=CUR_BOM_Line.M_Product_ID
)
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
