details: https://code.openbravo.com/erp/devel/pi/rev/51d554721fb7 changeset: 14026:51d554721fb7 user: Javier Etxarri <javier.echarri <at> openbravo.com> date: Wed Oct 19 11:03:59 2011 +0200 summary: issue 18464: Not possible to create a goods receipt for a product that is not stocked. Properly exported now
diffstat: src-db/database/model/views/M_PRODUCT_STOCK_V.xml | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diffs (14 lines): diff -r f5cb1a5fbecd -r 51d554721fb7 src-db/database/model/views/M_PRODUCT_STOCK_V.xml --- a/src-db/database/model/views/M_PRODUCT_STOCK_V.xml Wed Oct 19 10:38:21 2011 +0200 +++ b/src-db/database/model/views/M_PRODUCT_STOCK_V.xml Wed Oct 19 11:03:59 2011 +0200 @@ -5,8 +5,8 @@ JOIN m_locator l ON sd.m_locator_id = l.m_locator_id JOIN m_product p ON sd.m_product_id = p.m_product_id AND p.isactive = 'Y' WHERE sd.qtyonhand <> 0 OR COALESCE(sd.qtyorderonhand, 0) <> 0 -UNION ALL -SELECT p.m_product_id AS m_product_stock_v_id, p.ad_client_id, p.ad_org_id, p.isactive, p.created, p.createdby, p.updated, p.updatedby, p.m_product_id, 0 AS qtyonhand, NULL AS qtyorderonhand, 0 AS preqtyonhand, NULL AS preqtyorderonhand, p.c_uom_id, NULL AS m_product_uom_id, +UNION ALL +SELECT p.m_product_id AS m_product_stock_v_id, p.ad_client_id, p.ad_org_id, p.isactive, p.created, p.createdby, p.updated, p.updatedby, p.m_product_id, 0 AS qtyonhand, NULL AS qtyorderonhand, 0 AS preqtyonhand, NULL AS preqtyorderonhand, p.c_uom_id, NULL AS m_product_uom_id, CASE p.attrsetvaluetype WHEN 'D' THEN p.m_attributesetinstance_id ELSE NULL ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2d-oct _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
