-
Type: Customer Defect
-
Status: Done (View Workflow)
-
Priority: Major
-
Resolution: Closed/Resolved by Caller
-
Affects Version/s: CFA 2021R2
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
VTask #:VTASK0457259
Description
received orders are not updating tbitemqty but appear to update tbdailystockbalance causing the item Activity to have the correct on hand amount and create order page to have the wrong on hand amount
Environment : PROD
Store : 00528, 02891
Steps
1. Navigate to https://inform.cfahome.com/mms_logon.aspx?bypass_sso=true
2. Workflow > Mobile Inform > Select Store 00528 > Inv. & Order Setup > Item Activity
3. Select Potato, Waffle Fries > On Hand total is different from a created order
4. Create a Order for QCD > Search for Potato, Waffle Fries > On Hand is different from Item Activity
Results :
On Hand in Item Activity does not match the on hand that is in a created order. Received orders are not updating Tbitemqty but they appear to update tbdailystockbalance causing Item Activity to have the correct on hand and the create order page to have the wrong on hand amount
Expected : To have received orders update tbitemqty
select* from tbItemQty with (nolock)
where entityid=326 and itemid=883
Select * from tbDailyStockBalance with (nolock)
where ItemID=883
and BusinessDay between '2021-05-01' and '2021-06-02'
and EntityID=326
order by BusinessDay DESC
Select * from tbTransactionReceiveLog with (nolock)
where entityid=326
and ItemID=883 order by ApplyDate desc
- is blocked by
-
CFAMX-11540 Production Defects
- Open