details: https://code.openbravo.com/erp/devel/pi/rev/f80e9950e5af
changeset: 19108:f80e9950e5af
user: Ioritz Cia <ioritz.cia <at> openbravo.com>
date: Wed Dec 26 12:37:19 2012 +0100
summary: Fixes issue 21998: After completing a sales order/invoice the BOM
product does not appear.
diffstat:
src-db/database/model/functions/C_ORDER_POST1.xml | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r a9605441d9c9 -r f80e9950e5af
src-db/database/model/functions/C_ORDER_POST1.xml
--- a/src-db/database/model/functions/C_ORDER_POST1.xml Wed Dec 26 12:46:11
2012 +0530
+++ b/src-db/database/model/functions/C_ORDER_POST1.xml Wed Dec 26 12:37:19
2012 +0100
@@ -1055,7 +1055,7 @@
FreightAmt=0,
ChargeAmt=0,
Description=
- (SELECT p.NAME || ' ' || C_ORDERLINE.Description
+ (SELECT p.NAME || ' ' || COALESCE(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
