In 19.05 we have an odd situation. Accountlines accounttype is now VARCHAR(80) In the past it was 5, so in the "Cash register" report we truncated that MANUAL_INV values in our dropdown. At the moment the DB will save a long value, but only provide the truncated values for searching, and so transactions will not show up
Created attachment 103561 [details] [review] Bug 25262: [19.05.x] Do not truncate MANUAL_INV in dropdown There is an issue in that historic values will still be truncated, but recent values are not. I feel the cash register report should reflect recent transactions over historic, and the historic are a data cleanup issue To test: 1 - Add a MANUAL_INV value with more than 5 characters 'INCREDIBLE_HULK' 2 - Add a manual invoice to a patron's acccount using this value 3 - Note the full code displays in patrons account 4 - Browse to Reports->Cash register 5 - Search for today's date, the value you createed, and all libraries 6 - No results returned 7 - Apply patch 8 - Repeat 5 9 - The transaction shows
When I apply this patch and create a manual invoice called 'INCREDIBLE_HULK' it will not show up in the Cash Register report when I narrow the search to Transaction Type = "INCREDIBLE_HULK". If I pay it and then do the search I see the Payment transaction. Also, after I run cash_register_stats.pl the dropdown defaults back to 'All payments to the library'.
Created attachment 104082 [details] [review] Bug 25262: [19.05.x] Do not truncate MANUAL_INV in dropdown There is an issue in that historic values will still be truncated, but recent values are not. I feel the cash register report should reflect recent transactions over historic, and the historic are a data cleanup issue To test: 1 - Add a MANUAL_INV value with more than 5 characters 'INCREDIBLE_HULK' 2 - Add a manual invoice to a patron's acccount using this value 3 - Note the full code displays in patrons account 4 - Browse to Reports->Cash register 5 - Search for today's date, the value you createed, and all libraries 6 - No results returned 7 - Apply patch 8 - Repeat 5 9 - The transaction shows
Created attachment 104115 [details] [review] Bug 25262: [19.05.x] Do not truncate MANUAL_INV in dropdown There is an issue in that historic values will still be truncated, but recent values are not. I feel the cash register report should reflect recent transactions over historic, and the historic are a data cleanup issue To test: 1 - Add a MANUAL_INV value with more than 5 characters 'INCREDIBLE_HULK' 2 - Add a manual invoice to a patron's acccount using this value 3 - Note the full code displays in patrons account 4 - Browse to Reports->Cash register 5 - Search for today's date, the value you createed, and all libraries 6 - No results returned 7 - Apply patch 8 - Repeat 5 9 - The transaction shows Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
Created attachment 104137 [details] [review] Bug 25262: [19.05.x] Do not truncate MANUAL_INV in dropdown There is an issue in that historic values will still be truncated, but recent values are not. I feel the cash register report should reflect recent transactions over historic, and the historic are a data cleanup issue To test: 1 - Add a MANUAL_INV value with more than 5 characters 'INCREDIBLE_HULK' 2 - Add a manual invoice to a patron's acccount using this value 3 - Note the full code displays in patrons account 4 - Browse to Reports->Cash register 5 - Search for today's date, the value you createed, and all libraries 6 - No results returned 7 - Apply patch 8 - Repeat 5 9 - The transaction shows Signed-off-by: Lucas Gass <lucas@bywatersolutions.com> Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
backported to 19.05.x for 19.05.11