details: /erp/devel/pi/rev/2c0b028e7372
changeset: 7452:2c0b028e7372
user: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
date: Mon May 31 17:15:48 2010 +0530
summary: Fixes issue 12587 while clicking copy lines their error processing
failed.This is because in pgsql the amount is inserted as string.Now this is
fixed.
diffstat:
src/org/openbravo/erpCommon/ad_actionButton/CopyFromInvoice_data.xsql | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diffs (12 lines):
diff -r b6ab6043ab92 -r 2c0b028e7372
src/org/openbravo/erpCommon/ad_actionButton/CopyFromInvoice_data.xsql
--- a/src/org/openbravo/erpCommon/ad_actionButton/CopyFromInvoice_data.xsql
Sat May 29 09:38:32 2010 +0200
+++ b/src/org/openbravo/erpCommon/ad_actionButton/CopyFromInvoice_data.xsql
Mon May 31 17:15:48 2010 +0530
@@ -55,7 +55,7 @@
PRICESTD)
SELECT ?, ?, ?, ?, 'Y', now(), ?, now(), ?,
(SELECT COALESCE(MAX(LINE),0)+10 FROM C_InvoiceLine WHERE
C_InvoiceLine_ID = ?), DESCRIPTION, M_PRODUCT_ID,
- QTYINVOICED, ?, ?, ?, ?, C_CHARGE_ID, CHARGEAMT, C_UOM_ID, ?,
+ QTYINVOICED, TO_NUMBER(?), TO_NUMBER(?), TO_NUMBER(?), TO_NUMBER(?),
C_CHARGE_ID, CHARGEAMT, C_UOM_ID, ?,
S_RESOURCEASSIGNMENT_ID, TAXAMT, M_ATTRIBUTESETINSTANCE_ID,
ISDESCRIPTION, QUANTITYORDER, M_PRODUCT_UOM_ID,
PRICESTD
FROM C_INVOICELINE
------------------------------------------------------------------------------
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
