Production Ticket(ST) #11762
SNEKKU - why last visit shown 20/05/24 for 10T09, user MC5?
50%
1) Check the transaction for this customer.
2) Found latest transaction by integration.
3) Escalate to level 3. https://app.clickup.com/t/86epd3w5y
Root cause: Last visit date take from latest transaction date.
None
Description
hi @Azhar MCC why last visit shown 20/05/24 for 10T09, user MC5? as last visit should be 07/05/24
History
#1 Updated by Rashdan Hussin 4 months ago
- Status changed from Assigned To to Support In Progress
#2 Updated by Rashdan Hussin 4 months ago
- Status changed from Support In Progress to Escalated to Level 3
- % Done changed from 0 to 50
- Resolution updated (diff)
select * from member where member_cd = 'MC5'
select * from customer where customer_code = '10T09'
select * from txn_mobile_check_in where org_id = 'snekku' and txn_id = 'bfa34c0f-5785-4d04-9583-e2d921dcb729'
select * from txn_mobile_header where customer_id = '7CBAF77916104D6F8055114490F8B7AD' and salesman_id = '3e36c3ad81f5499eab021e41514ab5ce'
order by created_date desc
select * from txn_mobile_collection_header where org_id = 'snekku' and txn_id = '6C6A7378F8D046C8B60C815C8C7D2EBD'
select * from txn_sales_order_header
select * from txn_credit_note_history_header where org_id = 'snekku' and txn_id = '6C6A7378F8D046C8B60C815C8C7D2EBD'
select * from txn_mobile_photo_header where org_id = 'snekku' and txn_id = '6C6A7378F8D046C8B60C815C8C7D2EBD'
select * from sync_mobile_module_configuration where sp_name like '%customer%'
#3 Updated by Rashdan Hussin 3 months ago
- Clickup status: Test
#4 Updated by Rashdan Hussin 3 months ago
- Due date changed from 23/05/2024 to 15/06/2024
- SLA Delivery changed from 23/05/2024 to 15/06/2024
Testing finding in Trial (2/7/2024):
- Org is Goldcrest
- User is WWX
- Customer is 302A/008
- Last check in date for that customer is 2024-06-21
- Then create transaction in txn_mobile_header with created date 2024-07-02 without check in
- Download and check the last visit in mobile
- Found that the last visit date remain from last check in which is 21 Jun 2024
#5 Updated by Rashdan Hussin about 2 months ago
- Status changed from Escalated to Level 3 to Pending Client Verification
#6 Updated by Rashdan Hussin about 2 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- Actual Initial Response set to 21/05/2024
Move to clickup