Uploaded image for project: 'mod-finance'
  1. mod-finance
  2. MODFIN-225

Encumbrance limit not restricting order workflow

    XMLWordPrintable

    Details

    • Template:
      Standard Bug Write-Up Format
    • Sprint:
      ACQ Sprint 131
    • Development Team:
      Thunderjet
    • Release:
      Not Scheduled
    • Affected Institution:
      Cornell, MI State University/Library of Michigan
    • RCA Group:
      Legitimate regression

      Description

      Overview: Encumbrance limit not calculating correctly when expense classes are involved. Orders can be opened when the budget clearly doesn't have enough money

      Part two:

      1. Log into some FOLIO environment as User X
      2. Click finance app
      3. create a budget with $1000 allocated
      4. Transfer $900 into this budget from a different budget
      5. Create an order with fund distribution for $1000 with Fund distribution 100% to this Fund and open it
      6. NOW $1000 is now encumbered against budget
      7. Create invoice for this order and approve and pay it
      8. NOW $1000 expended against budget
      9. Create new order for $1 for the same fund and open it
      10. NOW $1 is encumbered against budget and $1000 expended
      11. Create third order for $1000 for that Fund and expense class
      12. Open order

      Expected Results: Order can not be opened because the encumbrance limit (100%) for the budget has been reached.

      Actual Results: Order is opened. Budget has $2001 unavailable but total funding is only $2000

      Additional Information:
      Encumbrance restriction should be based on (Total funding * allowable encumbrance percentage) - (awaiting payment + expended) - encumbered

      Over encumbered should be calculated by Total funding - (awaiting payment + expended) - encumbered

      Expenditure restriction should be based on (Total funding * allowable expenditure percentage) - (expended)

      Eg. 

      Total allocated = 3950
      Net transfers = 100
      Total Funding = 4050
      Encumbered = 51
      Awaiting payment = 2000
      Expended = 2000

      Allowable encumbrance, 110% = 4455 (Limit for encumbrance when opening/editing order)

      Allowable Expenditure, 100% = 4050 (Limit for approving/paying invoices)

      Over encumbered = 1 Min0((2000 + 2000 + 51) - 4050)
      Over Expended = 0 Min0(2000 - 4050)

      URL:
      Interested parties:

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                dennisbridges Dennis Bridges
                Reporter:
                dennisbridges Dennis Bridges
                Tester Assignee:
                Dennis Bridges Dennis Bridges
                Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases