| 2021-03-19 14:30:54 |
Tiffany Little |
bug |
|
|
added bug |
| 2021-03-19 14:32:25 |
Tiffany Little |
description |
I would like to see an edit_time column added to the acq.fund_debit table.
Currently there is only one column in the acqfd table that gives you any date information--create_time. However, fund debits change all the time. Consider:
1. They change from encumbrance true to false.
2. Amount and origin_amount are (probably) the same when the fund debit is first created, but amount can be changed when an invoice entry is attached.
3. You might delete the invoice entry that it's attached to, and/or change it to a different one.
3. They're deleted*
*For the sake of this bug I'm not proposing to keep deleted fund debits around, but that is a change that's made.
There may be some other circumstances I'm not thinking of right now, too.
Our libraries frequently run recurring fund reports. If I need to track down what's going on with a fund balance, the shifting sands of what's encumbered and what's not and when that change happened, etc. is really tough to pin down. |
I would like to see an edit_time column added to the acq.fund_debit table.
Currently there is only one column in the acqfd table that gives you any date information--create_time. However, fund debits change all the time. Consider:
1. They change from encumbrance true to false.
2. Amount and origin_amount are (probably) the same when the fund debit is first created, but amount can be changed when an invoice entry is attached.
3. You might delete the invoice entry that it's attached to, and/or change it to a different one.
3. They're deleted*
*For the sake of this bug I'm not proposing to keep deleted fund debits around, but that is a change that's made.
There may be some other circumstances I'm not thinking of right now, too.
Our libraries frequently run recurring fund reports. If I need to track down what's going on with a fund balance difference between two reports, the shifting sands of what's encumbered and what's not and when that change happened, etc. is really tough to pin down. |
|
| 2021-03-19 14:34:08 |
Tiffany Little |
description |
I would like to see an edit_time column added to the acq.fund_debit table.
Currently there is only one column in the acqfd table that gives you any date information--create_time. However, fund debits change all the time. Consider:
1. They change from encumbrance true to false.
2. Amount and origin_amount are (probably) the same when the fund debit is first created, but amount can be changed when an invoice entry is attached.
3. You might delete the invoice entry that it's attached to, and/or change it to a different one.
3. They're deleted*
*For the sake of this bug I'm not proposing to keep deleted fund debits around, but that is a change that's made.
There may be some other circumstances I'm not thinking of right now, too.
Our libraries frequently run recurring fund reports. If I need to track down what's going on with a fund balance difference between two reports, the shifting sands of what's encumbered and what's not and when that change happened, etc. is really tough to pin down. |
I would like to see an edit_time column added to the acq.fund_debit table.
Currently there is only one column in the acqfd table that gives you any date information--create_time. However, fund debits change all the time. Consider:
1. They change from encumbrance true to false.
2. Amount and origin_amount are (probably) the same when the fund debit is first created, but amount can be changed when an invoice entry is attached.
3. You might delete the invoice entry that it's attached to, and/or change it to a different one.
4. They're deleted*
*For the sake of this bug I'm not proposing to keep deleted fund debits around, but that is a change that's made.
There may be some other circumstances I'm not thinking of right now, too.
Our libraries frequently run recurring fund reports. If I need to track down what's going on with a fund balance difference between two reports, the shifting sands of what's encumbered and what's not and when that change happened, etc. is really tough to pin down. |
|
| 2021-03-31 15:42:24 |
Tiffany Little |
summary |
Add an edit_time column to the acq.fund_debit table |
Add an auditor table for acq.fund_debit |
|
| 2021-04-01 00:11:34 |
Jeff Davis |
evergreen: status |
New |
Confirmed |
|
| 2021-04-01 00:11:37 |
Jeff Davis |
evergreen: importance |
Undecided |
Wishlist |
|
| 2021-04-01 00:11:41 |
Jeff Davis |
evergreen: milestone |
|
3.next |
|
| 2021-04-01 00:11:52 |
Jeff Davis |
tags |
acq |
acq pullrequest |
|
| 2021-04-01 13:17:01 |
Christine Morgan |
bug |
|
|
added subscriber Christine Morgan |
| 2021-06-04 20:31:48 |
Galen Charlton |
evergreen: milestone |
3.next |
3.8-beta |
|
| 2021-06-04 20:32:19 |
Galen Charlton |
tags |
acq pullrequest |
acq pullrequest signedoff |
|
| 2021-07-07 14:48:35 |
Galen Charlton |
evergreen: status |
Confirmed |
Fix Committed |
|
| 2021-10-12 19:30:53 |
Evergreen Bug Maintenance |
evergreen: status |
Fix Committed |
Fix Released |
|
