-
Type: Customer Defect
-
Status: Need More Info (View Workflow)
-
Priority: Major
-
Resolution: Unresolved
-
Affects Version/s: CFA 2023R2
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
VTask #:VTASK0514795
Two stores with similar sales and forecasts for items using Chopped Romaine for prep are seeing very different 'amount forecasted' values in their Bulk Prep Reports.
select '01604' as StoreNumber,B.Description,A.* from tbSalesItemInventoryItemQuantity A with ( nolock )
Left Join tbSalesItem B with ( nolock) ON A.SalesItemId = B.SalesItemID
where entityid = 887 and ServiceType = 9
and A.SalesItemId in (2469,2474,2475,2471,2472,2426,2409,2418,2419,2431,2497,2703,2702,2719,2705,3082,3083,3079,3084,3085,3086,3087,3080,3078,3081,239)
and A.ItemId = 853
select '02234' as StoreNumber,B.Description,A.* from tbSalesItemInventoryItemQuantity A with ( nolock )
Left Join tbSalesItem B with ( nolock) ON A.SalesItemId = B.SalesItemID
where entityid = 1179 and ServiceType = 9
and A.SalesItemId in (2469,2474,2475,2471,2472,2426,2409,2418,2419,2431,2497,2703,2702,2719,2705,3082,3083,3079,3084,3085,3086,3087,3080,3078,3081,239)
and A.ItemId = 853
- blocks
-
CFAMX-11540 Production Defects
- Open