Production Ticket(ST) #12014
Goldcrest- hi, can help to check why salesman ady key in collection but the unpaid columm still showing outstanding amount?
1) request user to upload database
2) checked the di_table
3) checked the actual table
4) checked the sp_di_mobile_transaction_upload_integration
5) inserted new collection
6) update and recalculate the balance
Root cause- collection did not flow to actual tabl e
None
Description
History
#1 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
select * from txn_invoice_history_header where invoice_no LIKE '%INJNL002102%'
select * from txn_mobile_collection_invoice where inv_id='56dbda62-b8d8-47af-a5db-b2b106a85677'
select * from txn_mobile_collection_invoice_at where inv_id='56dbda62-b8d8-47af-a5db-b2b106a85677'
select * from member where member_cd= 'bry'
select * from txn_type_running_no where type= 'collection' and org_id= 'goldcrest' and member_id= '70fe0d960d204e86b862f88a8038fd10'
as we check from our side we notice that there is no collection has been made on the collection INJNL002102-24062024
Need to verify more with the team
#2 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Status changed from Assigned To to Support In Progress
#3 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Status changed from Support In Progress to Pending Client Verification
- Resolution updated (diff)
#4 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
select * from txn_invoice_history_header where invoice_no LIKE '%INJNL002102%'
select * from di_mobile_txn_collection_header where doc_no= '89ebde2c-44a9-4651-ab2d-bdc1a2a448d5'
select * from txn_mobile_collection_header where col_no = 'CCJNL001923-240612'
select * from di_mobile_txn_collection_header where collection_id= '89ebde2c-44a9-4651-ab2d-bdc1a2a448d5'
select * from txn_mobile_collection_header_at where col_id= '89ebde2c-44a9-4651-ab2d-bdc1a2a448d5'
select * from txn_mobile_collection_invoice where inv_id='1b167895-f220-4464-917d-84b6ddd86bee' --
select a.at_date, a.at_type,* from txn_mobile_collection_invoice_at a where inv_id='1b167895-f220-4464-917d-84b6ddd86bee' order by a.at_date desc
----------------------------------------------------------------------------------------------------------------------------------------------
select * from txn_invoice_history_header where invoice_id='1b167895-f220-4464-917d-84b6ddd86bee'
select * from txn_mobile_collection_invoice where inv_id= '1b167895-f220-4464-917d-84b6ddd86bee' and col_id= '89ebde2c-44a9-4651-ab2d-bdc1a2a448d5'
select * into DMS_Ecosystem_Backup_Table.dbo._txn_invoice_history_header_14062024
from DMS_EcoSystem.dbo.txn_invoice_history_header
select * into DMS_Ecosystem_Backup_Table.dbo._txn_mobile_collection_invoice14062024
from DMS_EcoSystem.dbo.txn_mobile_collection_invoice
update txn_invoice_history_header set invoice_balance= '0.00 ' ,updated_by = 'Support', updated_date = getdate()
WHERE invoice_id='1b167895-f220-4464-917d-84b6ddd86bee'
UPDATE txn_mobile_collection_invoice
SET
previous_balance = '53.00',
new_balance = '0.00' , updated_by = 'Support' ,
updated_date = GETDATE
WHERE
inv_id = '1b167895-f220-4464-917d-84b6ddd86bee'
AND col_id = '89ebde2c-44a9-4651-ab2d-bdc1a2a448d5'
#5 Updated by Muhammed Azhar Mohamed Maideen 3 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- Type set to Support Request
- Actual Initial Response set to 14/06/2024