details: https://code.openbravo.com/erp/devel/pi/rev/b74637d46bc3
changeset: 21132:b74637d46bc3
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Mon Sep 16 17:02:03 2013 +0200
summary: Fixes issue 23919: Pending Goods Receipt should show 'service'
products in order to be consistent with rest of processes
diffstat:
src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending_data.xsql | 4 +---
1 files changed, 1 insertions(+), 3 deletions(-)
diffs (22 lines):
diff -r e6328686436f -r b74637d46bc3
src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending_data.xsql
--- a/src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending_data.xsql
Mon Sep 16 16:38:41 2013 +0200
+++ b/src/org/openbravo/erpCommon/ad_forms/MaterialReceiptPending_data.xsql
Mon Sep 16 17:02:03 2013 +0200
@@ -67,17 +67,15 @@
FROM C_ORDERLINE left join M_MATCHPO on C_ORDERLINE.C_ORDERLINE_ID =
M_MATCHPO.C_ORDERLINE_ID
and M_MATCHPO.M_INOUTLINE_ID IS NOT
NULL
left join M_ATTRIBUTESETINSTANCE on
C_ORDERLINE.M_ATTRIBUTESETINSTANCE_ID =
M_ATTRIBUTESETINSTANCE.M_ATTRIBUTESETINSTANCE_ID,
- C_ORDER, C_BPARTNER, C_DOCTYPE, M_PRODUCT
+ C_ORDER, C_BPARTNER, C_DOCTYPE
WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID
AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID
- AND C_ORDERLINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID
AND C_ORDER.AD_CLIENT_ID IN ('1')
AND C_ORDER.AD_ORG_ID IN ('1')
AND C_ORDER.ISSOTRX='N'
AND C_ORDER.DOCSTATUS = 'CO'
AND C_ORDER.C_DOCTYPE_ID = C_DOCTYPE.C_DOCTYPE_ID
AND C_DOCTYPE.ISRETURN = 'N'
- AND M_PRODUCT.PRODUCTTYPE <> 'S'
GROUP BY C_ORDERLINE.C_ORDERLINE_ID, C_ORDER.C_ORDER_ID,
C_ORDER.DOCUMENTNO, C_ORDER.DATEORDERED, C_BPARTNER.C_BPARTNER_ID,
C_BPARTNER.NAME, C_ORDERLINE.M_PRODUCT_ID,
M_ATTRIBUTESETINSTANCE.DESCRIPTION, C_ORDERLINE.QTYORDERED, C_ORDERLINE.LINE
) A
------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13.
http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
