[UXPROD-772] Rollover Encumbrances into the next Fiscal Year - FOLIO Issue Tracker

XML

Word

Printable

Details

Type: New Feature
Status: Closed (View Workflow)
Priority: P3
Resolution: Done
Affects Version/s: None
Fix Version/s: R1 2021
Component/s: None
Labels:
- Q3fromQ2
- acquisitions
- finances
- orders
- po-mvp
- round_iv
- transactions

Template:

UXPROD features
Epic Link:
Fiscal Year end and rollover
Analysis Estimate:
Small < 3 days
Front End Estimate:
XL < 15 days
Front-End Confidence factor:
Medium
Back End Estimate:
XXL < 30 days
Estimation Notes and Assumptions:
Additional question may come up but the majority of the backend implementation has now been defined so we consider this a reasonable estimate.
Development Team:
Thunderjet
Calculated Total Rank:
PO Rank:
79.5
Rank: Chalmers (Impl Aut 2019):
R5
Rank: Chicago (MVP Sum 2020):
R1
Rank: Cornell (Full Sum 2021):
R1
Rank: Duke (Full Sum 2021):
R1
Rank: 5Colleges (Full Jul 2021):
R1
Rank: FLO (MVP Sum 2020):
R1
Rank: GBV (MVP Sum 2020):
R1
Rank: hbz (TBD):
R1
Rank: Hungary (MVP End 2020):
R1
Rank: Lehigh (MVP Summer 2020):
R2
Rank: Leipzig (Full TBD):
R1
Rank: Leipzig (ERM Aut 2019):
R1
Rank: MO State (MVP June 2020):
R1
Rank: TAMU (MVP Jan 2021):
R2
Rank: U of AL (MVP Oct 2020):
R1

Description

Overview: In order to start the next fiscal year the user must be able to transfer or close outstanding encumbrances for orders that have not yet been resolved. This is generally done based on order type.

Use cases:

Library has ongoing orders that must be re-encumbered in the upcoming fiscal year. The library will want to encumber money next year based on what was spent in the current year and potentially increase it by a specific percentage.
Library has ongoing orders that must be re-encumbered in the upcoming fiscal year. The library will want to encumber money differently for continuations that for subscription orders. Increasing them by different percentages.
Library has one-time orders that could not be close and must be re-encumbered in the upcoming fiscal year. The method of encumbrance may differ from that of on-going orders. For one-time orders the library would rollover remaining encumbrances.
~~Library will want to release all remaining encumbrances in the fiscal year that is being closed?~~ no they will not according to small group

High-Level Requirements:

Create new encumbrances for the coming fiscal year without affecting monies that have already been expended against the current encumbrance
Update encumbrance values according to rollover settings for order type
Track the amount expended against this encumbrance so next years encumbered value can be based on the amount spent in the previous year
Preserve the current encumbrance value if there is any remaining at rollover
~~Note the FY currency could be different from one FY to the next?~~ This will be considered under a separate feature
Note the exchange rate may need to be applied to obtain the value of the encumbrance for the next fiscal year if the order was in a foreign currency.
~~Ability to run a rollover "preview" that will tell the user what they should fix before rollover to avoid errors~~ This is a substantial feature that should be implemented separately

Design: https://drive.google.com/drive/u/0/folders/1OGnJNiNVgm6c6qifjDf-ZXnAhlv54JTV

Back-end Design : https://wiki.folio.org/display/DD/Fiscal+year+rollover

Grooming:
Session 1
Session 2
Session 3 (Q&A)
Session 4 (FY discussion)
Session 5 (model, schema, storage api)
Session 6 (Q&A)

TestRail: Results

Attachments

Issue Links

is defined by

MODFIN-100 Factor Fiscal year into Ledger summary total calculations

Closed

MODFIN-155 Protect begin fiscal rollover with separate permission

Closed

MODFIN-157 Define business API for the ledger fiscal yea rollover

Closed

