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

Inventory Items By Vendor Orders Report - Field definitions

    Details

      Description

      When running the Inventory Items By Vendor Orders Report it was determined that there are a couple of bugs and also some missed requirements/definitions

      Column Heading Example Comments Ticket
      A Vendor1 THE MARTIN-BROWER COMPANY Name of Vendor CFAMX-3759 - Need to remove 1 from end of heading
      B OrderNumber1 796377 The order number of the received order CFAMX-3759 - Need to remove 1 from end of heading
      C ItemDescription1 "CHICKEN NUGGETS" The item description CFAMX-3759 - Need to remove 1 from end of heading
      D ItemNumber 30003 The Item Code  
      E ForecastQty 9.375721263 The forecast usage at the time the order was created  
      F SafetyStockQty 24.58172297 The Safety Stock at the time the order was created  
      G OnHandQty -454.511079 "The On Hand Quantity for the item, at the time the order was created (Can be impacted by Correct On Hand)"  
      H OnOrderQty 0 "The On Order Quantity for the item, at the time the order was created"  
      I OrderQty 5 "The quantity of product that was ordered, and submitted to the vendor"  
      J SuggestedOrderQty 489 "The Quantity Suggested, at the time the order was created (Can be impacted by Correct On Hand)" Should not be populated if the Item is NOT a Suggested Item 
      K DefaultOrderQty 5 "This is the Default Quantity, entered by the user in Item Maintenance" CFAMX-3762 - Should only be populated in the export if there is a DOQ that is not Null
      L SuggestedVsOrderQty 484 The difference between the SuggestedOrderQty - OrderQty = J - I Should this be an absolute value? - Will not be populated if the Item is NOT a Suggested Item
      M AllocationLimit 0 The Remaining Allocation Qty CFAMX-3764 - Should only be populated in the export if present and not Null
      N OriginalReceiveQty 5 The received quantity at the time at which this particular order number (column B) was received  
      O CorrectReceiveQty 5 The quantity received after the last correct receive action was perfromed on this item  
      P ShippedQty 4 The shipped quantity provided in the ASN file CFAMX-3771 - Should not be populated if an ASN is not associated to the order
      Q ReceiveCorrection   The difference between the OriginalReceiveQty and CorrectReceiveQty = N - O  CFAMX-3781 - ...
      R AutoReceived N "Identifies if the order was Auto Received from ASN, or not"  
      S CreatedDate 9/4/2019 12:29 The date at which the order was initially created  
      T DatePlaced 9/4/2019 12:29 The date at which the order was placed  
      U MinutesToPlace 0 "The time it took to place the order, DatePlaced - CreatedDate = T - S"  
      V DateShipped 9/4/2019 18:00 The date on which the order was Shipped - Assumes that an ASN is associated to the order CFAMX-3778 - Blank when order doesn't have ASN against it
      W DateReceived 12/4/2019 9:53 The date at which the order was received  
      X DateApplied 12/4/2019 9:05 "The date at which the order was applied, during the receiving process"  
      Y CreatedBy stacy.privalova The user who created the order  
      Z ReceiveAppliedBy Arleathia Chambliss The user who received the order  

        Attachments

          Issue Links

          Is Clone Of

          Testing Defect - CFAMX-3761 CLONE 2019R2 - Inventory Items By Vendor Orders Report - Field definitions

          • Major - Major loss of function.
          • Done
          is implemented by

          Testing Defect - CFAMX-3759 Inventory Items By Vendor Orders Report - Update Headings

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-3762 Inventory Items By Vendor Orders Report - Default Order Qty

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-3764 Inventory Items By Vendor Orders Report - Allocation Limit

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-3771 Inventory Items By Vendor Orders Report - ShippedQty

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-3778 Inventory Items By Vendor Orders Report - Date Shipped

          • Major - Major loss of function.
          • Done

          Testing Defect - CFAMX-3781 Inventory Items By Vendor Orders Report - ReceiveCorrection

          • Major - Major loss of function.
          • Done
          relates to

          Feature Request - CFAMX-1264 SO - User would like a report to show items changed historical Suggested Order

          • Major - Major loss of function.
          • Closed

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 8h
                  8h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 8h
                  8h

                    PagerDuty

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