projects
/
kivitendo-erp.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Artikel-Controller: Workflow zu Lieferantenauftrag
[kivitendo-erp.git]
/
SL
/
USTVA.pm
diff --git
a/SL/USTVA.pm
b/SL/USTVA.pm
index
22d12ce
..
ee2d21f
100644
(file)
--- a/
SL/USTVA.pm
+++ b/
SL/USTVA.pm
@@
-26,6
+26,7
@@
package USTVA;
package USTVA;
+use Carp;
use Data::Dumper;
use List::Util qw(first);
use Data::Dumper;
use List::Util qw(first);
@@
-33,6
+34,7
@@
use SL::DB;
use SL::DBUtils;
use SL::DB::Default;
use SL::DB::Finanzamt;
use SL::DBUtils;
use SL::DB::Default;
use SL::DB::Finanzamt;
+use SL::Locale::String qw(t8);
use utf8;
use strict;
use utf8;
use strict;
@@
-691,7
+693,7
@@
sub get_accounts_ustva {
SUM( ac.amount *
-- Bezahlt / Rechnungssumme
(
SUM( ac.amount *
-- Bezahlt / Rechnungssumme
(
- SELECT SUM(acc.amount)
, t.rate, c.accno
+ SELECT SUM(acc.amount)
FROM acc_trans acc
INNER JOIN chart c ON (acc.chart_id = c.id
AND c.link like '%AR_paid%')
FROM acc_trans acc
INNER JOIN chart c ON (acc.chart_id = c.id
AND c.link like '%AR_paid%')
@@
-699,13
+701,12
@@
sub get_accounts_ustva {
1=1
$ARwhere
AND acc.trans_id = ac.trans_id
1=1
$ARwhere
AND acc.trans_id = ac.trans_id
- )
- /
+ ) /
(
SELECT amount FROM ar WHERE id = ac.trans_id
)
) AS amount,
(
SELECT amount FROM ar WHERE id = ac.trans_id
)
) AS amount,
- tk.pos_ustva
+ tk.pos_ustva
, t.rate, c.accno
FROM acc_trans ac
LEFT JOIN chart c ON (c.id = ac.chart_id)
LEFT JOIN ar ON (ar.id = ac.trans_id)
FROM acc_trans ac
LEFT JOIN chart c ON (c.id = ac.chart_id)
LEFT JOIN ar ON (ar.id = ac.trans_id)