-
Type:
Customer Defect
-
Status: Done (View Workflow)
-
Priority:
Major
-
Resolution: Done
-
Affects Version/s: CFA 2022R5
-
Fix Version/s: CFA 2023R2
-
Component/s: Inventory
-
Labels:None
-
VTask #:VTASK0507442
-
Root cause - Reason:Code defect
-
Source Code ID(s):
-
Root Cause:When the stock count is applied to past dates, we are seeing this issue.
Multiple items showing not counted in 37 days when looking at Correct On Hand when placing a truck order in InFORM. Monthly count was summited at End of Month.
// code placeholder
Select LastStockCountDate,* from tbEntityItem with ( nolock ) where EntityID = 1235 and ItemID = 2066
Select top 6 * from tbTransactionStockCountLocationDetail with ( nolock ) where ItemID = 2066
and TransactionStockCountLocationID in (Select TransactionStockCountLocationID from tbTransactionStockCountLocation with ( nolock ) where EntityID = 1235 ) order by CreateDate desc
Select top 6 * from tbtransactionStockCount with ( nolock ) where ItemID = 2066
and TransactionStockCountLocationID in (Select TransactionStockCountLocationID from tbTransactionStockCountLocation with ( nolock ) where EntityID = 1235 ) order by CreateDate desc
Issue is impacting multiple items but not all, few examples included below.
BUN, BRIOCHE N (101329)
MUFFIN, ENGLISH MULTIGRAIN (107005)
YOGURT, AUSSIE GREEK (103070)
FRUIT, MANDARIN ORANGES (043514)
JUICE, ORANGE 11.5 OZ (100330)
- blocks
-
CFAMX-11540 Production Defects
-
- Open
-
- is related to
-
CFAMX-15631 Update Count Processing logic to account correctly for back dated counts
-
- Done
-