Project

General

Profile

Production Ticket(ST) #11221

GOLDCREST - collection done on 15/03 but mobile all showing 14/03

Added by Rashdan Hussin 6 months ago. Updated 6 months ago.

Status:
Ticket Resolved
Priority:
P3 - Medium
Assignee:
Muhammed Azhar Mohamed Maideen
Start date:
15/03/2024
Due date:
21/03/2024
% Done:

50%

Estimated time:
Spent time:
1.00 h
Job Remark:
Ticket Logged Date:
15/03/2024
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
15/03/2024
SLA Delivery:
21/03/2024
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
08/04/2024
Resolution:

hi @~Daphne Lee For items 2 and 3, as the database has already been uploaded, the previous collections will not be updated. Therefore the fixes will be implemented for collections after March 21. Let us know if you need further assist on this matter. Thank you

Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:

None

Description

- collection done on 15/03 but mobile all showing 14/03, so datanory and autocount also reflect 14/03
- for issue no.8, as u can see we check in and check out on 15/3, but only collection which show 14/3 17.39pm, all customer on that day like this, can help us check on it? it affect our report cant tally

9bf712a5-ed7f-4898-aad9-b28293056100.jpg (64.8 KB) 9bf712a5-ed7f-4898-aad9-b28293056100.jpg Rashdan Hussin, 15/03/2024 04:01 PM
d053ba4a-7816-42fa-a24c-cb4f7576bb21.jpg (63.9 KB) d053ba4a-7816-42fa-a24c-cb4f7576bb21.jpg Rashdan Hussin, 15/03/2024 04:01 PM
6c3485ce-8ed9-4d02-b6ce-5b22c760ae99.jpg (69.9 KB) 6c3485ce-8ed9-4d02-b6ce-5b22c760ae99.jpg Rashdan Hussin, 18/03/2024 05:07 PM
Screenshot 2024-03-18 170700.png (25.2 KB) Screenshot 2024-03-18 170700.png Rashdan Hussin, 18/03/2024 05:07 PM

History

#1 Updated by Rashdan Hussin 6 months ago

  • Status changed from Assigned To to Support In Progress

#2 Updated by Rashdan Hussin 6 months ago



col_id = ba7ba42e-15b7-4b7d-ad33-faf7513ce947

#3 Updated by Rashdan Hussin 6 months ago

select * from member where org_id = 'goldcrest'

select * from txn_invoice_history_header
where org_id = 'goldcrest' and invoice_balance <> '0.00' and member_id = 'dc954dfdc1db4e2aaf9d2759a1522725'

select * from customer where customer_id = '6840E8225A99463A90002E50CB846F1F'

select * from txn_mobile_collection_header
where org_id = 'goldcrest' and created_by = 'dc954dfdc1db4e2aaf9d2759a1522725' order by created_date desc

select col_id, col_no, total_col_amt, created_date, updated_date from txn_mobile_collection_header
where org_id = 'goldcrest' and col_id = 'ba7ba42e-15b7-4b7d-ad33-faf7513ce947'

#4 Updated by Rashdan Hussin 6 months ago

  • Resolution updated (diff)

#5 Updated by Rashdan Hussin 6 months ago

  • % Done changed from 0 to 50

#6 Updated by Rashdan Hussin 6 months ago

  • Assignee changed from Rashdan Hussin to Muhammed Azhar Mohamed Maideen

- Change shift. Handover to azhar
- Ask update from shu ern

#7 Updated by Muhammed Azhar Mohamed Maideen 6 months ago

Close this ticket

#8 Updated by Muhammed Azhar Mohamed Maideen 6 months ago

  • Status changed from Escalated to Level 3 to Pending Client Verification

#9 Updated by Muhammed Azhar Mohamed Maideen 6 months ago

select * from txn_mobile_collection_header where org_id = 'goldcrest'
and created_by = 'dc954dfdc1db4e2aaf9d2759a1522725'
--and convert(date, created_date) = '2024-03-14'
and created_date = '2024-03-14 17:39:14.000'

#10 Updated by Muhammed Azhar Mohamed Maideen 6 months ago

  • Resolution updated (diff)

#11 Updated by Muhammed Azhar Mohamed Maideen 6 months ago

  • Status changed from Pending Client Verification to Ticket Resolved
  • Actual Initial Response set to 08/04/2024

Also available in: Atom PDF