details: /erp/devel/pi/rev/5b8be92551f9
changeset: 10209:5b8be92551f9
user: David Alsasua <david.alsasua <at> openbravo.com>
date: Fri Jan 28 16:41:41 2011 +0100
summary: Fixes issue 15614: error when posting an invoice.
This is a bug introduced in the financial invoices project: an scenario that
was not taken into account: Group Invoice Lines in Accounting flag active
diffstat:
src/org/openbravo/erpCommon/ad_forms/DocLineInvoice_data.xsql | 12 +++++-----
1 files changed, 6 insertions(+), 6 deletions(-)
diffs (29 lines):
diff -r 2930139a4177 -r 5b8be92551f9
src/org/openbravo/erpCommon/ad_forms/DocLineInvoice_data.xsql
--- a/src/org/openbravo/erpCommon/ad_forms/DocLineInvoice_data.xsql Fri Jan
28 16:25:36 2011 +0100
+++ b/src/org/openbravo/erpCommon/ad_forms/DocLineInvoice_data.xsql Fri Jan
28 16:41:41 2011 +0100
@@ -51,10 +51,10 @@
C_INVOICELINE.AD_ORG_ID, C_INVOICELINE.ISACTIVE,
C_INVOICELINE.C_INVOICE_ID,
MAX(C_INVOICELINE.C_ORDERLINE_ID) AS C_ORDERLINE_ID,
MAX(C_INVOICELINE.M_INOUTLINE_ID) AS M_INOUTLINE_ID,
MAX(C_INVOICELINE.LINE) AS LINE, MAX(C_INVOICELINE.DESCRIPTION) AS
DESCRIPTION, C_INVOICELINE.M_PRODUCT_ID,
- SUM(C_INVOICELINE.QTYINVOICED) AS QTYINVOICED,
C_INVOICELINE.PRICELIST, C_INVOICELINE.PRICEACTUAL,
- C_INVOICELINE.PRICELIMIT,
SUM(COALESCE(C_INVOICELINE_ACCTDIMENSION.AMT, C_INVOICELINE.LINENETAMT)) AS
LINENETAMT, MAX(C_INVOICELINE.C_CHARGE_ID) AS C_CHARGE_ID,
- SUM(C_INVOICELINE.CHARGEAMT) AS CHARGEAMT, C_INVOICELINE.C_UOM_ID, ''
as C_TAX_ID,
- C_INVOICELINE.S_RESOURCEASSIGNMENT_ID, SUM(C_INVOICELINE.TAXAMT) AS
TAXAMT,
+ C_INVOICELINE.ACCOUNT_ID AS M_C_GLITEM_ID,
SUM(C_INVOICELINE.QTYINVOICED) AS QTYINVOICED, C_INVOICELINE.PRICELIST,
+ C_INVOICELINE.PRICEACTUAL, C_INVOICELINE.PRICELIMIT,
SUM(COALESCE(C_INVOICELINE_ACCTDIMENSION.AMT, C_INVOICELINE.LINENETAMT))
+ AS LINENETAMT, MAX(C_INVOICELINE.C_CHARGE_ID) AS C_CHARGE_ID,
SUM(C_INVOICELINE.CHARGEAMT) AS CHARGEAMT,
+ C_INVOICELINE.C_UOM_ID, '' as C_TAX_ID,
C_INVOICELINE.S_RESOURCEASSIGNMENT_ID, SUM(C_INVOICELINE.TAXAMT) AS TAXAMT,
C_INVOICELINE.M_ATTRIBUTESETINSTANCE_ID,
C_INVOICELINE.ISDESCRIPTION, SUM(C_INVOICELINE.QUANTITYORDER) AS
QUANTITYORDER, C_INVOICELINE.M_PRODUCT_UOM_ID,
C_INVOICELINE_ACCTDIMENSION.C_CAMPAIGN_ID,
C_INVOICELINE_ACCTDIMENSION.C_PROJECT_ID,
@@ -62,8 +62,8 @@
FROM C_INVOICELINE left join C_INVOICELINE_ACCTDIMENSION on
C_INVOICELINE.C_INVOICELINE_ID = C_INVOICELINE_ACCTDIMENSION.C_INVOICELINE_ID
WHERE C_INVOICELINE.C_INVOICE_ID = ?
GROUP BY C_INVOICELINE.AD_CLIENT_ID, C_INVOICELINE.AD_ORG_ID,
C_INVOICELINE.ISACTIVE, C_INVOICELINE.C_INVOICE_ID,
- C_INVOICELINE.M_PRODUCT_ID,C_INVOICELINE.PRICELIST,
C_INVOICELINE.PRICEACTUAL, C_INVOICELINE.PRICELIMIT,
- C_INVOICELINE.C_UOM_ID, C_INVOICELINE.C_TAX_ID,
C_INVOICELINE.S_RESOURCEASSIGNMENT_ID,
+ C_INVOICELINE.M_PRODUCT_ID, C_INVOICELINE.ACCOUNT_ID,
C_INVOICELINE.PRICELIST, C_INVOICELINE.PRICEACTUAL,
+ C_INVOICELINE.PRICELIMIT, C_INVOICELINE.C_UOM_ID,
C_INVOICELINE.C_TAX_ID, C_INVOICELINE.S_RESOURCEASSIGNMENT_ID,
C_INVOICELINE.M_ATTRIBUTESETINSTANCE_ID,C_INVOICELINE.ISDESCRIPTION,
C_INVOICELINE.M_PRODUCT_UOM_ID,
C_INVOICELINE_ACCTDIMENSION.C_CAMPAIGN_ID,
C_INVOICELINE_ACCTDIMENSION.C_PROJECT_ID,
C_INVOICELINE_ACCTDIMENSION.USER1_ID,
C_INVOICELINE_ACCTDIMENSION.USER2_ID
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
