Production Ticket(ST) #11485
snekku - Hi morning, may I know why some of transaction not show cheque date ?
There are two types of cheques: P/D Cheque and Cheque. Currently, only the 'Cheque' type is being captured, which is why it does not appear in the list. This issue has already been escalated to the technical team for resolution."
root cause- bug
https://app.clickup.com/t/86ep577et
None
Description
History
#1 Updated by Muhammed Azhar Mohamed Maideen 5 months ago
- Status changed from Assigned To to Support In Progress
#2 Updated by Muhammed Azhar Mohamed Maideen 5 months ago
- Status changed from Support In Progress to Escalated to Level 3
- Resolution updated (diff)
SELECT *
FROM txn_mobile_collection_header th
INNER JOIN txn_mobile_collection_detail td ON th.col_id = td.col_id
WHERE td.doc_type IN ('P/D Cheque', 'Cheque') AND th.sync_date IS NULL AND th.temporary_receipt IS NULL
ORDER BY th.created_date DESC;
select * from member where org_id= 'snekku'
-----------------------------------------
script from store procedure
exec sp_executesql N'web_spTxnCollectionApprovalDataRetriveList @org_id, @member_id, @module',N'@org_id nvarchar(6),@member_id nvarchar(12),@module nvarchar(4000)',
@org_id=N'SNEKKU',@member_id=N'SNEKKU-admin',@module=N''
----------------------------------------------------
#3 Updated by Muhammed Azhar Mohamed Maideen 5 months ago
- Status changed from Escalated to Level 3 to Pending Client Verification
#4 Updated by Muhammed Azhar Mohamed Maideen 5 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- Type set to Support Request
- Actual Initial Response set to 18/04/2024