Enable institutions to execute a Fiscal Year end and rollover necessary budgets and other financial objects (UXPROD-1149)

[UXPROD-4390] Display Credit value separate from Expended Value in financial activity Created: 05/Jul/23  Updated: 18/Jan/24

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: PNG File folio-snapshot.dev.folio.org_finance_budget_b626d25d-001b-4c01-a85d-14ebbf26dbe0_view__fundStatus=Active&limit=50&offset=0.png    
Issue links:
Defines
is defined by UIF-494 Display "Credited" total in Fiscal ye... Open
is defined by UIF-495 Display "Credited" total in Ledger view Open
is defined by UIF-496 Display "Credited" total in Group view Open
is defined by UIF-497 Display "Credited" total in Budget view Open
is defined by UIF-498 Export "Credited" total in csv export... Open
Relates
relates to MODINVOICE-487 Encumbrance amount updated incorrectl... Closed
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 MODINVOICE-487 Closed

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

Generated at Fri Feb 09 00:39:33 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.