MODFIN-158 Define business API for retrieving rollover status/progress

Closed

MODFIN-162 Define business API for starting building Error Report

Closed

MODFISTO-157 Spike : Check that it is possible to apply business rollover logic to the selected PostgreSQL function-based approach

Closed

MODFISTO-163 Define storage API for the ledger fiscal year rollover

Closed

MODFISTO-164 Define model and schema of the fiscal year rollover for Ledger

Closed

MODFISTO-167 Add ledger fiscal year rollover logic

Closed

MODFISTO-168 Define storage API for retrieving rollover status

Closed

MODFISTO-169 Spike : Investigate approach for the ability to monitor rollover progress from PostgreSQL function

Closed

MODFISTO-170 Monitor rollover progress from PostgreSQL function "budget_encumbrances_rollover.sql"

Closed

MODFISTO-174 Define model and schema for the progress of the ledger fiscal year rollover

Closed

MODFISTO-175 Define model and schema for the errors of the ledger fiscal year rollover

Closed

MODFISTO-177 Create migration script for setting in all encumbrances "reEncumber" = true

Closed

MODFISTO-192 Define Rollover transfer transactionType

Closed

MODFISTO-194 Add order status to encumbrance schema

Closed

MODFISTO-196 Restrict rollover deletion for not completed rollover status

Closed

MODFISTO-217 When not checking Rollover or Available in roll settings, systems rolls all amounts

Closed

MODFISTO-218 "Purchase order was not loaded" error

Closed

MODFISTO-221 Rollover budget ignores expense classes when creating new budget

Closed

MODFISTO-222 Budget created for inactive fund

Closed

MODFISTO-224 Calculate transaction amount based on fundDistribution percentage value

Closed

MODFISTO-225 The lost/extra penny when creating encumbrances during rollover

Closed

MODORDERS-438 Define re-encumber and rollover orders business API

Closed

MODORDERS-439 Implement re-encumber orders logic

Closed

MODORDERS-440 Implement re-encumbered order line logic

Closed

MODORDERS-463 Change encumbrance orderStatus when workFlowStatus is changed

Closed

MODORDERS-464 Implement rollover orders logic

Closed

MODORDERS-465 Implement order rollover status logic for get by id

Closed

MODORDERS-478 Total encumbered for PO showing more than one year of encumbrances

Closed

MODORDERS-479 Update fundDistributions during order rollover

Closed

MODORDERS-480 Create encumbrances based on fundDistribution percentage value during re-encumber

Closed

MODORDSTOR-116 Use cross-index subqueries instead of views

Closed

MODORDSTOR-184 Add fields to orders schemes needs for rollover.

Closed

MODORDSTOR-187 Create migration script for setting in all orders "reEncumber" = true

Closed

UIF-254 Set Fiscal year detail during fiscal year rollover

Closed

UIF-279 Add Rollover confirmation modal so user can not start roll by mistake

Closed

UIF-282 Add label to transaction type "Rollover transfer"

Closed

UIF-290 Cannot create fiscal year

Closed

UIOR-658 Use "Total expended" and "Total encumbered" from composite order

Closed

relates to

MODFISTO-181 Move allocated logic from trigger to java code

Closed

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

Closed

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

Closed

UIF-168 Begin fiscal year rollover for a Ledger

Closed

UIF-170 Set encumbrance detail for fiscal year rollover

Closed

UIF-171 Execute fiscal year rollover

Closed

UIF-237 Display fiscal year rollover progress

Closed

UIF-238 Display fiscal year rollover error message and log file

Closed

UIOR-644 Add Update encumbrances order action

Closed

(36 is defined by , 9 relates to)

Activity

People

Assignee:: Dennis Bridges

Reporter:: Dennis Bridges

Votes:: 0 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 30/May/18 5:02 PM

Updated:: 17/Mar/22 6:33 PM

Resolved:: 30/Apr/21 9:26 PM

Rollover Encumbrances into the next Fiscal Year