details: http://code.openbravo.com/erp/devel/pi/rev/f1b414448f56 changeset: 3261:f1b414448f56 user: David Abragimov <david.abragi...@opensuite.com> date: Fri Feb 27 16:25:46 2009 +0200 description: Bug fixed 0007710: Purchase order doc no wrongly displayed under Shipment/Receipt cloumn when invoice lines are created using 'create lines from'
diffs (12 lines): diff -r 84d234ec2d88 -r f1b414448f56 src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql --- a/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql Fri Feb 27 16:22:09 2009 +0200 +++ b/src/org/openbravo/erpCommon/ad_actionButton/CreateFrom_Invoice_data.xsql Fri Feb 27 16:25:46 2009 +0200 @@ -28,7 +28,7 @@ <Sql> <![CDATA[ SELECT o.C_ORDER_ID as ID, Ad_Column_Identifier(to_char('C_Order'), to_char(o.c_order_id), to_char(?)) AS NAME, o.DocumentNo AS NAMEORDER, - o.DocumentNo AS NAMESHIPMENT, + '' AS NAMESHIPMENT, l.QtyOrdered-SUM(COALESCE(m.Qty,0)) AS QTY, l.C_UOM_ID,uom.UOMSymbol, l.M_Product_ID,p.NAME AS RELATION_NAME, l.C_OrderLine_ID,l.Line, l.ad_org_id, '' as STDPRECISION, '' as M_InOutLine_ID, '' AS PriceActual, '' AS PriceList, '' AS PriceLimit, '' AS Description, '' as PriceStd, ------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits