Production Ticket(ST) #12102
Snekku - hi @Azhar13 CCMN1000003, help add on CN24/003116 = 38.91, invoice paid change to 1817.64
100%
None
Description
hi @Azhar13 CCMN1000005 please help reject and our acc will manual do it mysoft this collection number under cancelled status ya
this is double collection issue, but why same invoice can issue 2 collection ya
History
#1 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
select a.at_type, a.at_date,a.updated_by,created_by,* from txn_mobile_collection_header_at a where col_no like '%CCMN1000005%' order by a.at_date desc
select a.at_type, a.at_date,a.updated_by,created_by,* from txn_mobile_collection_header_at a where col_no like '%ccmn1000003%' order by a.at_date desc
#2 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
select a.at_type, a.at_date,a.updated_by,updated_date,created_by,created_date,* from txn_mobile_collection_header_at a where col_no like '%CCMN1000003%' order by a.at_date desc
select a.at_type, a.at_date,a.updated_by,updated_date,created_by,created_date,* from txn_mobile_collection_header_at a where col_no like '%CCMN1000005%' order by a.at_date desc
-- in the at table we notice that the created date
-- as I checked the created date are different
select * from txn_mobile_collection_header where col_no like '%ccmn1000003%'
select * from txn_mobile_collection_header where col_no like '%CCMN1000005%'
select * from txn_mobile_collection_detail where col_id = '640c0de7-d21a-4f25-9bbb-e8791737e776'
select * from txn_mobile_collection_detail where col_id = '05bcf07b-a60b-4419-b3fc-572c3eef73f7'
-- collection detail_ id is different but amount is same
select * from txn_mobile_collection_invoice where col_id= '640c0de7-d21a-4f25-9bbb-e8791737e776'--ccmn1000003
select * from txn_mobile_collection_invoice where col_id= '05bcf07b-a60b-4419-b3fc-572c3eef73f7'-- CCMN1000005
-- one invoice have multiple collection
select * from txn_invoice_history_header where invoice_id= 'CD28C2F56FD043E580FD181E2B08C3C5'--ccmn1000003
select * from txn_invoice_history_header where invoice_id= 'CD28C2F56FD043E580FD181E2B08C3C5'--CCMN1000005
-- have to check why these 2 collection have same invoice
#3 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Status changed from Assigned To to Support In Progress
hi miss tee since this collection is still in pending status you may perform amendment for the collection CCMN1000003-240625 in the portal itself. May I know is they any concern if the amendment done from your side as we checked from our side, the amendment can be done via portal for this collection , Let us know if you need further assistance on this matter thank you
Personal Message with lee wei
As I checked user canmak an amendment via web portal
w
#4 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Status changed from Support In Progress to Pending Client Feedback
#5 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- File collection_snekku_6.txt collection_snekku_6.txt added
- Status changed from Pending Client Feedback to Support In Progress
- Assignee changed from Muhammed Azhar Mohamed Maideen to Muhammad Arif
HI arif as per discussed , this collection has been patched but unfortunately the data seems incorrect
Need your assistance on this matter and need to verification on this ticket
#6 Updated by Muhammad Arif 3 months ago
- Status changed from Support In Progress to Pending Client Verification
HI @~Leewei , as per requested, the collection CCMN1000003-240625 has been amended. Please check and verify from our side and let us know if the problem is still persist. Thank you
#7 Updated by Muhammad Arif 3 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- % Done changed from 0 to 100