Production Ticket(ST) #11838
SNEKKU - this cancelled is do by sales team or?
1) Check the collection at our side.
2) Created by and updated by is integration.
3) Check at mysoft.
4) Found the collection created and cancelled at their side.
Root cause: Collection created and cancelled at their side.
None
Description
and this cancelled is do by sales team or?
but collection number CCME5, but salesman code is ME3
History
#1 Updated by Rashdan Hussin 4 months ago
select * from customer where customer_code = '5K033'
select * from txn_invoice_history_header where customer_id = 'E948B83EFFC44F83B7418C9C50B444CE' order by invoice_balance
select * from txn_mobile_collection_invoice where inv_id = 'A6FFD75844B443ECBC49FD88DD38832E' order by created_date
select * from txn_invoice_history_header where invoice_id = 'A6FFD75844B443ECBC49FD88DD38832E'
select * from txn_invoice_history_header_at where invoice_id = 'A6FFD75844B443ECBC49FD88DD38832E' order by at_date
select * from txn_mobile_collection_invoice where inv_id = 'A6FFD75844B443ECBC49FD88DD38832E' order by created_date
select * from txn_mobile_collection_header where col_id = 'D1E4F5C165AC41AA9EDDE35421352EBB'
select * from txn_mobile_Collection_header where col_no = 'CCMC8000024-CHEQUE2'
select * from txn_mobile_collection_header where col_no like '%CCMN9000006%'
select * from txn_mobile_collection_header_at where col_no like '%CCMN9000006%'
select * from txn_mobile_collection_detail where col_id = '325A67C1C6CA4C59A5E4165387A14891'
select * from txn_mobile_collection_invoice where col_id = '325A67C1C6CA4C59A5E4165387A14891'
select * from txn_mobile_collection_header where col_no LIKE 'CC%' and created_by = 'INTEGRATION_API' order by col_no
select * from txn_mobile_collection_header where col_no LIKE '%CCMC000001%'
#2 Updated by Rashdan Hussin 4 months ago
- Subject changed from Snekku to SNEKKU - this cancelled is do by sales team or?
- Status changed from Assigned To to Support In Progress
- collection come from mysoft and already cancel at mysoft
#3 Updated by Rashdan Hussin 4 months ago
select apibatchno, apitype, IsCanceled, * from arpaymententry
where voucherno in ('CCMN3000011', 'CCMN9000006', 'CCMN9000008', 'CCMN3000013', 'CCMN3000009', 'CCMN9000012', 'CCMN3000014', 'CCMN9000010', 'CCMN9000002', 'CCMN5000012')
#4 Updated by Rashdan Hussin 4 months ago
- Status changed from Support In Progress to Pending Client Feedback
#5 Updated by Rashdan Hussin 4 months ago
- Status changed from Pending Client Feedback to Ticket Resolved
- % Done changed from 0 to 100
- Type set to Support Request
- Actual Initial Response set to 28/05/2024
- Resolution updated (diff)