@@ -, +, @@ invoices table --- C4/Acquisition.pm | 1 + .../prog/en/modules/acqui/invoices.tt | 23 +++++++++++++++++--- 2 files changed, 21 insertions(+), 3 deletions(-) --- a/C4/Acquisition.pm +++ a/C4/Acquisition.pm @@ -2285,6 +2285,7 @@ sub GetInvoices { my $dbh = C4::Context->dbh; my $query = qq{ SELECT aqinvoices.*, aqbooksellers.name AS suppliername, + aqorders.subscriptionid, COUNT( DISTINCT IF( aqorders.datereceived IS NOT NULL, --- a/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/invoices.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/invoices.tt @@ -9,15 +9,26 @@ @@ -37,9 +48,14 @@ $(document).ready(function() {
Subscriptionid | Invoice no. | Vendor | Billing date | @@ -52,6 +68,7 @@ $(document).ready(function() {
---|---|---|---|
[% invoice.subscriptionid %] | [% invoice.invoicenumber %] | [% invoice.suppliername %] | -- |