[Koha-bugs] [Bug 1112] Can't receive orders in budget-based acquisitions

[bugzilla-daemon at wilbur.katipo.co.nz]

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1112





------- Comment #7 from paul.poulain at free.fr  2006-08-04 01:07 -------
mmm... seems you have 2 problems :
- on receive.pl : you should have a list of pending orders (in default
templates) jsut after the "0 lines". You don't have any (even if I just created
a new basket, (criptonomicon, author paul poulain)
Could you look at : Acquisition.pm::getallorders (line 606) and see if you have
:
	my $strsth ="Select authorisedby,creationdate,aqbasket.basketno,
closedate,surname,firstname,aqorders.biblionumber,aqorders.title,aqorders.author,aqorders.isbn,
aqorders.ordernumber, quantity, quantityreceived
from aqorders 
left join aqbasket on aqbasket.basketno=aqorders.basketno 
left join borrowers on aqbasket.authorisedby=borrowers.borrowernumber
where booksellerid=? and (quantity > quantityreceived or
quantityreceived is NULL) and datecancellationprinted is NULL ";

does this query fail, and if yes, where ? It should return the list of pending
orders.

- when you search a biblio manually, you should not reach a page with "Edit". I
investigate & let you know asap.




------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.