@@ -, +, @@ 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() {

Invoices

[% IF ( do_search ) %] [% IF invoices %] + + @@ -52,6 +68,7 @@ $(document).ready(function() { [% FOREACH invoice IN invoices %] +
Subscriptionid Invoice no. Vendor Billing date
[% invoice.subscriptionid %] [% invoice.invoicenumber %] [% invoice.suppliername %] --