[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r4595 - phpcompta/trunk/html/admin/sql/patch
From: |
phpcompta-dev |
Subject: |
[Phpcompta-dev] r4595 - phpcompta/trunk/html/admin/sql/patch |
Date: |
Fri, 9 Dec 2011 23:35:48 +0100 (CET) |
Author: danydb
Date: 2011-12-09 23:35:45 +0100 (Fri, 09 Dec 2011)
New Revision: 4595
Modified:
phpcompta/trunk/html/admin/sql/patch/upgrade99.sql
Log:
Bug in negativ
Modified: phpcompta/trunk/html/admin/sql/patch/upgrade99.sql
===================================================================
--- phpcompta/trunk/html/admin/sql/patch/upgrade99.sql 2011-12-09 15:07:40 UTC
(rev 4594)
+++ phpcompta/trunk/html/admin/sql/patch/upgrade99.sql 2011-12-09 22:35:45 UTC
(rev 4595)
@@ -28,14 +28,14 @@
delete from profile_menu where p_id=2 and me_code_dep='DIVPARM';
delete from profile_menu where p_id=2 and me_code_dep='MOD';
-update quant_sold set qs_price=(-1)*qs_price, qs_vat=(-1)*qs_vat where
qs_quantite > 0 and qs_price > 0 and qs_vat >= 0;
+update quant_sold set qs_price=(-1)*qs_price, qs_vat=(-1)*qs_vat where
qs_quantite < 0 and qs_price > 0 and qs_vat >= 0;
update quant_purchase set qp_price=(-1)*qp_price, qp_vat=(-1)*qp_vat,
qp_nd_amount=(-1)*qp_nd_amount,
qp_nd_tva=(-1)*qp_nd_tva,
qp_nd_tva_recup=(-1)*qp_nd_tva_recup,
qp_dep_priv=(-1)*qp_dep_priv
-where qp_quantite > 0 and qp_price > 0 and qp_vat >= 0;
+where qp_quantite < 0 and qp_price > 0 and qp_vat >= 0;
update version set val=100;
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r4595 - phpcompta/trunk/html/admin/sql/patch,
phpcompta-dev <=