Production Ticket(ST) #12038
GOLDCREST - user BRY do van goods request 1 times only, back end shown 3 items
1) Check the sp to show the van goods request approval.
2) Found that the multiple lines is due to salesman assign to multiple branch
3) Escalate to level 3. https://app.clickup.com/t/9018039480/TK-275
Root cause: Salesman assign to multiple branch.
None
Description
History
#1 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
exec sp_executesql N' exec web_spTxnMobileVanGoodsRequestApprovalMasterDataRetriveList @member_id,@org_id,@hdr_id, @type,@tenant_id',N'@member_id nvarchar(15),@org_id nvarchar(9),@hdr_id nvarchar(36),@type nvarchar(8),@tenant_id nvarchar(9)',
@member_id=N'GOLDCREST-admin',@org_id=N'GOLDCREST',@hdr_id=N'1f108a1e-0e35-4818-8e62-139560d2bb49',
@type=N'Approval',@tenant_id=N'GOLDCREST'
as I checked in the SQL profiler it showe 3. This is because this user has been assigned to multiple branch
-- web_spTxnMobileVanGoodsRequestApprovalMasterDataRetriveList --> checking the SP
currently testing on the trail
#2 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Assignee changed from Muhammed Azhar Mohamed Maideen to Rashdan Hussin
#3 Updated by Rashdan Hussin 3 months ago
- Subject changed from Goldcrest- Hi, may i know why user BRY do van goods request 1 times only, back end shown 3 items? to GOLDCREST - user BRY do van goods request 1 times only, back end shown 3 items
- Status changed from Assigned To to Support In Progress
select * from txn_mobile_van_goods_request_header where van_goods_request_no = 'VQBRY000002-240618'
select b.van_goods_request_no, * from txn_van_goods_request_approval_history a
inner join txn_mobile_van_goods_request_header b on b.van_goods_request_hdr_id = a.van_goods_request_id
where van_goods_request_id = '084f1507-538d-4bc3-874a-9340d86dff0b'
select * from di_txn_mobile_van_goods_request_header where van_goods_request_hdr_id = '084f1507-538d-4bc3-874a-9340d86dff0b'
#4 Updated by Rashdan Hussin 3 months ago
- Status changed from Support In Progress to Escalated to Level 3
- % Done changed from 0 to 50
- Type set to Support Request
- Actual Initial Response set to 18/06/2024
- Resolution updated (diff)
#5 Updated by Rashdan Hussin 3 months ago
Finding:
- Tested in trial v4.1.4-trial.0
- Upon testing, the request transaction already show 1 time only in approval module
- In database, request transaction show 2 times
- But the van goods receive in web show 2 times
Sample data:
- Org: goldcrest
- User: mcc_test
- User branch: JB, JCW
- Van goods request: VQmcc_test000007-240630
#6 Updated by Rashdan Hussin 3 months ago
- Due date changed from 20/06/2024 to 05/07/2024
- SLA Delivery set to 05/07/2024
#7 Updated by Muhammed Azhar Mohamed Maideen 2 months ago
- File JNM_branch.png JNM_branch.png added
- File Multiple_van_good.png Multiple_van_good.png added
--> done testing
User: JNM
assigned to all brannch
https://www.datanory.com.my:8080/DMS_EcoSystem_TRIAL/Member/GvMemberDetailsPage?MemberId=7f8c3d45b01d4b948c1372e2c5644762&Mode=View
select * from txn_mobile_van_goods_request_header where van_goods_request_no = 'VQJNM000043-240712' --> here shown 1
select b.van_goods_request_no, * from txn_van_goods_request_approval_history a
inner join txn_mobile_van_goods_request_header b on b.van_goods_request_hdr_id = a.van_goods_request_id -- here shown multiple
where van_goods_request_id = 'a7b71e3e-4c19-4ed8-b949-861d4b8c6fc2'
As I tested in web shown one
#8 Updated by Rashdan Hussin 2 months ago
- Status changed from Escalated to Level 3 to Pending Client Verification
- % Done changed from 50 to 90
#9 Updated by Rashdan Hussin 2 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- % Done changed from 90 to 100