A separate invoice table which links to the aqorders table via the order number to search against order numbers and pull up the related invoice to see when the item was receipted in
Amit, have you checked 3.10+? We have an invoices table now that stores all information about the invoice itself and links to aqorders table.
Hi Katrin, Yes i know i am adding only orderline and datereceived filter.
There is bug in GetInvoices subroutine (branchcode field is not in aqorders table).
Sorry for the misunderstanding :) I think there is a patch pending somewhere to add this column, but I am not sure about the bug. Adding Jonathan to this bug in CC, maybe he knows as this is probably a Biblibre development. There is also a bug report about the filters in invoices not working correctly: bug 8854
The aqorders.branchcode is added by Bug 5336 - Acq history search (needs QA)
Cool, thx Jonathan!
Created attachment 19209 [details] [review] Search received orders Search against order numbers and pull up the related invoice to see when the item was received. This allows users to see details of received orders, including the details against which invoice the order is received. Test Plan: 1) Create a basket. 2) Create a orders under basket and close the basket. 3) Click on Receive shipment button and enter the invoice no and shipment date. 4) Click on Receive link to receive the items. 5) Click on Received orders link on the left hand side. 6) This allow user to search by orderline, basket, title, author, ISBN, vendor and date received. 7) Users will be able to see details of received orders.
Created attachment 19955 [details] [review] [SIGNED-OFF] Bug 10424 - Search received orders Search against order numbers and pull up the related invoice to see when the item was received. This allows users to see details of received orders, including the details against which invoice the order is received. Test Plan: 1) Create a basket. 2) Create a orders under basket and close the basket. 3) Click on Receive shipment button and enter the invoice no and shipment date. 4) Click on Receive link to receive the items. 5) Click on Received orders link on the left hand side. 6) This allow user to search by orderline, basket, title, author, ISBN, vendor and date received. 7) Users will be able to see details of received orders. Sponsored-by: Staffordshire University/Halton Borough Council/PTFS Europe Signed-off-by: Srdjan <srdjan@catalyst.net.nz>
Hi Amit, there are a couple of small things: It was decided a while ago that Koha will be distributed under GPL3+ - we have upated the coding guidelines with the appropriate license text: http://wiki.koha-community.org/wiki/Coding_Guidelines#Licence Could you confirm this is ok for you and if so change receivedorders.pl accordingly? Also, could you please add some unit tests for your new routines? GetReceivedorder (maybe ReceivedOrder?) You can add a follow up and switch the status back to signed off.
Created attachment 22033 [details] [review] Search Received order Hi Katrin, I have change the Licence. Search against order numbers and pull up the related invoice to see when the item was received. This allows users to see details of received orders, including the details against which invoice the order is received. Test Plan: 1) Create a basket. 2) Create a orders under basket and close the basket. 3) Click on Receive shipment button and enter the invoice no and shipment date. 4) Click on Receive link to receive the items. 5) Click on Received orders link on the left hand side. 6) This allow user to search by orderline, basket, title, author, ISBN, vendor and date received. 7) Users will be able to see details of received orders.
Applying: Bug 10424 - Search received orders Using index info to reconstruct a base tree... M C4/Acquisition.pm Falling back to patching base and 3-way merge... Auto-merging C4/Acquisition.pm CONFLICT (content): Merge conflict in C4/Acquisition.pm Patch failed at 0001 Bug 10424 - Search received orders The copy of the patch that failed is found in: /home/christopher/git/koha/.git/rebase-apply/patch When you have resolved this problem, run "git am --continue". If you prefer to skip this patch, run "git am --skip" instead. To restore the original branch and stop patching, run "git am --abort".
Created attachment 37500 [details] [review] Bug 10424 - Search received orders Search against order numbers and pull up the related invoice to see when the item was received. This allows users to see details of received orders, including the details against which invoice the order is received. Test Plan: 1) Create a basket. 2) Create a orders under basket and close the basket. 3) Click on Receive shipment button and enter the invoice no and shipment date. 4) Click on Receive link to receive the items. 5) Click on Received orders link on the left hand side. 6) This allow user to search by orderline, basket, title, author, ISBN, vendor and date received. 7) Users will be able to see details of received orders.
You can't sign off your own patch, Amit. :) I have rescued this. It was a simple enough fix. I have not tested it. See the test plan provided in comment #12.
With Test Plan: I Created a basket. I Created a orders under basket and closed the basket. I Clicked on Receive shipment button and entered the invoice no and shipment date. I Clicked on Receive link to receive the items. I Clicked on Received orders link on the left hand side. Then, a message appeared, at this link : http://pro.test14.biblibre.com/cgi-bin/koha/acqui/receivedorders.pl Software error: Can't locate C4/Dates.pm in @INC (@INC contains: /home/koha/src /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl .) at /home/koha/src/acqui/receivedorders.pl line 57. BEGIN failed--compilation aborted at /home/koha/src/acqui/receivedorders.pl line 57. For help, please send mail to the webmaster (webmaster@matrice-koha36-sandbox), giving this error message and the time and date of the error.
What's the point of this new page? You can search for received orders from the orders search form.