Managing Ledgers, Funds, Budgets, Fiscals Years and tracking associated values (UXPROD-1144)

[UXPROD-2715] Identify "Initial Allocation" and "Total Funding" amounts in Budget Created: 01/Oct/20  Updated: 02/Aug/21  Resolved: 30/Apr/21

Status: Closed
Project: UX Product
Components: None
Affects versions: None
Fix versions: R1 2021
Parent: Managing Ledgers, Funds, Budgets, Fiscals Years and tracking associated values

Type: New Feature Priority: P3
Reporter: Dennis Bridges Assignee: Dennis Bridges
Resolution: Done Votes: 0
Labels: acquisitions, finances
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original estimate: Not Specified

Attachments: PNG File 2-proposed-summary-update.png    
Issue links:
Defines
is defined by UIF-278 Editing a budget clears all values Closed
is defined by MODFIN-174 Incorrect Group "Decrease in allocati... Closed
is defined by MODFIN-189 Incorrect calculation total finance i... Closed
is defined by MODFISTO-216 Ensure Increase and decrease in alloc... Closed
is defined by UIF-280 Allow only positive allocation to or ... Closed
is defined by MODFIN-168 Update logic with financial detail in... Closed
is defined by MODFIN-170 Update business API for retrieving fi... Closed
is defined by MODFIN-173 Update /finance/group-fiscal-year-sum... Closed
is defined by MODFIN-175 Support PUT for the Budget Closed
is defined by MODFISTO-186 Update Budget schema with new Financi... Closed
is defined by MODFISTO-187 Update logic with financial detail in... Closed
is defined by MODFISTO-188 Update Ledger schema with new Financi... Closed
is defined by MODFISTO-190 Migration : Fill new fields of the Bu... Closed
is defined by MODFISTO-195 Create view with Budget financial det... Closed
is defined by MODFISTO-197 Adjust fiscal year schema with financ... Closed
is defined by MODFISTO-203 Update group-fiscal-year schema with ... Closed
is defined by MODFISTO-204 Define and implement rollover error r... Closed
is defined by MODFISTO-206 Ensure that Allowable Encumbrance and... Closed
is defined by MODINVOICE-222 Ensure that Allowable Encumbrance and... Closed
is defined by MODINVOICE-226 CLONE - Ensure that Allowable Encumbr... Closed
is defined by MODORDERS-471 Ensure that Allowable Encumbrance and... Closed
is defined by UIF-261 Update Budget detail view to include ... Closed
is defined by UIF-262 Update Fiscal year view to include mo... Closed
is defined by UIF-263 Update ledger view to include more su... Closed
is defined by UIF-264 Update group view to include more sum... Closed
Relates
relates to UX-399 UX: Update Budget summary accordion i... Closed
relates to UX-407 UX: Update Fiscal year, Ledger and gr... Closed
relates to MODFISTO-211 Incorrect budget overExpended value Closed
Epic Link: Managing Ledgers, Funds, Budgets, Fiscals Years and tracking associated values
Front End Estimate: Large < 10 days
Back End Estimate: Large < 10 days
Development Team: Thunderjet
PO Rank: 76.3
PO Ranking Note: Important numbers for reports and managing the budget. Also having a net available amount will be important for ensuring that libraries can fully expend all funds when they are using any of the spending restriction functionality.
Rank: Chicago (MVP Sum 2020): R2
Rank: Cornell (Full Sum 2021): R1
Rank: Duke (Full Sum 2021): R1
Rank: 5Colleges (Full Jul 2021): R2
Rank: GBV (MVP Sum 2020): R1
Rank: Grand Valley (Full Sum 2021): R2
Rank: MO State (MVP June 2020): R2
Rank: TAMU (MVP Jan 2021): R2
Rank: U of AL (MVP Oct 2020): R1

 Description   

Overview:

Display the Initial allocation at the top of the budget record separate from the Total Funding number. Showing the user what was first allocated and how that changed throughout the year

Display the Total Funding amount at the top of the budget. This includes both Net allocated and Net transferred amounts. At any given time this represents the maximum amount of money that can be spent from this budget. Allowable Encumbrance and Expenditure should be applied to this number for regulating the budget expenditure, as described in UXPROD-2409 Analysis Complete .

Use cases:

  • Library need to know how much money they initially allocated to the budget for the year. They look at the budget to retrieve this number and may use it in reporting
  • Library needs to be able to see what changes were made to the allocation for the year. looking at net allocation minus initial allocation will give the user that amount.
  • Library wants to limit expenditure by expense classes and must use a net net amount or money will be left over in the budget.
  • Library wants to know how much of the actual cash balance they have spent. This should take into account both allocations and transfers. I.e. All money in the budget

In-scope:

  • Calculate and display initial allocation on the budget, storing it in budget details for reference and reporting
    • The first allocation transaction made to the budget will be identified as the "Initial Allocation"
  • Display all increases and decreases to allocation following the initial allocation being made
  • Store and display "Total funding" value for the budget (Allocated + Net transfers)
  • Ensure that Allowable Encumbrance and Allowable Expenditure restrictions are based on "Total Funding" NOT Allocation
  • Update the number display in the budget according to mockup
  • Updated summary display for Group, Ledger and Fiscal year records

Approach

See design mockup attached



 Comments   
Comment by Dennis Bridges [ 30/Apr/21 ]

All issue resolved and tested in bugfest-iris.

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