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

SO - Item Activity - Provide view of Item Activity to track inventory movement (on-hand) by transaction type

    Details

    • HLE (1 man day = 8 hrs):
      20
    • INF Reference Number:
      INF-11899

      Description

      A way to track inventory movement. A way to look at transaction movement. A view into transfers, sales, receiving, etc. Thinking of a date range instead of count to count. This would be by item.

      This would be a tool they can use to troubleshoot on hand issues for an item. This would include anything that can affect on hand for an item.

      • Inventory Item Selector
      • Date Range Selector
      • Sales would be summed
      HLE Notes

      New Page (Under Inv & Order Setup)

      • Select Item
      • Select Start Date
      • Select End Date
      • Max range is 45 days
        Use values from DSB
      • Start Date = DSB value for close of previous date
      • End Date = DSB value for the date selected, or a current perpetual inventory if today is selected
        Show some sort of ledger of inventory movements
      • Show transactions in date order, start with oldest thru to newest
        Beginning Inventory (Date time, Qty)
        + Orders Received (Order #, Date time, Qty)
        Impact of Correct Receive (can this be displayed?)
        Impact of Change Apply Date (Can this be displayed?)
        + Transfer In (Transfer #, Date time, Qty)
      • Transfer Out (Transfer #, Date time, Qty)
      • Waste (Date time, Qty, Source)
      • Sample (Date time, Qty, Source)
      • Giveaway (Date time, Qty, Source)
      • Daily Sales (by day)
        Ending Inventory (Date time, Qty)

        Sounds similar to IAR
        Display data on page
        Support csv download of data

      Stories

      1. New page (Item Activity) with permissions, item selector and date selectors
      2. Item selector
      3. Display starting inventory (from DSB) and ending inventory (maybe from DSB, or perpetual/UPT)
      4. Display Receivings (Normal, Correct Receive, Change Apply Date)
      5. Display Transfers (In & Out)
      6. Display Adjustments (Waste, Samples, Giveaways, Food Donations, from InFORM and POS)
      7. Display Daily Sales
      8. Display Inventory Counts
      9. Add support for csv download of data displayed on page

        Attachments

          Issue Links

          is implemented by

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-4451 Item Activity - Augment/Create Load Tests

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-4452 Item Activity - Documentation

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-4580 Item Activity - New Page and Permissions

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-4588 Item Activity - Item Selector

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-4593 Item Activity - Display Beginning and Ending Inventory

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-4598 Item Activity - Display Daily Sales

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-4603 Item Activity - Display Receivings

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-4608 Item Activity - Display Transfers In & Transfers Out

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-4613 Item Activity - Display Adjustments

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-4618 Item Activity - Display Inventory Counts

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-4623 Item Activity - CSV Download

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-5481 Item Activity - Item Selector - Do NOT display BOM items

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-5486 Item Activity - UPT Items

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-5492 Item Activity - Increase scroll area

          • Closed
          relates to

          Testing Defect - CFAMX-6531 Item Activity - Page Load generates Operation Failed Error

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-6532 CLONE 2019R4 - Item Activity - Page Load generates Operation Failed Error

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-6533 Item Activity - Source (POS/InFORM) feature missing from Waste/Sample/Giveaways Adjustment transactions

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-6534 CLONE 2019R4 - Item Activity - Source (POS/InFORM) feature missing from Waste/Sample/Giveaways Adjustment transactions

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-6656 Item Activity - Order Received - Item Activity displaying multiple transactions for same order with different In Qty for Biscuit Mix.

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-6657 CLONE 2019R4 - Item Activity - Order Received - Item Activity displaying multiple transactions for same order with different In Qty for Biscuit Mix.

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-6836 Item Activity - Popover Issues

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-6837 CLONE 2019R4 - Item Activity - Popover Issues

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-6838 Item Activity - (IE11) Popover is detached from transaction when user scrolls user up and down page

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-6839 CLONE 2019R4 - Item Activity - (IE11) Popover is detached from transaction when user scrolls user up and down page

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-6842 Item Activity - CSV Download showing 24 hour clock, not AM/PM

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-6843 CLONE 2019R4 - Item Activity - CSV Download showing 24 hour clock, not AM/PM

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-6845 Item Activity - Counts - Inconsistent data displayed in Popover

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-6846 CLONE 2019R4 - Item Activity - Counts - Inconsistent data displayed in Popover

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-6959 Item Activity - UI 4 dp, CSV 2 dp - Both should be 4 dp

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-6960 CLONE 2019R4 - Item Activity - UI 4 dp, CSV 2 dp - Both should be 4 dp

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-6961 Item Activity - Samples - Inconsistent data between popover and CSV Details column

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-6962 CLONE 2019R4 - Item Activity - Samples - Inconsistent data between popover and CSV Details column

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-6963 Item Activity - Waste - Inconsistent data between popover and CSV Details column

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-6964 CLONE 2019R4 - Item Activity - Waste - Inconsistent data between popover and CSV Details column

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-6965 Item Activity - Order (Correct Receive) - Inconsistent data between popover and CSV Details column

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-6966 CLONE 2019R4 - Item Activity - Order (Correct Receive) - Inconsistent data between popover and CSV Details column

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-6967 Item Activity - Order (Change Apply Date) - Inconsistent data between popover and CSV Details column

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-6968 CLONE 2019R4 - Item Activity - Order (Change Apply Date) - Inconsistent data between popover and CSV Details column

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-6969 Item Activity - Count - Inconsistent data between popover and CSV Details column

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-6970 CLONE 2019R4 - Item Activity - Count - Inconsistent data between popover and CSV Details column

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-7167 Item Activity - Order of last records is wrong

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-7168 Item Activity - Receiving - Time zones out of sync?

          • Major - Major loss of function.
          • Done

          Sprint Defect - CFAMX-7536 Item Activity - Check in latest changes of the Stored Proc

          • Major - Major loss of function.
          • Done

          Sprint Defect - CFAMX-7537 CLONE 2019R4.1 - Item Activity - Check in latest changes of the Stored Proc

          • Major - Major loss of function.
          • Done

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-6974 Item Activity - Giveaway Feedback

          • Closed

          Story - Created by Jira Software - do not edit or delete. Issue type for a user story. CFAMX-6979 CLONE 2019R4 - Item Activity - Giveaway Feedback

          • Closed

            Activity

              People

              • Assignee:
                will.englefield Will Englefield (Inactive)
                Reporter:
                will.englefield Will Englefield (Inactive)
              • Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

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