-
Type:
Customer Defect
-
Status: Done (View Workflow)
-
Priority:
Major
-
Resolution: Done
-
Affects Version/s: CFA 2021R6
-
Fix Version/s: CFA 2022R4
-
Component/s: None
-
Labels:None
-
VTask #:VTASK0479402
-
SCRUM Team:Brotherhood of Mutants
-
Root cause - Reason:Code defect
-
Source Code ID(s):
-
Root Cause:Not able to replicate the issue in any environment except production.
Description
IAR is not calculating correctly
Environment : PROD
Store : All Stores, example 01014, 01942
Results :
Calculating the IAR totals Begin Inventory + Purchases + Transfer In - Transfer Out - Ending Inventory = Actual Usage does not add up for the majority of items
Examples are Macaroni & Cheese, Icedream Mix, Oil Canloa, Potato Waffle Fries, Chicken Filets
Expected : For the IAR totals Begin Inventory + Purchases + Transfer In - Transfer Out - Ending Inventory = Actual Usage to calculate correctly for all items
There are no negative purchase amounts in the given time period
SELECT *
FROM tbtransactionreceivelog WITH (NOLOCK)
WHERE itransaction_num in (5072801,5069045,5074950,5078600,5078592,5078588,5078524,5078520,5078517,5078512,5078496,5065276,5066871,5061692,5057699,5063095,5054009,5060353,5049802,5051830,5046234,5042340,5046264,5038704,5040561,5034919,5044927,5044917,5044914,5037035,5031137,5026559,5029090,5025444,5029179,5029173,5029165,5019305,5020999,5008656,5015564,5011992,5017662,5019021,5015042,5004438,5006333,5000604,5009897,5009891,4996981,4998370,4993444,4989101,4998585,4998583,4995783)
AND PurchaseAmt < 0
I have also verified that the purchase totals are correct in the following example this is for Macaroni & Cheese
SELECT SUM(fShipped_qty) AS 'Macaroni & Cheese'
FROM tbTransactionSupplyOrderDetail WITH (NOLOCK)
WHERE iTransaction_num IN
(
SELECT iTransaction_num
FROM tbTransactionSupplyOrder WITH (NOLOCK)
WHERE EntityID = 582
AND iReceived_dt BETWEEN '2021-11-01 15:10:00' AND '2021-11-23 15:35:00'
)
AND ItemID IN (3528)
What is causing the IAR to not calculate correctly?
- Clones
-
-
- Done
-