Datanory Production » Datanory - SNEKKU

hi arif this is the issue where the collection number is different but the invoice details are same.
As we checked in the data base all the details are diffferent. So We claimed that it could be the mobile issue. Need to further check on this

select * from txn_mobile_collection_invoice i
inner join txn_mobile_collection_header h on h.col_id = i.col_id
inner join txn_invoice_history_header ih on ih.invoice_id = i.inv_id
where h.col_id in (
select * from txn_mobile_collection_header
where col_no in (
'CCMN5000011-240418',
'CCMN5000010-240418'

)
)
order by i.created_date desc

select * from txn_mobile_collection_header
where col_id in (
'4d89c1de-442d-4955-8818-0b2668f45c67'

)

select * from di_mobile_txn_collection_invoices_at
select * from txn_mobile_collection_invoice where inv_id in('2708F905089548C2B0FBE3FE829DE73E','43A75970CED444ADA40B0413084AFA09','5C27315CCF294864847963981335EC61','8534F5FACCC842AB946B2CF45BA47842','8E8F219D54AF44E8B20994E3E7AFA650' )

-- this invoice are on CCMN5000010-240418
select * from txn_invoice_history_header where invoice_no in('in24/007023','in24/006561','in24/007411','in24/005779','in24/007684' )
--2708F905089548C2B0FBE3FE829DE73E
--43A75970CED444ADA40B0413084AFA09
--5C27315CCF294864847963981335EC61
--8534F5FACCC842AB946B2CF45BA47842
--8E8F219D54AF44E8B20994E3E7AFA650

Select * from txn_mobile_collection_header where col_no= 'CCMN5000011-240418'
Select * from txn_mobile_collection_header where col_no= 'CCMN5000010-240418'

escalate to azhar
end shift
need to test