Project

General

Profile

Production Ticket(ST) #11837

SNEKKU - web not have these collection

Added by Muhammed Azhar Mohamed Maideen 4 months ago. Updated 4 months ago.

Status:
Ticket Resolved
Priority:
P2 - High
Assignee:
Muhammad Arif
Start date:
28/05/2024
Due date:
30/05/2024
% Done:

100%

Estimated time:
Job Remark:
Ticket Logged Date:
28/05/2024
Ticket No.:
Related Ticket ID:
Type:
SLA Initial Response:
28/05/2024
SLA Delivery:
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
Resolution:
Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:

None

Description

CCMC2000010
CCMC4000006
CCMC9000010 / 11 / 12 / 14
CCME1000019 / 20
CCMS0000006 / 7 / 8
CCMS2000024 / 25 / 33
CCMS3000005
CCMS6000022
please check whether same case with yesterday informed, sales team done collection but web not shown

Please settle as fast as possible, as this caused acc department not shown the collection but in fact sales team done it

History

#1 Updated by Rashdan Hussin 4 months ago

  • Subject changed from Snekku- hi @Rashdan Hussin MCC above are web not have these collection to SNEKKU - web not have these collection
  • Status changed from Assigned To to Support In Progress

select * from customer where customer_code = '5S009'
select * from member where member_cd = 'MC2'

select * from di_mobile_txn_collection_header where doc_no like '%CCME1000019%'
select * from txn_mobile_collection_header where col_no like '%CCME1000020-240520%'
select * from txn_mobile_collection_header_at where col_no like '%CCMS0000008%'

--CCME1000019, CCME1000020, CCMS0000008, CCMS2000033 have in di

--CCME1000019
select * from txn_invoice_history_header where invoice_id = '7993FCBBFBEA4ABC8CEAFFC5550CA423'
select * from txn_invoice_history_header_at where invoice_id = '7993FCBBFBEA4ABC8CEAFFC5550CA423' order by at_date
select * from txn_mobile_collection_invoice where inv_id = '7993FCBBFBEA4ABC8CEAFFC5550CA423'
select * from txn_mobile_collection_header where col_id = '2273FD6F576F4EC68B6E0ED85C00FFFC' --CN23/007494 cancel

select * from txn_invoice_history_header where invoice_id = 'DABB0CC70FEE45A299FE21FCA44DF6AC'
select * from txn_invoice_history_header_at where invoice_id = 'DABB0CC70FEE45A299FE21FCA44DF6AC' order by at_date
select * from txn_mobile_collection_invoice where inv_id = 'DABB0CC70FEE45A299FE21FCA44DF6AC'
select * from txn_mobile_collection_header where col_id = 'E0228684148E47A5BB4FF7B85846C3CE' --CN23/009289 cancel

--CCME1000020 okay but same process id with CCME1000019

--CCMS0000008
select * from txn_invoice_history_header where invoice_id = 'DD8EEAA6D917460BB8EC1829B591B35F'
select * from txn_invoice_history_header_at where invoice_id = 'DD8EEAA6D917460BB8EC1829B591B35F' order by at_date
select * from txn_mobile_collection_invoice where col_id = '956b26ce-a72f-496f-98b7-ce3156f4aecc'
select * from txn_mobile_collection_invoice_at where inv_id = 'DD8EEAA6D917460BB8EC1829B591B35F' order by at_date
select * from txn_mobile_collection_header where col_id = '956b26ce-a72f-496f-98b7-ce3156f4aecc'
select * from txn_mobile_collection_detail where col_id = '956b26ce-a72f-496f-98b7-ce3156f4aecc' --CN24/002270

--CCMS2000033
select * from txn_invoice_history_header where invoice_id = '3B0C6E99E2DB43D19830F61B72DF838F'
select * from txn_invoice_history_header_at where invoice_id = '3B0C6E99E2DB43D19830F61B72DF838F' order by at_date
select b.col_no, c.invoice_no, * from txn_mobile_collection_invoice a
inner join txn_mobile_collection_header b on b.col_id = a.col_id
inner join txn_invoice_history_header c on c.invoice_id = a.inv_id
where a.inv_id = '3B0C6E99E2DB43D19830F61B72DF838F'
select * from txn_mobile_collection_header where col_id = '54a1a28d-390d-4c83-81e2-2d37560155aa' --CCMS2000022 cancel

select * from stg_accounting_import_collection where doc_no like '%CCMC2000010%'

#2 Updated by Rashdan Hussin 4 months ago

  • Assignee changed from Rashdan Hussin to Muhammad Arif

#3 Updated by Muhammad Arif 4 months ago

  • Due date changed from 29/05/2024 to 30/05/2024
  • Status changed from Support In Progress to Pending Client Verification
  • % Done changed from 0 to 100

Hi @~Leewei , kindly refer the above information regarding to the collection issue.
FYI, skipped running number issue has been fixed on 9 May 2024.
but user's application updated on 10 May 2024

#4 Updated by Muhammad Arif 4 months ago

  • Status changed from Pending Client Verification to Ticket Resolved

Also available in: Atom PDF