Bugzilla – Dependency tree for
Bug 22008
accountlines.manager_id is missing a foreign key constraint
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
Max Depth:
Bug 22008
depends on one bug:
view as bug list
22008:
accountlines.manager_id is missing a foreign key constraint
[CLOSED FIXED; assigned to martin.renvoize]
21065:
Data in account_offsets and accountlines is deleted with the patron leaving gaps in financial reports
[CLOSED FIXED; assigned to jonathan.druart]
Bug 22008
blocks 148 bugs:
view as bug list
22008:
accountlines.manager_id is missing a foreign key constraint
[CLOSED FIXED; assigned to martin.renvoize]
7811:
borrowers.borrowernumber should be a foreign key for 8 tables
[RESOLVED MOVED; assigned to martin.renvoize]
5334:
Omnibus: Add explicit foreign key constraints
[NEW; assigned to gmcharlt]
22593:
Cronjobs/Scripts dealing with accountlines need updating for bug 22008
[CLOSED FIXED; assigned to martin.renvoize]
22518:
accounttype 'O' is still referred to but is never set
[CLOSED FIXED; assigned to martin.renvoize]
22512:
accountlines.accountype mixes 'state' and 'type'
[CLOSED FIXED; assigned to martin.renvoize]
8338:
Add ability to remove fines with dropbox mode
[CLOSED FIXED; assigned to martin.renvoize]
14825:
Accounts Rewrite Omnibus
[NEW; assigned to kyle.m.hall]
28097:
t/db_dependent/Koha/Account/Line.t test fails with FinesMode set to calculate
[CLOSED FIXED; assigned to martin.renvoize]
22600:
We should add an 'interface' field to accountlines
[CLOSED FIXED; assigned to martin.renvoize]
22521:
Convert fines handling to use 'status' instead of two accounttypes
[CLOSED FIXED; assigned to martin.renvoize]
22519:
We have two accounttypes for "forgiven", 'FOR' and 'FFOR'
[RESOLVED DUPLICATE; assigned to martin.renvoize]
22564:
accounttype 'Rep' is still referred to but is never set
[CLOSED FIXED; assigned to martin.renvoize]
22737:
Restore patron replacement process for lost items
[NEW; assigned to koha-bugs]
22511:
Koha::Account::Line->void loses the original type of the credit
[CLOSED FIXED; assigned to martin.renvoize]
22200:
Forgiving a fine (FOR) does not create a FORGIVEN credit line
[CLOSED FIXED; assigned to martin.renvoize]
22563:
Convert lost handling to use 'status' instead of multiple accounttypes
[CLOSED FIXED; assigned to martin.renvoize]
19919:
Writing off a Lost Item Fee marks as "Paid for by patron"
[CLOSED FIXED; assigned to martin.renvoize]
11573:
Fine descriptions related to Rentals are untranslatable
[CLOSED FIXED; assigned to martin.renvoize]
6759:
Use a different account type for account renewals than for new accounts
[CLOSED FIXED; assigned to martin.renvoize]
23321:
Add 'cash registers' to the accounts system
[CLOSED FIXED; assigned to martin.renvoize]
23049:
Replace MANUAL_INV authorised value with a dedicated table
[CLOSED FIXED; assigned to martin.renvoize]
21739:
'Copier fees' should not be used as accounttype on maninvoice.pl
[CLOSED FIXED; assigned to tomascohen]
22393:
Remove last remaining manualinvoice use
[CLOSED FIXED; assigned to martin.renvoize]
22394:
Remove C4::Accounts::manualinvoice
[CLOSED FIXED; assigned to martin.renvoize]
22510:
'accountlines.accounttype' should never be set directly, rather is should be changed via Koha::Account et al.
[CLOSED FIXED; assigned to martin.renvoize]
14825:
Accounts Rewrite Omnibus
[NEW; assigned to kyle.m.hall]
(*)
23805:
Add a dedicated credit_types table
[CLOSED FIXED; assigned to martin.renvoize]
17702:
Create configuration for account credit types
[CLOSED FIXED; assigned to julian.maurice]
23894:
accountlines.payment_type and accountlines.credit_type should be merged
[NEW; assigned to koha-bugs]
14825:
Accounts Rewrite Omnibus
[NEW; assigned to kyle.m.hall]
(*)
24080:
Add a 'payout' process to accounts
[CLOSED FIXED; assigned to martin.renvoize]
24252:
Add credits, debits, credit_offsets and debit_offsets relationships to Koha::Account::Line
[CLOSED FIXED; assigned to martin.renvoize]
8338:
Add ability to remove fines with dropbox mode
[CLOSED FIXED; assigned to martin.renvoize]
(*)
24255:
Add totals methods Koha::Account::Lines
[CLOSED FIXED; assigned to martin.renvoize]
23442:
Add a 'refund' process to accounts
[CLOSED FIXED; assigned to martin.renvoize]
24849:
Permissions checks are missing in borracount controller
[NEW; assigned to martin.renvoize]
14825:
Accounts Rewrite Omnibus
[NEW; assigned to kyle.m.hall]
(*)
23354:
Add a 'Point of sale' screen to allow anonymous payments
[CLOSED FIXED; assigned to martin.renvoize]
24491:
Add filters to debit types interface
[ASSIGNED; assigned to jake.deery]
13985:
[Omnibus] Cash Management - Koha as 'Point of Sale'
[NEW; assigned to martin.renvoize]
23046:
Add tax handling to accounts
[NEW; assigned to koha-bugs]
27780:
Add ability to set a customised default sort order for sale items
[NEW; assigned to koha-bugs]
27791:
Add 'fixed price' and 'variable price' options to debit types
[NEW; assigned to martin.renvoize]
27804:
Convert register transactions table to a single ajax driven datatable
[NEW; assigned to koha-bugs]
28192:
Archived credit/debit types should be filtered by default
[NEW; assigned to isobel.graham09]
30619:
Add the option to email receipts as an alternative to printing
[CLOSED FIXED; assigned to isobel.graham09]
28599:
Add ability to void purchase in point of sale
[NEW; assigned to koha-bugs]
36029:
Add the ability to backdate a transaction in POS
[NEW; assigned to koha-bugs]
24477:
No permissions check for POS feature
[CLOSED FIXED; assigned to martin.renvoize]
23355:
Add a 'cashup' process to accounts
[CLOSED FIXED; assigned to martin.renvoize]
24082:
Add a 'refund' option to anonymous payments
[CLOSED FIXED; assigned to martin.renvoize]
24492:
Add a 'library cashup' workflow to the point of sale system
[CLOSED FIXED; assigned to martin.renvoize]
26172:
Add a cashup summary view (with option to print)
[CLOSED FIXED; assigned to martin.renvoize]
26690:
Constraints for cash management tables need reconsidering
[NEW; assigned to koha-bugs]
26274:
Expose cash register cashup summaries via an API route.
[CLOSED FIXED; assigned to martin.renvoize]
31946:
Wrong permission bit in tests
[NEW; assigned to chris]
36493:
Test for GET /api/v1/cash_registers/:cash_register_id/cashups is fragile
[Pushed to oldstable; assigned to tomascohen]
26272:
Allow cashup summaries to be displayed from the library summary page
[CLOSED FIXED; assigned to martin.renvoize]
27779:
Cashup summary 'refunds' should denote what the refund was actioned against
[Needs documenting; assigned to martin.renvoize]
13985:
[Omnibus] Cash Management - Koha as 'Point of Sale'
[NEW; assigned to martin.renvoize]
(*)
26273:
Expose cashup summary history for a cash register
[CLOSED FIXED; assigned to martin.renvoize]
27779:
Cashup summary 'refunds' should denote what the refund was actioned against
[Needs documenting; assigned to martin.renvoize]
(*)
26676:
Add a way to see details on past cash-ups
[RESOLVED DUPLICATE; assigned to koha-bugs]
26677:
Make summary view and print option for cashups visible on more pages
[RESOLVED DUPLICATE; assigned to koha-bugs]
26938:
Prevent flash of unstyled content on sales table
[CLOSED FIXED; assigned to martin.renvoize]
26939:
Account payment_type in the cash register details page should use description instead of code
[CLOSED FIXED; assigned to martin.renvoize]
13985:
[Omnibus] Cash Management - Koha as 'Point of Sale'
[NEW; assigned to martin.renvoize]
(*)
28266:
Misspelled word: recieved in cashup confirmation pop-up
[CLOSED FIXED; assigned to esther.melander]
24792:
Cash register 'cashup' functionality should be available without 'Point of Sale'
[RESOLVED DUPLICATE; assigned to martin.renvoize]
24815:
Koha::Cash::Register relations should return sets not undef
[CLOSED FIXED; assigned to martin.renvoize]
13985:
[Omnibus] Cash Management - Koha as 'Point of Sale'
[NEW; assigned to martin.renvoize]
(*)
24820:
The cashup workflow should use the static 'date' field rather than the transient 'timestamp' field in accountlines
[CLOSED FIXED; assigned to martin.renvoize]
13985:
[Omnibus] Cash Management - Koha as 'Point of Sale'
[NEW; assigned to martin.renvoize]
(*)
24478:
Make it possible to deactivate point of sale
[CLOSED FIXED; assigned to martin.renvoize]
23355:
Add a 'cashup' process to accounts
[CLOSED FIXED; assigned to martin.renvoize]
(*)
24479:
POS doesn't follow CurrencyFormat
[CLOSED FIXED; assigned to martin.renvoize]
13985:
[Omnibus] Cash Management - Koha as 'Point of Sale'
[NEW; assigned to martin.renvoize]
(*)
24481:
Incorrect permission in admin/cash_registers.pl
[CLOSED FIXED; assigned to martin.renvoize]
23355:
Add a 'cashup' process to accounts
[CLOSED FIXED; assigned to martin.renvoize]
(*)
24482:
Purchase Items broken by costs containing a comma
[CLOSED FIXED; assigned to martin.renvoize]
23355:
Add a 'cashup' process to accounts
[CLOSED FIXED; assigned to martin.renvoize]
(*)
24519:
Change calculation and validation in Point of Sale should match Paycollect
[CLOSED FIXED; assigned to martin.renvoize]
13985:
[Omnibus] Cash Management - Koha as 'Point of Sale'
[NEW; assigned to martin.renvoize]
(*)
24540:
Unexpected behaviour on 'enter' in point of sale payment fields
[CLOSED FIXED; assigned to martin.renvoize]
13985:
[Omnibus] Cash Management - Koha as 'Point of Sale'
[NEW; assigned to martin.renvoize]
(*)
24490:
Clarify wording and function of Purchase Items link on POS
[CLOSED FIXED; assigned to david.roberts]
24525:
Hide SIP payment types from the Point of Sale page
[CLOSED FIXED; assigned to martin.renvoize]
13985:
[Omnibus] Cash Management - Koha as 'Point of Sale'
[NEW; assigned to martin.renvoize]
(*)
24775:
Payment submit button on POS page should have an ID
[CLOSED FIXED; assigned to martin.renvoize]
13985:
[Omnibus] Cash Management - Koha as 'Point of Sale'
[NEW; assigned to martin.renvoize]
(*)
24790:
POS missing from the 'More' dropdown
[CLOSED FIXED; assigned to tomascohen]
13985:
[Omnibus] Cash Management - Koha as 'Point of Sale'
[NEW; assigned to martin.renvoize]
(*)
24791:
Point of Sale module is missing from the 'more' menu
[RESOLVED DUPLICATE; assigned to martin.renvoize]
13985:
[Omnibus] Cash Management - Koha as 'Point of Sale'
[NEW; assigned to martin.renvoize]
(*)
26160:
Add column configuration to the Point of sale, Items for purchase table
[CLOSED FIXED; assigned to martin.renvoize]
26189:
Table options on points of sale misaligned
[CLOSED FIXED; assigned to martin.renvoize]
13985:
[Omnibus] Cash Management - Koha as 'Point of Sale'
[NEW; assigned to martin.renvoize]
(*)
26161:
Confirm and cancel buttons should be underneath the right hand form on the POS page
[CLOSED FIXED; assigned to martin.renvoize]
27256:
"Add" button on point of sale page fails on table paging
[CLOSED FIXED; assigned to martin.renvoize]
27289:
Template tweaks for point of sale page
[CLOSED FIXED; assigned to oleonard]
27290:
Cash register allows for 'amount tendered' less than amount being paid
[CLOSED FIXED; assigned to martin.renvoize]
13985:
[Omnibus] Cash Management - Koha as 'Point of Sale'
[NEW; assigned to martin.renvoize]
(*)
26926:
Omnibus: Update all occurrences of <input type="number"> to apply ACC2 coding guideline
[CLOSED FIXED; assigned to eden.bacani]
23003:
[OMNIBUS] Accessibility improvements
[NEW; assigned to koha-bugs]
28181:
Archived debit type still shows as available in Point of Sale
[CLOSED FIXED; assigned to martin.renvoize]
13985:
[Omnibus] Cash Management - Koha as 'Point of Sale'
[NEW; assigned to martin.renvoize]
(*)
24081:
Add a 'discount' process to accounts
[CLOSED FIXED; assigned to martin.renvoize]
24822:
Add discount processing to paycollect
[NEW; assigned to koha-bugs]
17596:
Simplify accounting UI in staff client [OMNIBUS]
[ASSIGNED; assigned to josef.moravec]
14825:
Accounts Rewrite Omnibus
[NEW; assigned to kyle.m.hall]
(*)
24849:
Permissions checks are missing in borracount controller
[NEW; assigned to martin.renvoize]
(*)
26542:
Apply Discount button appears when it can't be used.
[NEW; assigned to koha-bugs]
14825:
Accounts Rewrite Omnibus
[NEW; assigned to kyle.m.hall]
(*)
24812:
Add permission for 'discount' process
[CLOSED FIXED; assigned to martin.renvoize]
26541:
Apply discount button misleading
[CLOSED FIXED; assigned to andrew]
24821:
Add percentage handling to discount process
[NEW; assigned to koha-bugs]
17596:
Simplify accounting UI in staff client [OMNIBUS]
[ASSIGNED; assigned to josef.moravec]
(*)
24952:
Refund modal confirm button should have an ID
[CLOSED FIXED; assigned to martin.renvoize]
13985:
[Omnibus] Cash Management - Koha as 'Point of Sale'
[NEW; assigned to martin.renvoize]
(*)
26418:
The "description" for REFUND accountlines is not translatable
[CLOSED FIXED; assigned to martin.renvoize]
26403:
Move debit and credit types to YAML files and fix other related translation issues
[RESOLVED FIXED; assigned to martin.renvoize]
14825:
Accounts Rewrite Omnibus
[NEW; assigned to kyle.m.hall]
(*)
33935:
Installer list deleted files which shows warning in the logs
[RESOLVED FIXED; assigned to jonathan.druart]
27796:
SIP payment types should not be available as refund types
[CLOSED FIXED; assigned to martin.renvoize]
13985:
[Omnibus] Cash Management - Koha as 'Point of Sale'
[NEW; assigned to martin.renvoize]
(*)
17735:
Merge boraccount and pay pages into one
[ASSIGNED; assigned to martin.renvoize]
17596:
Simplify accounting UI in staff client [OMNIBUS]
[ASSIGNED; assigned to josef.moravec]
(*)
28138:
Add system preference to make the payment type required
[CLOSED FIXED; assigned to julian.maurice]
24300:
Add a 'payout amount' option to accounts
[CLOSED FIXED; assigned to martin.renvoize]
27971:
The VOID method should be updated to respect double-entry accounting
[CLOSED FIXED; assigned to martin.renvoize]
28664:
One should not be able to issue a refund against a VOID accountline
[Pushed to oldstable; assigned to martin.renvoize]
13985:
[Omnibus] Cash Management - Koha as 'Point of Sale'
[NEW; assigned to martin.renvoize]
(*)
27995:
Koha::Account::Line->apply should return the update Koha::Account::Line object
[CLOSED FIXED; assigned to martin.renvoize]
27636:
Replace Koha::Account::pay with a simpler method
[CLOSED FIXED; assigned to martin.renvoize]
22435:
Clarify account_offset types by converting them to clear codes
[CLOSED FIXED; assigned to martin.renvoize]
17735:
Merge boraccount and pay pages into one
[ASSIGNED; assigned to martin.renvoize]
(*)
28656:
Cancellations should be allowed on paid/partially paid debts
[Failed QA; assigned to martin.renvoize]
28421:
Add tests for Voided Payment and Voided Writeoff.
[CLOSED FIXED; assigned to martin.renvoize]
29158:
Web installer fails to load account_offset_types.sql
[CLOSED FIXED; assigned to jonathan.druart]
29139:
Paying gives ISE if UseEmailReceipts is enabled
[CLOSED FIXED; assigned to tomascohen]
14825:
Accounts Rewrite Omnibus
[NEW; assigned to kyle.m.hall]
(*)
28421:
Add tests for Voided Payment and Voided Writeoff.
[CLOSED FIXED; assigned to martin.renvoize]
(*)
28663:
One should not be able to apply a discount to a VOID accountline
[CLOSED FIXED; assigned to martin.renvoize]
13985:
[Omnibus] Cash Management - Koha as 'Point of Sale'
[NEW; assigned to martin.renvoize]
(*)
24951:
Payout modal confirm button should have an ID
[CLOSED FIXED; assigned to martin.renvoize]
13985:
[Omnibus] Cash Management - Koha as 'Point of Sale'
[NEW; assigned to martin.renvoize]
(*)
24177:
Internal Server error when clicking cash register (Report)
[CLOSED FIXED; assigned to josef.moravec]
25389:
Inconsistent naming of account_credit_type for lost and returned items
[CLOSED FIXED; assigned to martin.renvoize]
25478:
Inconsistent naming of account_credit_type for lost and returned items [19.11 Version]
[CLOSED FIXED; assigned to martin.renvoize]
25478:
Inconsistent naming of account_credit_type for lost and returned items [19.11 Version]
[CLOSED FIXED; assigned to martin.renvoize]
(*)
26398:
Credit and Debit types on creating a manual credits and manual invoices are not translatable
[CLOSED FIXED; assigned to martin.renvoize]
24241:
Description missing for subpermission manage_accounts
[CLOSED FIXED; assigned to jonathan.druart]
24316:
Fix non-English web installers by removing obsolete authorised value MANUAL_INV
[CLOSED FIXED; assigned to katrin.fischer]
24532:
Some account types are converted to debits when they shouldn't be
[CLOSED FIXED; assigned to martin.renvoize]
29559:
Update creates "unexpected type" entries for standard codes in debit and credit types
[CLOSED WONTFIX; assigned to koha-bugs]
24542:
Checkout page - Can't locate object method "search" via package "Koha::Account::DebitTypes"
[CLOSED FIXED; assigned to jonathan.druart]
25010:
Fix typo in debit type description: rewewal
[CLOSED FIXED; assigned to katrin.fischer]
26398:
Credit and Debit types on creating a manual credits and manual invoices are not translatable
[CLOSED FIXED; assigned to martin.renvoize]
(*)
24338:
CASH is missing from the default payment_types
[CLOSED FIXED; assigned to martin.renvoize]
23894:
accountlines.payment_type and accountlines.credit_type should be merged
[NEW; assigned to koha-bugs]
(*)
24481:
Incorrect permission in admin/cash_registers.pl
[CLOSED FIXED; assigned to martin.renvoize]
(*)
24786:
Allow setting a cash register for a login session and configuring library-default cash registers
[CLOSED FIXED; assigned to martin.renvoize]
26177:
The 'set library' functionality should be changed to 'session settings' or similar
[NEW; assigned to martin.renvoize]
26540:
Server error when attempting to issue cash credit with UseCashRegisters
[Needs Signoff; assigned to martin.renvoize]
13985:
[Omnibus] Cash Management - Koha as 'Point of Sale'
[NEW; assigned to martin.renvoize]
(*)
24665:
Add ability to run cash register report with new cash register feature
[CLOSED FIXED; assigned to martin.renvoize]
13985:
[Omnibus] Cash Management - Koha as 'Point of Sale'
[NEW; assigned to martin.renvoize]
(*)
28167:
A warning when setting which library to use in intranet and UseCashRegisters is disabled
[CLOSED FIXED; assigned to joonas.kylmala]
27126:
[OMNIBUS] Warnings from logs must be removed
[RESOLVED DUPLICATE; assigned to koha-bugs]
36014:
Set library does not display the updated library
[RESOLVED INVALID; assigned to koha-bugs]
24815:
Koha::Cash::Register relations should return sets not undef
[CLOSED FIXED; assigned to martin.renvoize]
(*)
24828:
Add cash register support to SIP2
[CLOSED FIXED; assigned to martin.renvoize]
13985:
[Omnibus] Cash Management - Koha as 'Point of Sale'
[NEW; assigned to martin.renvoize]
(*)
29385:
Add missing cash register support to SIP2
[CLOSED FIXED; assigned to jonathan.druart]
13985:
[Omnibus] Cash Management - Koha as 'Point of Sale'
[NEW; assigned to martin.renvoize]
(*)
26946:
Limit size of cash register's name on the UI
[CLOSED FIXED; assigned to martin.renvoize]
29385:
Add missing cash register support to SIP2
[CLOSED FIXED; assigned to jonathan.druart]
(*)
26012:
Date in 'Paid for' information not formatted to Time/DateFormat system preferences
[CLOSED FIXED; assigned to jonathan.druart]
26268:
Remove items.paid for once and for all
[CLOSED FIXED; assigned to martin.renvoize]
34063:
items.paidfor and deleteditems.paidfor still sometimes exist
[RESOLVED INVALID; assigned to koha-bugs]
22377:
Lost fines may not be refunded if another patron has a writeoff for the same item
[CLOSED FIXED; assigned to koha-bugs]
25389:
Inconsistent naming of account_credit_type for lost and returned items
[CLOSED FIXED; assigned to martin.renvoize]
(*)
25478:
Inconsistent naming of account_credit_type for lost and returned items [19.11 Version]
[CLOSED FIXED; assigned to martin.renvoize]
(*)
23316:
GetFine needs updating for bug 22521
[CLOSED FIXED; assigned to martin.renvoize]
23826:
Manual Invoice does not use new accounttype and status for fines
[CLOSED FIXED; assigned to martin.renvoize]
23827:
[19.05] Cash register statistics uses old accounttype values
[CLOSED FIXED; assigned to martin.renvoize]
22603:
Move boilerplate into Koha::Cron class
[RESOLVED WONTFIX; assigned to martin.renvoize]
22755:
Import Koha::Script to patron_emailer cronjob
[CLOSED FIXED; assigned to josef.moravec]
23193:
Make set_password.pl use Koha::Script
[CLOSED FIXED; assigned to tomascohen]
24377:
Record branch in statistics for auto-renewal
[CLOSED FIXED; assigned to nick]
25845:
Cannot limit system logs to 'api' interface
[CLOSED FIXED; assigned to tomascohen]
26086:
Add a 'cron' interface limit to the log viewer
[CLOSED FIXED; assigned to nick]
26086:
Add a 'cron' interface limit to the log viewer
[CLOSED FIXED; assigned to nick]
(*)
22577:
Cronjobs (and other scripts) should be attributed to a 'real' user
[RESOLVED FIXED; assigned to koha-bugs]
24658:
Deleting items with fines does not update itemnumber in accountlines to NULL causing ISE
[CLOSED FIXED; assigned to jonathan.druart]
26332:
Koha::Account::pay incorrectly defaults to '0' for manager_id
[RESOLVED DUPLICATE; assigned to martin.renvoize]
14825:
Accounts Rewrite Omnibus
[NEW; assigned to kyle.m.hall]
(*)
26506:
Koha::Account::pay will fail if $userenv is not set
[CLOSED FIXED; assigned to matthias.meusburger]
14825:
Accounts Rewrite Omnibus
[NEW; assigned to kyle.m.hall]
(*)
Max Depth: