Incorrect calculation of allocationTo and allocationFrom in case of more than 5 funds exist in ledger or group

Description

Overview:

When there are more than five funds in one group and move alocation is between that group, an error may occur because the request to retrieving transactions from mod-finance-storage is sent in chunks.

Let's say there are seven funds: fund1, fund2 and etc. . for this case the CQL will be constructed and divided into two parts like this:

query #1:

query #2:

But in case there is a move of allocations between funds from the first query (fund1, fund2, fund3, fund4 and fund5) and the second query (fund6 and fund7). The transaction will be used for calculations, although between one group or ledger the movement of alocations should not be taken into account.

 

Steps to Reproduce:

  1. Log into some folio snapshot environment

  2. Click Finance module

  3. Create Ledger1

  4. Create Group1

  5. Create 7 funds with ledger = Ledger1 and group = Group1

  6. Create current budget for all funds

  7. Move allocation from Fund1 to Fund6 with ammount = 12

  8. Move allocation from Fund7 to Fund2 with ammount = 13

Expected Results: Decrease allocation: 0, Increase allocation: 0
Actual Results: Decrease allocation: 25, Increase allocation: 25
Additional Information:
URL:
Interested parties:

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

1

Checklist

hide

TestRail: Results

Activity

Show:

Dennis Bridges September 21, 2022 at 4:32 PM

Test successful in bugfest-mg

Oleksii Petrenko September 19, 2022 at 10:41 PM

Deployed to MG bf. Please proceed with verification.

Dennis Bridges September 16, 2022 at 2:56 PM

Test successful in folio-snapshot.

NinaChistova September 16, 2022 at 7:23 AM

Tested on https://folio-snapshot.dev.folio.org/

Works as expected

please review

Done

Assignee

Dennis Bridges

Reporter

Priority

Story Points

Sprint

Development Team

Thunderjet

Fix versions

Release

Morning Glory (R2 2022) Bug Fix

RCA Group

Implementation coding issue

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs
Created September 14, 2022 at 12:53 PM
Updated September 21, 2022 at 4:32 PM
Resolved September 16, 2022 at 2:56 PM
TestRail: Cases
TestRail: Runs
Loading...