Details
-
New Feature
-
Status: Closed (View Workflow)
-
P3
-
Resolution: Done
-
None
-
None
-
XL < 15 days
-
Low
-
XXXL: 30-45 days
-
Thunderjet
-
-
80.3
-
R1
-
R1
-
R4
-
R1
-
R2
-
R1
-
R2
-
R4
-
R2
-
R1
-
R1
Description
Problem: Allocating money to each individual Fund can be time consuming for an administrator. Also, there are situations where administrators may not want to allocate specific amounts for direct spending as they are not certain how much these pools will require and constantly transferring and changing allocation is not practical.
Use cases:
- Administrators may not want to allocate specific amounts for direct spending as they are not certain how much these pools will require of the total. In this case they will allocate a single amount at a higher level that can be drawn on by many "reporting" codes.
Librarian allocates 100 dollars to a Fund and each code can use that money to make purchases. There is no restriction on the number of codes that are spending out of the 100 dollars but once the 100 dollars is spent the codes can no longer make purchases.Split out to UXPROD-2409- Librarian creates a shared allocation and once of the codes spends all the money before others are able to make any purchases. More money then needs to be added to the Fund.
- If user is spending money against a code we are able to restrict their visibility to the specific Budget from which they are spending. They can see how much they have spent and how much is left
- Librarian creates different reporting codes for spending that are not used by the university
- Librarian creates different reporting codes for spending and each code has a number that is passed to the AP system
Requirements:
- Allow administrators to create expense classes
- Allow administrators to add the expense classes to one or many funds
Each expense class can view how much money is left within a given Fund/budgetSplit out to UXPROD-2409- How much they have spent within a given Fund/budget
- Each expense class has a code/number (extention) that compliments the external account number of any fund it is assigned to
- Each expense class spending can be summarized as a percentage of the fund(s) it belongs to
- A group will summarize the expended amount associated with an expense class for all funds in that group with that class
- Need to see the expended value at this level and percentage of total expended for the group (See example in comments)
- If expense class has 1 or more transactions with a fund it can not be removed in that fiscal year.
- Each expense class has a status within the fund of Active or inactive. Inactive types can not be used
See mockups here: https://drive.google.com/drive/u/0/folders/1f4v2kDjm_cYl-KwXL3PWzfORVhcFU8BZ
Questions:
- Would these need to persist year over year? Yes, user would not want to need to recreate them.
Do you need to restrict expense class based on a percentage of the shared total?Split out to UXPROD-2409- How does an AP system need to understand these? If the external account number lives on the Fund any spending by the expense class would count against that account. Is that problematic? Yes, the expense class should have an external account number extention that is added to the external account number and treated as a separate external account number in vouchers etc.
Grooming:
Session
TestRail: Results
Attachments
Issue Links
- has to be done before
-
UXPROD-2409 Limit percentage of spend by expense classes
-
- Analysis Complete
-
- is defined by
-
MODFIN-130 Define and Implement Business API for the expense class
-
- Closed
-
-
MODFIN-136 Define and implement GET /finance/budgets/id/expense-classes-totals API
-
- Closed
-
-
MODFIN-137 Define and implement GET /finance/groups/id/expense-classes-totals API
-
- Closed
-
-
MODFIN-138 Update /finance/budgets POST and PUT APIs
-
- Closed
-
-
MODFIN-141 Implement API for getting expense classes for fund
-
- Closed
-
-
MODFIN-151 When creating budget add expense classes from previous budget automatically
-
- Closed
-
-
MODFISTO-104 Create expense class schema
-
- Closed
-
-
MODFISTO-105 Define and Implement Storage API for expense classes
-
- Closed
-
-
MODFISTO-115 Define and implement budget-expense-classes API
-
- Closed
-
-
MODFISTO-124 Return helpful information when store Expense Class with name/code which already exist
-
- Closed
-
-
MODFISTO-137 Return helpful information when delete Budget with assigned Expense Classes
-
- Closed
-
-
MODFISTO-165 Field "expenseClassId" must be a part of unique-constraint
-
- Closed
-
-
MODFISTO-183 Awaiting payment value in encumbrance not updated correctly
-
- Closed
-
-
MODINVOICE-174 Update transition to Approve considering the expense classes
-
- Closed
-
-
MODINVOICE-176 Prevent the creation of a transaction for an inactive expense class
-
- Closed
-
-
MODINVOICE-203 Update transition to Approve considering the expense classes "Code"
-
- Closed
-
-
MODINVOICE-205 Error must be returned in case of budget expense class mismatch
-
- Closed
-
-
MODINVOSTO-71 Update fundDistribution schema
-
- Closed
-
-
MODORDERS-406 Prevent the creation of an encumbrance for an inactive expense class
-
- Closed
-
-
MODORDERS-432 Payment must be possible if invoice line contains multiple fund distribution with same fund and different expense classes
-
- Closed
-
-
MODORDERS-437 Error must be returned in case of budget expense class mismatch
-
- Closed
-
-
UIF-211 CRUD expense classes in Finance settings
-
- Closed
-
-
UIF-212 Add expense classes to a budget
-
- Closed
-
-
UIF-213 Select expense class for Order & Invoice Fund distribution
-
- Closed
-
-
UIF-214 Display expense class information on budget view
-
- Closed
-
-
UIF-227 Display expense class information on Group view
-
- Closed
-
-
UIF-228 Increase granularity of finance app permissions
-
- Closed
-
-
UIF-230 Display expense classes on Fund record view
-
- Closed
-
-
UIF-240 Allowable expenditure/encumbrance display as 0% when not set
-
- Closed
-
-
UIF-241 Display and filter by expense class in transaction view
-
- Closed
-
-
UIF-244 Display error message when attempting delete a Budget with Expense Classes
-
- Closed
-
-
UIF-253 Allow user to use multiple expense class from same fund on one invoice line or POL
-
- Closed
-
-
UIF-258 Fund view - Display encumbered and awaiting payment amount in "Current expense classes" table
-
- Closed
-