Production Ticket(ST) #11513
GOLDCREST - WWX started use mobile app in Feb 2024, how come this invoice in mobile app
1) Find the mentioned invoice. Need to know created by and created date.
2) Find the device who perform the txn.
3) Found that the invoice created by CLT device, huawei. Daphne said it was her.
4) Remove that invoice from db.
Root cause: Invoice created by client, daphne.
None
Description
Hi, pls check, WWX started use mobile app in Feb 2024, how come this invoice in mobile app?
302E/009
History
#1 Updated by Rashdan Hussin 5 months ago
- Status changed from Assigned To to Support In Progress
#2 Updated by Rashdan Hussin 5 months ago
- Status changed from Support In Progress to Pending Client Verification
- Actual Initial Response set to 22/04/2024
- Resolution updated (diff)
select * from customer where customer_code = '302E/009'
select * from member where member_cd = 'wwx'
select * from txn_invoice_history_header where org_id = 'goldcrest' and customer_id = '66B98EA957E646979C546DA333A76CAD' order by invoice_date
--and invoice_no = 'inwwx000003-231204'
select at_date, at_type, * from txn_invoice_history_header_at where org_id = 'goldcrest'
and invoice_id = '6bbcfae1-49f8-4a10-bc11-e7b967558e27'
--and customer_id = '66B98EA957E646979C546DA333A76CAD'
select * from txn_mobile_check_in where created_by = 'dc954dfdc1db4e2aaf9d2759a1522725' order by check_in_date
select * from txn_mobile_header where created_by = 'dc954dfdc1db4e2aaf9d2759a1522725' order by created_date
select * from sync_mobile_token where member_id = 'dc954dfdc1db4e2aaf9d2759a1522725' order by created_date
--select * from txn_invoice_history_header where org_id = 'goldcrest' and invoice_no = 'inwwx000003-231204'
--select * into DMS_Ecosystem_Backup_Table.dbo._txn_invoice_history_header_20240422
--from DMS_EcoSystem.dbo.txn_invoice_history_header
--delete from txn_invoice_history_header where org_id = 'goldcrest' and invoice_no = 'inwwx000003-231204'
--select * from txn_invoice_history_detail where org_id = 'goldcrest' and invoice_id = '6bbcfae1-49f8-4a10-bc11-e7b967558e27'
--select * into DMS_Ecosystem_Backup_Table.dbo._txn_invoice_history_detail_20240422
--from DMS_EcoSystem.dbo.txn_invoice_history_detail
--delete from txn_invoice_history_detail where org_id = 'goldcrest' and invoice_id = '6bbcfae1-49f8-4a10-bc11-e7b967558e27'
--select * from txn_sales_order_header where ord_hdr_id = '3fe639d4-8695-45de-b5ec-184890f0c6ec'
--select * into DMS_Ecosystem_Backup_Table.dbo._txn_sales_order_header_20240422
--from DMS_EcoSystem.dbo.txn_sales_order_header
--delete from txn_sales_order_header where ord_hdr_id = '3fe639d4-8695-45de-b5ec-184890f0c6ec'
--select * from txn_sales_order_details where ord_hdr_id = '3fe639d4-8695-45de-b5ec-184890f0c6ec'
--select * into DMS_Ecosystem_Backup_Table.dbo._txn_sales_order_details_20240422
--from DMS_EcoSystem.dbo.txn_sales_order_details
--delete from txn_sales_order_details where ord_hdr_id = '3fe639d4-8695-45de-b5ec-184890f0c6ec'
#3 Updated by Rashdan Hussin 5 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- % Done changed from 0 to 100