Project

General

Profile

Production Ticket(ST) #11709

SNEKKU - Issue of collection in web

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

Status:
Ticket Resolved
Priority:
P2 - High
Assignee:
Rashdan Hussin
Start date:
14/05/2024
Due date:
15/05/2024
% Done:

100%

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

1) Patch the doc_type for credit note in collection detail
2) Patch the total_cheque_amt and total_cn_amt in collection header

Root cause: Backend bug.

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

None

Description

- Found some collections details were not correct.
- Admin use cheque and CN to knock off invoices but CN was recognize as collection, instead of CN.
- So the CN amount was combined with cheque amount.
- Suppose the CN and cheque amount and doc type are separated.

The collections are:
CCMS000004-240509
CCMS2000020-240502
CCMS000005-240509
CCMS2000023-240508

History

#1 Updated by Rashdan Hussin 4 months ago

  • Status changed from Assigned To to Support In Progress

--select * into DMS_Ecosystem_Backup_Table.dbo._txn_mobile_collection_header_20240514
--from DMS_EcoSystem.dbo.txn_mobile_collection_header

select * from txn_mobile_collection_header where col_id in (
select col_id from txn_mobile_collection_detail where doc_type in (
'14.95',
'3.70',
'41.05',
'73.63'
))

select * from txn_mobile_collection_header where col_no = 'ccms2000023-240508'

select * from txn_mobile_collection_detail where col_id = 'ebae35fe-21a3-4260-b068-f90ad106ab1e' --14479.56
select * from txn_mobile_collection_header where col_id = 'ebae35fe-21a3-4260-b068-f90ad106ab1e' --14479.56
--update txn_mobile_collection_header set total_cheque_amt = '14464.61', total_cn_amt = '14.95', sync_date = NULL
--where col_id = 'ebae35fe-21a3-4260-b068-f90ad106ab1e'

select * from txn_mobile_collection_detail where col_id = '4a418975-44ef-44d6-99c6-77b20cd81141' --2463.00
select * from txn_mobile_collection_header where col_id = '4a418975-44ef-44d6-99c6-77b20cd81141' --2463.00
--update txn_mobile_collection_header set total_cheque_amt = '2418.25', total_cn_amt = '44.75', sync_date = NULL
--where col_id = '4a418975-44ef-44d6-99c6-77b20cd81141'

select * from txn_mobile_collection_detail where col_id = '5afebf04-8c53-4d60-a8d6-7b0eb58eed15' --18345.60
select * from txn_mobile_collection_header where col_id = '5afebf04-8c53-4d60-a8d6-7b0eb58eed15' --18345.60
--update txn_mobile_collection_header set total_cheque_amt = '18271.97', total_cn_amt = '73.63', sync_date = NULL
--where col_id = '5afebf04-8c53-4d60-a8d6-7b0eb58eed15'

select * from txn_mobile_collection_detail where col_id = 'ca52c745-c8de-4181-b927-e8d56dc2de81' --18253.15
select * from txn_mobile_collection_header where col_id = 'ca52c745-c8de-4181-b927-e8d56dc2de81' --18253.15
--update txn_mobile_collection_header set total_cheque_amt = '18216.44', total_cn_amt = '36.71', sync_date = NULL
--where col_id = 'ca52c745-c8de-4181-b927-e8d56dc2de81'

#2 Updated by Rashdan Hussin 4 months ago

  • Status changed from Support In Progress to Ticket Resolved
  • % Done changed from 0 to 100
  • Actual Initial Response set to 14/05/2024
  • Resolution updated (diff)

Also available in: Atom PDF