-
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
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)
- blocks
-
CFAMX-11540 Production Defects
- Open