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

Encumbrance limit not restricting order workflow

    XMLWordPrintable

Details

    • ACQ Sprint 131
    • Thunderjet
    • Not Scheduled
    • Cornell, MI State University/Library of Michigan
    • 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

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

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases