Author: danydb
Date: 2012-12-06 21:43:22 +0100 (Thu, 06 Dec 2012)
New Revision: 5159
Modified:
phpcompta/tags/rel650/include/class_acc_ledger.php
Log:
Bug : the history doesn't show the first_name for VEN
Modified: phpcompta/tags/rel650/include/class_acc_ledger.php
===================================================================
--- phpcompta/tags/rel650/include/class_acc_ledger.php 2012-12-06 20:42:51 UTC
(rev 5158)
+++ phpcompta/tags/rel650/include/class_acc_ledger.php 2012-12-06 20:43:22 UTC
(rev 5159)
@@ -2528,7 +2528,7 @@
and f_id=(select qf_other from quant_fin where
quant_fin.jr_id=x.jr_id))
end as name,
case
- when jrn_def_type='VEB' then (select ad_value from fiche_detail
where ad_id=32 and f_id=(select max(qs_client) from quant_sold join jrnx using
(j_id) join jrn as e on (e.jr_grpt_id=j_grpt) where e.jr_id=x.jr_id))
+ when jrn_def_type='VEN' then (select ad_value from fiche_detail
where ad_id=32 and f_id=(select max(qs_client) from quant_sold join jrnx using
(j_id) join jrn as e on (e.jr_grpt_id=j_grpt) where e.jr_id=x.jr_id))
when jrn_def_type = 'ACH' then (select ad_value from fiche_detail
where ad_id=32 and f_id=(select max(qp_supplier) from quant_purchase join jrnx
using (j_id) join jrn as e on (e.jr_grpt_id=j_grpt) where e.jr_id=x.jr_id))
when jrn_def_type = 'FIN' then (select ad_value from fiche_detail
where ad_id=32 and f_id=(select qf_other from quant_fin where
quant_fin.jr_id=x.jr_id))
end as first_name,
---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu
_______________________________________________
Phpcompta est un logiciel libre de comptabilité en ligne
(http://www.phpcompta.eu)
Phpcompta-dev mailing list
[email protected]
https://lists.nongnu.org/mailman/listinfo/phpcompta-dev
