Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Implement endpoint to return all finance data for FY through acqUnitRestriciton

Description

Purpose/overview:

Implement a new endpoint that should return financial data for particular FY to be used in the corresponding UI story .

Then each fund associated with that ledger or group will appear for a particular FY.

List of fields to return with their current values:

  • Fiscal year

  • Fund name

  • Fund code

  • Fund UUID

  • Fund status

  • Fund tags

  • Budget name

  • Budget UUID

  • Budget status

  • Budget initial allocation

  • Budget current allocation

  • Budget allowable encumbrance

  • Budget allowable expenditure

If no budget associated with the fund then the Fiscal year and Fund elements are output normally AND the Budget elements are empty.

Approach:

Database view can be used to fetch all related data.

Environment

None

Potential Workaround

None

Attachments

1

Checklist

hide

Activity

Show:

Serhii_Nosko November 22, 2024 at 8:00 AM

Looks good, acq rules also looks good for me, QA/PO verification will be done in scope of the corresponding UI ticket, closing this one.
CC:

Azizbek Khushvakov November 22, 2024 at 7:54 AM

Implemented based on these rules
cc:

Should be SKIPPED when:

  1. fundAcqUnitIds has uuid1 AND budgetAcqUnitIds has uuid2 (different from user's uuid)

  2. fundAcqUnitIds is empty AND budgetAcqUnitIds has uuid2 (different from user's uuid)

  3. fundAcqUnitIds has uuid2 (different from user's uuid) AND budgetAcqUnitIds is empty

  4. fundAcqUnitIds has uuid2 (different from user's uuid) AND budgetAcqUnitIds has uuid1

Should be KEPT when:

  1. fundAcqUnitIds has uuid1 AND budgetAcqUnitIds has uuid1 (matching user's uuid)

  2. fundAcqUnitIds has uuid1 AND budgetAcqUnitIds is empty

  3. fundAcqUnitIds is empty AND budgetAcqUnitIds has uuid1 (matching user's uuid)

  4. Both fundAcqUnitIds and budgetAcqUnitIds are empty

Azizbek Khushvakov November 19, 2024 at 8:11 AM

based on discussion about acqUnits restriciton to retrieve finance data, we need to support it

Azizbek Khushvakov November 18, 2024 at 2:36 PM

example output:

Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Thunderjet

Fix versions

Release

Sunflower (R1 2025)

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created November 18, 2024 at 7:47 AM
Updated March 11, 2025 at 9:23 AM
Resolved November 22, 2024 at 8:00 AM
TestRail: Cases
TestRail: Runs