Attachment #86974 for bug #21622

View | Details | Raw Unified | Return to bug 21622
Collapse All | Expand All

Lines 77-83 WHERE Link Here

(-)a/acqui/ordered.pl (-1 / +1 lines)
77	(quantity > quantityreceived OR quantityreceived IS NULL)	77	(quantity > quantityreceived OR quantityreceived IS NULL)
78	GROUP BY aqorders.biblionumber, aqorders.basketno, aqorders.ordernumber,	78	GROUP BY aqorders.biblionumber, aqorders.basketno, aqorders.ordernumber,
79	tleft,	79	tleft,
80	ecost, budgetdate, entrydate,	80	ecost_tax_included, budgetdate, entrydate,
81	aqbasket.booksellerid,	81	aqbasket.booksellerid,
82	aqbooksellers.name,	82	aqbooksellers.name,
83	itype,	83	itype,




    datereceived IS NOT NULL
    GROUP BY aqorders.biblionumber, aqorders.basketno, aqorders.ordernumber,
             tleft,
             budgetdate, entrydate,
             aqbasket.booksellerid,
             itype,
             title,
             aqorders.invoiceid,
             aqinvoices.invoicenumber,
             quantityreceived,
             unitprice_tax_included,
             datereceived,
             aqbooksellers.name

- 

Return to bug 21622

Lines 86-99 WHERE Link Here

(-)a/acqui/spent.pl (-3 / +2 lines)
86	datereceived IS NOT NULL	86	datereceived IS NOT NULL
87	GROUP BY aqorders.biblionumber, aqorders.basketno, aqorders.ordernumber,	87	GROUP BY aqorders.biblionumber, aqorders.basketno, aqorders.ordernumber,
88	tleft,	88	tleft,
89	ecost, budgetdate, entrydate,	89	budgetdate, entrydate,
90	aqbasket.booksellerid,	90	aqbasket.booksellerid,
91	itype,	91	itype,
92	title,	92	title,
93	aqorders.invoiceid,	93	aqorders.invoiceid,
94	aqinvoices.invoicenumber,	94	aqinvoices.invoicenumber,
95	quantityreceived,	95	quantityreceived,
96	unitprice,	96	unitprice_tax_included,
97	datereceived,	97	datereceived,
98	aqbooksellers.name	98	aqbooksellers.name
99		99
100	-