[Koha-bugs] [Bug 27629] Filter invoices by library in invoices.pl
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27629 Katrin Fischer changed: What|Removed |Added Status|ASSIGNED|NEW -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27629] Filter invoices by library in invoices.pl
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27629 Katrin Fischer changed: What|Removed |Added Status|In Discussion |ASSIGNED --- Comment #6 from Katrin Fischer --- Could we maybe do both, a search option for managing library or a fallback on managing library for the search option? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27629] Filter invoices by library in invoices.pl
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27629 Clodagh Kerin changed: What|Removed |Added CC||clodagh.ke...@educampus.ie -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27629] Filter invoices by library in invoices.pl
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27629 --- Comment #5 from Daphne Hoolahan --- Managing Library might be more straightforward but my problem is arising on baskets created from EDI Quotes or the GOBI API so either way we are going to be dependent on data supplied by the vendor or an update when the basket is created. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27629] Filter invoices by library in invoices.pl
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27629 --- Comment #4 from Katrin Fischer --- Hm, the managing library was introduced later - which could explain why it was not used in the first place. In my experience libraries often forget to set it, but it would be more reliable in this case. Daphne, would it work for your data? The meaning of authorised_by in several places has led us to migrate with a migration acq user for a valid borrowernumber, which helps, but is not a real good solution. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27629] Filter invoices by library in invoices.pl
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27629 Jonathan Druart changed: What|Removed |Added Version|19.11 |master Status|NEW |In Discussion CC||katrin.fisc...@bsz-bw.de --- Comment #3 from Jonathan Druart --- When the "library" filter on the invoice page is set, a JOIN is done on the borrowers table using the branchcode of this patron. And aqbasket.authorisedby is the borrowernumber of the librarian who created the basket. BUT if the patron is removed, the column will be set to NULL, and the JOIN will not return the invoices created by this (now deleted) patron. There is a "Managing library" (aqbasket.branch) at basket level, maybe we should use it instead of borrowers.branchcode. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27629] Filter invoices by library in invoices.pl
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27629 --- Comment #2 from Daphne Hoolahan --- The missing invoices are all linked to a basket. Baskets have authorisedby column = 0. What is the significance of authorisedby for this filter? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 27629] Filter invoices by library in invoices.pl
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27629 Jonathan Druart changed: What|Removed |Added CC||jonathan.dru...@bugs.koha-c ||ommunity.org --- Comment #1 from Jonathan Druart --- Can you confirm the invoices that are missing are linked with a basket that has the authorisedby column not NULL? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/