-
Type:
Customer Defect
-
Status: Done (View Workflow)
-
Priority:
Major
-
Resolution: Done
-
Affects Version/s: CFA 2021R2
-
Fix Version/s: CFA 2021R4
-
Component/s: None
-
Labels:None
-
VTask #:VTASK0458503
-
Root cause - Reason:Code defect
-
Source Code ID(s):
-
Root Cause:Code used Sales unit for inventory unit in the supply order and did not do the conversion.
Description
sIVUnit_cd does not match between tbtransactionsalesorderdetail and tbTransactionSupplyOrderDetail This is only happening for Off site thaw stores which causes the conversion to be off for items in item activity.
Environment : PROD
Stores : 00440, 00931, 01262, 03551, example 01998
Steps
1. Navigate to https://inform.cfahome.com/mms_logon.aspx?bypass_sso=true
2. Select Store 01998> Menu > Inv. & Order Setup > Inv. & Order Setup > Item Activity
3. Select Chicken Tenders > Order 4531820 received on 6/3 10:00 AM shows 36 received
4. Menu > Create/Receive Order > History > Order 4531820 shows Chicken Tenders 6 received 6 shipped
Results :
The received amount does not match when looking at Chicken Tenders in Item activity for order 4531820 I see a received amount of 36 but when looking at the order History for 4531820 I see a shipped and received amount of 6
Expected : To have the received amount from a order for an Off Site Thaw order to display correctly in the item activity screen. The sIVUnit_cd that is used in tbtransactionsalesorderdetail is not being used in tbtransactionsupplyorderdetail
select* from tbtransactionsalesorderdetail with (nolock)
where itransaction_num=5337313
Select * from tbTransactionSupplyOrderDetail with (nolock)
where iTransaction_num IN (4531820) and itemid=19
- Clones
-
-
- Done
-