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

Missing Forecasting for several items in Purchase Order

    Details

    • Type: Customer Defect
    • Status: Need More Info (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: CFA 2023R1
    • Fix Version/s: None
    • Component/s: Ordering
    • Labels:
      None
    • VTask #:
      VTASK0510294

      Description

      Truck order 6568973 is missing Forecasting for several items. Please assist with determining the issue and or assist with resolution.

      Example: Potato, Hash Browns TFF (051836)

       

      Select * from tbVendorITem with ( nolock ) where VendorCode = '051836'
      Select * from tbVendorEntityItem with ( nolock ) where VendorCode = '051836' and ItemID = 617 and EntityID = 5015 
      Select * from tbEntityItem with ( nolock ) where ItemID = 617 and EntityID = 5015 
      Select * from tbItem with ( nolock ) where ItemID = 617
       
      

      Item Maintenance 

      In Forecasting table there is forecasting for the order date to cover:

      Select * from Forecasting.InventoryItemMetricDetail where InventoryItemId = 617 and forecastID in (SElect forecastID from Forecasting.Forecast with ( nolock) where BusinessDay = '2023-02-20' and EntityID = 5015)

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                wesam.el-gendy Wesam El-Gendy
                Reporter:
                wesam.el-gendy Wesam El-Gendy
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:

                  PagerDuty

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