Enable institutions to execute a Fiscal Year end and rollover necessary budgets and other financial objects
(UXPROD-1149)
|
|
| Status: | Draft |
| Project: | UX Product |
| Components: | None |
| Affects versions: | None |
| Fix versions: | Sunflower (R3 2024) | Parent: | Enable institutions to execute a Fiscal Year end and rollover necessary budgets and other financial objects |
| Type: | New Feature | Priority: | P2 |
| Reporter: | Dennis Bridges | Assignee: | Dennis Bridges |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | LC-priority3, error_handling, loc, possible-ramsons, stability, volaris-candidate | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original estimate: | Not Specified | ||
| Attachments: |
|
||||||||||||||||||||||||||||||||
| Issue links: |
|
||||||||||||||||||||||||||||||||
| Release: | Sunflower (R3 2024) | ||||||||||||||||||||||||||||||||
| Epic Link: | Enable institutions to execute a Fiscal Year end and rollover necessary budgets and other financial objects | ||||||||||||||||||||||||||||||||
| Front End Estimate: | Large < 10 days | ||||||||||||||||||||||||||||||||
| Front End Estimator: | Khalilah Gambrell | ||||||||||||||||||||||||||||||||
| Front-End Confidence factor: | 30% | ||||||||||||||||||||||||||||||||
| Back End Estimate: | Medium < 5 days | ||||||||||||||||||||||||||||||||
| Back End Estimator: | Khalilah Gambrell | ||||||||||||||||||||||||||||||||
| Back-End Confidence factor: | 30% | ||||||||||||||||||||||||||||||||
| Development Team: | Thunderjet | ||||||||||||||||||||||||||||||||
| PO Rank: | 135 | ||||||||||||||||||||||||||||||||
| Description |
|
Overview: We would like to see the "absolute expenditure" (not including credits). This is important when large credits are processed from previous years. Combining expended and credited amounts can make it difficult to understand the state of a budget, group or ledger. Scope: Display an amount on budget, group and ledger under financial activity that shows what has been expended without the inclusion of credits. Display an amount on budget, group and ledger under financial activity that shows wha has been credited (SUM of credits). Update encumbrance transactions to include separate Expended and Credited totals as well. Approach: Update budget view (UI) Update Group view (UI) Update Ledger view (UI) Update Fiscal year view (UI) Update Ledger "Budget Information Export" (UI) Update budget calculations (BE) Update encumbrance calculations (BE) Update CRUD transaction logic (BE) Update rollover logic (BE) Update Invoice approval and payment logic (BE) Use cases: We would like to see an amount in Finance that shows what has been expended without the inclusion of credits. For e.g.: We had a fund where we had a large credit of ($161,359.41). We processed a number of payments to spend down this amount. At the end of it, you cannot tell that this even happened from the Budget Summary screen. It only looks like we’ve spent $1,532.10. You must click into “View transactions” to see the individual transaction list. If you wanted to get the total amount of what has been spent (without credits) from there, you would then have to add up all those transactions manually.
Additional information: This will also resolve an issue identified when resolving
For requirements analysis, see https://folio-org.atlassian.net/wiki/x/ARpU |
| Comments |
| Comment by Dennis Bridges [ 08/Jan/24 ] |
|
Serhii_Nosko If we can create the remaining stories needed to implement this feature we will be able to pass it off to a team that has capacity in the currently release. As such I'd like to review it before we begin creating stories for our Ramsons features. thx! |
| Comment by Serhii_Nosko [ 09/Jan/24 ] |
|
Dennis Bridges after initial look we identified these places where BE changes will be necessary for this feature: mod-finance-storage 1) Need to add new field "credited": -Budget -Ledger -GroupFiscalYearSummary -GroupExpenseClassTotal -BudgetExpenseClassTotal 2) How do we need to recalculate OVER EXPENDED? Do we need to add new field OVER CREDITED? 3) Add support update budget with "credited" field 4) New migration script for recalculation of budget and encumbrances with addition of new field "credited" or invoking new Recalculate budget endpoint for each budget 5) Adjust all places where we use calculation for unavailable, cashBalance, overExpended, overEncumbered 6) Encumbrance amount calculation and adding new field amountCredited 7) Cancel invoice flow, after voiding transaction amount, credit and payment transactions will update budget, budget should be updated correctly taking into account new field 8) Update restrictions taking into account new "credited" field (new logic: (allocated + netTransfers) - (expenditures + credited)) 9) Expense class totals for rollover budget 10) Do we need to add new option based on "Credited" in rollover settings? 11) Rollover SQL script mod-finance: 12) Calculation of group, ledger and fiscal year 13) Adjust recalculate budget |