Production Ticket(ST) #11954
GOLDCREST - mobile didn't show this inwwx000798-230412
1) Check the invoice in mobile db and sql db.
2) Integration already revert the invoice amount to the correct amount.
Root cause: Invoice already have collection but the collection was deleted.
None
Description
History
#1 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
- -- This is the customer reported that this particular invoice is not shown in the mobile
select * from txn_invoice_history_header where invoice_no= 'INWWX000798-240412'
-- 8a18680f-83f9-46fa-8a97-7346e83c4182 this is the collection id
select 'invoice',at_date,at_type,* from txn_invoice_history_header_at a where invoice_no= 'INWWX000798-240412' order by a.at_date desc
-- as I checked in the at table invoice balance is 0 where this invoice has been knock off
select 'collection',at_date,at_type,* from txn_mobile_collection_invoice_at a where inv_id= '8a18680f-83f9-46fa-8a97-7346e83c4182' order by a.at_date desc
-- I notice that fc4fc14b-5dd1-4e70-a461-031d0de7511a ,ef633f8e-fca2-4474-953b-afcaa9e5b8e7 has been deleted on this invoice
select a.at_date,a.at_type,a.updated_by,* from txn_mobile_collection_header_at a where col_id IN ( 'fc4fc14b-5dd1-4e70-a461-031d0de7511a','ef633f8e-fca2-4474-953b-afcaa9e5b8e7')
order by a.at_date desc
-- CCWWX001111-240510
--CCWWX001110-240510
-- in the at table these 2 invoice has been deleted
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--2)second concern
-- but but how come this collection exist in the INWWX000798-240412 ??
select * from txn_mobile_collection_header where col_no like 'ccwwx000800-240412'
select * from txn_mobile_collection_invoice where col_id= 'ca38f07b-0674-485d-8140-64d3c947217e'
select a.at_date,a.at_type,a.updated_by,* from txn_mobile_collection_header_at a where col_id = ( 'ca38f07b-0674-485d-8140-64d3c947217e')
order by a.at_date desc
select * from txn_invoice_history_header where invoice_id= 'fc0ed8cb-eaac-49d2-a0e0-61c7ca3ffbbd';
select * from txn_invoice_history_header_at where invoice_id= 'fc0ed8cb-eaac-49d2-a0e061c7ca3ffbbd';
--ccwwx000800-240412 this collection is already tied with this invoice INWWX000447-240308
this has to further deep in
#2 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
- Assignee changed from Muhammed Azhar Mohamed Maideen to Rashdan Hussin
#3 Updated by Rashdan Hussin 4 months ago
- Subject changed from Goldrest- Hi pls check, why mobile didn't show this inwwx000798-230412, salesman how to do collection? to GOLDCREST - mobile didn't show this inwwx000798-230412
- Due date changed from 08/06/2024 to 11/06/2024
- Priority changed from P2 - High to P3 - Medium
- Type set to Support Request
- SLA Delivery set to 11/06/2024
#4 Updated by Rashdan Hussin 4 months ago
- Status changed from Assigned To to Support In Progress
select * from txn_invoice_history_header where invoice_no = 'inwwx000798-240412'
select * from txn_invoice_history_header_at where invoice_no like '%inwwx000798%' order by at_date
select * from txn_mobile_collection_invoice where inv_id = '8a18680f-83f9-46fa-8a97-7346e83c4182'
select * from txn_mobile_collection_invoice_at where inv_id = '8a18680f-83f9-46fa-8a97-7346e83c4182' order by at_date
select * from txn_mobile_collection_header where col_id = 'fc4fc14b-5dd1-4e70-a461-031d0de7511a'
select * from txn_mobile_collection_header_at where col_id = 'fc4fc14b-5dd1-4e70-a461-031d0de7511a' order by at_date
--col no CCWWX001111-240510, deleted
select * from txn_mobile_collection_header where col_id = 'ef633f8e-fca2-4474-953b-afcaa9e5b8e7'
select * from txn_mobile_collection_header_at where col_id = 'ef633f8e-fca2-4474-953b-afcaa9e5b8e7' order by at_date
-- col no CCWWX001110-240510, deleted
select * from txn_mobile_collection_header where col_no like '%CCWWX001110%'
select * from txn_mobile_collection_header_at where col_no like '%CCWWX001110%' order by at_date
select * from txn_mobile_collection_invoice where col_id = '8808b986-ec13-4266-9763-f5bcd7b86f1a'
select * from txn_mobile_collection_invoice_at where col_id = '8808b986-ec13-4266-9763-f5bcd7b86f1a' order by at_date
select * from txn_invoice_history_header where invoice_id = 'fef7217f-eb61-4ff1-8cc6-f7af3e1d7d95'
select * from txn_mobile_collection_header where col_no like '%CCWWX001111%'
select * from txn_mobile_collection_header_at where col_no like '%CCWWX001111%' order by at_date
select * from txn_mobile_collection_invoice where col_id = 'c47067e6-a551-4ddf-a8fc-f51177838c2b'
select * from txn_mobile_collection_invoice_at where col_id = 'c47067e6-a551-4ddf-a8fc-f51177838c2b' order by at_date
select * from txn_invoice_history_header where invoice_id = 'C9F6CA620D2C4FBBA8F77D21BD573E79'
--found that CCWWX001110 and CCWWX001111 have two different date
--CCWWX001110-240507 and CCWWX001110-240510 (deleted)
--CCWWX001111-240507 and CCWWX001111-240510 (deleted)
#5 Updated by Rashdan Hussin 4 months ago
- Assignee changed from Rashdan Hussin to Muhammed Azhar Mohamed Maideen
#6 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Assignee changed from Muhammed Azhar Mohamed Maideen to Rashdan Hussin
#7 Updated by Rashdan Hussin 3 months ago
- Status changed from Support In Progress to Pending Client Verification
- % Done changed from 0 to 90
- Actual Initial Response set to 07/06/2024
- Resolution updated (diff)
#8 Updated by Rashdan Hussin 3 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- % Done changed from 90 to 100