Production Ticket(ST) #11892
SNEKKU - why got negative ya
1) Check the invoice history.
2) Check the collection invoice history.
3) Check the collection at mysoft db.
Root cause: The invoice has collection previously but cancelled in mysoft.
None
Description
History
#1 Updated by Muhammed Azhar Mohamed Maideen 4 months ago
- Assignee changed from Muhammed Azhar Mohamed Maideen to Rashdan Hussin
#2 Updated by Rashdan Hussin 4 months ago
- Subject changed from Snekku- hi @Azhar13 why got negative ya to SNEKKU - why got negative ya
- Status changed from Assigned To to Support In Progress
- Type set to Support Request
select * from txn_invoice_history_header where invoice_no = 'IN24/009493'
select * from txn_invoice_history_header_at where invoice_no = 'IN24/009493' order by at_date
select * from txn_mobile_collection_invoice where inv_id = '3B0C6E99E2DB43D19830F61B72DF838F'
select * from txn_mobile_collection_invoice_at where inv_id = '3B0C6E99E2DB43D19830F61B72DF838F' order by at_date
select * from txn_mobile_collection_header where col_id = '438077e7-61c6-462f-958c-e5b3ff349b1b'
select * from txn_mobile_collection_header_at where col_id = '438077e7-61c6-462f-958c-e5b3ff349b1b' order by at_date
- now invoice balance for IN24/009493 is 0.00
#3 Updated by Rashdan Hussin 4 months ago
- Status changed from Support In Progress to Pending Client Verification
- % Done changed from 0 to 90
- SLA Delivery set to 04/06/2024
- Actual Initial Response set to 31/05/2024
- Resolution updated (diff)
#4 Updated by Rashdan Hussin 4 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- % Done changed from 90 to 100