[Koha-bugs] [Bug 27629] Filter invoices by library in invoices.pl

2023-01-23 Thread bugzilla-daemon
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

2023-01-23 Thread bugzilla-daemon
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

2021-04-09 Thread bugzilla-daemon
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

2021-02-08 Thread bugzilla-daemon
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

2021-02-08 Thread bugzilla-daemon
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

2021-02-08 Thread bugzilla-daemon
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

2021-02-06 Thread bugzilla-daemon
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

2021-02-05 Thread bugzilla-daemon
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/