Project

General

Profile

Production Ticket(ST) #12112

SNEKKU - help amend paid amt IN24/012275 and add CN

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

Status:
Ticket Resolved
Priority:
P3 - Medium
Assignee:
Rashdan Hussin
Start date:
28/06/2024
Due date:
02/07/2024
% Done:

100%

Estimated time:
Spent time:
1.00 h
Job Remark:
Ticket Logged Date:
28/06/2024
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
28/06/2024
SLA Delivery:
02/07/2024
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
28/06/2024
Resolution:

1) Patch the all the collection details based on the user request.

Root cause: User do amendment at mysoft.

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

None

Description

hi @Azhar MCC for CCMS1000014 please help amend paid amt IN24/012275 and add CN as missed out change in mysoft, thanks

51e2be27-2c7d-4ea4-b177-183bed5091e8.jpg (134 KB) 51e2be27-2c7d-4ea4-b177-183bed5091e8.jpg Rashdan Hussin, 28/06/2024 11:11 AM

History

#1 Updated by Rashdan Hussin 3 months ago

  • Status changed from Assigned To to Support In Progress

select * from txn_invoice_history_header where invoice_no = 'IN24/012275'

select * from txn_credit_note_history_header where credit_note_no = 'CN24/002959'

select * from txn_mobile_collection_header where col_no like '%CCMS1000014%'

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

--update txn_mobile_collection_header set total_cn_amt = '6.20', total_col_amt = '607.2', updated_date = getdate(), updated_by = 'Support'
--where col_id = '83c03022-81e1-4827-9740-d49c99ed4078'

select * from txn_mobile_collection_detail where col_id = '83c03022-81e1-4827-9740-d49c99ed4078'

--select * into DMS_Ecosystem_Backup_Table.dbo._txn_mobile_collection_detail_20240628 from DMS_EcoSystem.dbo.txn_mobile_collection_detail

--insert into txn_mobile_collection_detail values
--(newid(), '83c03022-81e1-4827-9740-d49c99ed4078', 'CN', 'CN24/002959',
--'6.20', '2024-05-03 00:00:00.000', '0', 'Approved',
--'', 'SNEKKU', 'SNEKKU', getdate(),
--'Support', getdate(), 'Support', NULL, NULL, NULL, '6.20', '', '', '', '')

select * from txn_mobile_collection_invoice where col_id = '83c03022-81e1-4827-9740-d49c99ed4078' and inv_id = '7E03F3F4729947C69F305965A4623B11'

--select * into DMS_Ecosystem_Backup_Table.dbo._txn_mobile_collection_invoice_20240628 from DMS_EcoSystem.dbo.txn_mobile_collection_invoice

--update txn_mobile_collection_invoice set col_amt = previous_balance, new_balance = '0', updated_date = getdate(), updated_by = 'Support', web_paid = previous_balance, web_new_balance = '0'
--where col_id = '83c03022-81e1-4827-9740-d49c99ed4078' and inv_id = '7E03F3F4729947C69F305965A4623B11'

#2 Updated by Rashdan Hussin 3 months ago

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

Also available in: Atom PDF