Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-13934

UOM - Vendor Item Import and Vendor Entity Item Import: Update "Inner"

    Details

    • Type: Story
    • Status: Closed (View Workflow)
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Sprint:
      2021.R4 New Features Sprint 1, 2021.R4 New Features Sprint 2, 2021.R5 New Features Sprint 1, 2021.R5 New Features Sprint 2, 2021.R5 New Features Sprint 3, 2021.R5 New Features Sprint 4
    • SCRUM Team:
      Great White
    • Story Points:
      5
    • Work Type Classification:
      Sustaining

      Description

      Story

      As a user, when the purchase unit of an existing item is updated via the Vendor Item Import and the new record includes "Inner" values, I would like these new values to update the existing item Inner and Unit values as well.

      Details

      When the purchase unit of an item is updated via the Vendor Item Import we need to also update the existing "Inner" and "Unit" values from the same record. These three values make up the whole countable inventory item. The idea is:

      • Once we have identified the largest Purchase Unit record and and updated the existing Purchase Unit to be largest value we need to:
        • Update the existing "Inner" value with the corresponding value from the largest Purchase Unit record.

      StocktakeUnit2

      AC

      Confirm

      1. The "Inner" value of an entity item is updated with the corresponding inner value from the largest Purchase Unit record and displays correctly in the UI
        1. If there is no corresponding Inner value, the inner value is null, we should null the existing inner.
      2. In update records where the purchase unit is smaller than an existing purchase unit, the Inner values are not updated and the UI displays the correct values.
      3. These changes are load tested and the updates to the database finish in the time allotted.

        Attachments

        1. VENDORITEM_20210329_0245.csv
          506 kB
        2. VENDORENTITYITEM_DAILY_20210311_1414_A_20210311_180101.csv
          10 kB
        3. VENDOREITEM_20210114_1458.csv
          31 kB
        4. Testing cfamx-13934.docx
          299 kB
        5. screenshot-2.png
          screenshot-2.png
          13 kB
        6. screenshot-1.png
          screenshot-1.png
          56 kB
        7. PurchaseUnitsWithSlash.png
          PurchaseUnitsWithSlash.png
          28 kB
        8. InnerValue.png
          InnerValue.png
          89 kB

          Issue Links

            Activity

              People

              • Assignee:
                charles.wheeler Charles Wheeler
                Reporter:
                jason.powell Jason Powell
              • Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 28h Original Estimate - 28h
                  28h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 45h 25m
                  45h 25m

                    PagerDuty

                    Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.