Uploaded image for project: 'mod-finance-storage'
  1. mod-finance-storage
  2. MODFISTO-37

Update LedgerFY table

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Closed (View Workflow)
    • Priority: P2
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 4.0.0
    • Labels:
      None
    • Template:
    • Sprint:
      ACQ Sprint 73
    • Story Points:
      3
    • Development Team:
      Thunderjet

      Description

      Overview

      As ledgers and fiscal years are created, we need to make corresponding changes to the LedgerFY table.

      • Ledger is created -> create a LedgerFY records for that Ledger and the current FY as well as any existing FYs in the future.
      • Fiscal year is created -> create a LedgerFY record for each Ledger (only if fiscalYear endDate > now)
      • NOTE: Don't worry about delete for now... we'll probably need to implement a soft delete for ledgers since they are referred to by several other records.

      See the wiki for details

      Approach

      • Update the LedgerFY table in a database transaction, or possibly via trigger function.

      Acceptance Criteria

      • LedgerFY records are created for the current year when a ledger is created
      • Unit tests are updated

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                cmcnally Craig McNally
                Reporter:
                cmcnally Craig McNally
                Tester Assignee:
                Craig McNally Craig McNally
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases