Project

General

Profile

Production Ticket(ST) #11832

SNEKKU - unpaid got negative amount

Added by Rashdan Hussin 4 months ago. Updated 4 months ago.

Status:
Ticket Resolved
Priority:
P3 - Medium
Assignee:
Muhammad Arif
Start date:
27/05/2024
Due date:
29/05/2024
% Done:

100%

Estimated time:
Job Remark:
Ticket Logged Date:
27/05/2024
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
27/05/2024
SLA Delivery:
29/05/2024
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
29/05/2024
Resolution:

Root cause due to double collection
solution: add checking

Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:

None

Description

Hi @Rashdan Hussin why unpaid got negative amount?

b92a743a-f8ff-41a1-8b51-7ed1e9bb7a11.jpg (37.3 KB) b92a743a-f8ff-41a1-8b51-7ed1e9bb7a11.jpg Rashdan Hussin, 27/05/2024 04:59 PM

History

#1 Updated by Rashdan Hussin 4 months ago

  • Status changed from Assigned To to Support In Progress

select * from customer where customer_code = '5K033'

select * from txn_invoice_history_header where customer_id = 'E948B83EFFC44F83B7418C9C50B444CE' order by invoice_balance

select * from txn_mobile_collection_invoice where inv_id = 'A6FFD75844B443ECBC49FD88DD38832E' order by created_date

select * from txn_mobile_collection_invoice where inv_id = '58C2A6594919444F8F516C732B4D7FB5' order by created_date

select * from txn_invoice_history_header where invoice_id = 'F9A1D17083F8436E8871C36F38C56272'
select * from txn_invoice_history_header_at where invoice_id = 'F9A1D17083F8436E8871C36F38C56272' order by at_date
select * from txn_mobile_collection_invoice where inv_id = 'F9A1D17083F8436E8871C36F38C56272' order by created_date
select * from txn_mobile_collection_invoice_at where inv_id = 'F9A1D17083F8436E8871C36F38C56272' order by at_date

- Seems come from integration

#2 Updated by Rashdan Hussin 4 months ago

- the negative invoice due to collection from mysoft

#3 Updated by Rashdan Hussin 4 months ago

  • Assignee changed from Rashdan Hussin to Muhammad Arif

#4 Updated by Muhammad Arif 4 months ago

Shan You already fix the issue, for now, need to patch previous data

#5 Updated by Muhammad Arif 4 months ago

  • Status changed from Support In Progress to Pending Client Verification
  • Actual Initial Response set to 29/05/2024
  • Resolution updated (diff)

select * from txn_invoice_history_header where invoice_balance < 0 and org_id='snekku'

select * from txn_invoice_history_header where customer_id = 'E948B83EFFC44F83B7418C9C50B444CE'
and invoice_balance < 0
order by invoice_balance

select * from customer_to_user_relation where customer_id = 'E948B83EFFC44F83B7418C9C50B444CE'
select * from member where member_id='c031006c0d8a4963810e7a9996d49125'
--update txn_invoice_history_header set invoice_balance=0.00 where customer_id = 'E948B83EFFC44F83B7418C9C50B444CE'
--and invoice_balance < 0
--order by invoice_balance

select * into DMS_Ecosystem_Backup_Table.dbo.txn_invoice_history_header_20240529v1 from txn_invoice_history_header where invoice_balance < 0 and org_id='snekku'

#6 Updated by Muhammad Arif 4 months ago

  • Status changed from Pending Client Verification to Ticket Resolved
  • % Done changed from 0 to 100

Also available in: Atom PDF