Project

General

Profile

Production Ticket(ST) #12182

Snekku-Hi @Azhar13 please help to amend CCME1000039, acc missed out, thanks

Added by Muhammed Azhar Mohamed Maideen 3 months ago. Updated 3 months ago.

Status:
Ticket Resolved
Priority:
P3 - Medium
Assignee:
Rashdan Hussin
Start date:
09/07/2024
Due date:
10/07/2024
% Done:

100%

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

1) Patch the collection and all the details follow by the receipt given.

Root cause: Amend the collection.

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

None

eco save kemaman.pdf (15.7 KB) eco save kemaman.pdf Muhammed Azhar Mohamed Maideen, 09/07/2024 10:03 AM

History

#1 Updated by Muhammed Azhar Mohamed Maideen 3 months ago

  • Assignee changed from Muhammed Azhar Mohamed Maideen to Rashdan Hussin

[[]]

#2 Updated by Rashdan Hussin 3 months ago

  • Status changed from Assigned To to Support In Progress

#3 Updated by Rashdan Hussin 3 months ago

  • Status changed from Support In Progress to Pending Client Verification
  • % Done changed from 0 to 90
  • Type set to Support Request
  • SLA Delivery set to 10/07/2024
  • Actual Initial Response set to 09/07/2024
  • Resolution updated (diff)

select * from txn_invoice_history_header where invoice_no = 'IN24/011836'
select * from txn_invoice_history_header where invoice_no = 'IN24/012699'

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

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

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

--update txn_mobile_collection_header set total_cn_amt = 640.00, total_col_amt = 3068, updated_date = getdate(), updated_by = 'Support'
--where col_id = '4ee252b4-9299-433f-8722-6783f1ed576f'

select * from txn_mobile_collection_detail where col_id = '4ee252b4-9299-433f-8722-6783f1ed576f'

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

--insert into txn_mobile_collection_detail values
--(newid(), '4ee252b4-9299-433f-8722-6783f1ed576f', 'CN', 'CN24/003849',
--640.00, '2024-06-06 00:00:00.000', '0', 'Approved',
--'', 'SNEKKU', 'SNEKKU', getdate(),
--'Support', getdate(), 'Support', NULL, NULL, NULL, 640.00, '', '', '', '')

select * from txn_mobile_collection_invoice where col_id = '4ee252b4-9299-433f-8722-6783f1ed576f'

--select * into DMS_Ecosystem_Backup_Table.dbo._txn_mobile_collection_invoice_20240709 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'

--insert into txn_mobile_collection_invoice values
--(newid(), '4ee252b4-9299-433f-8722-6783f1ed576f', 'FB93F057F237442EA0A22F31D109FE00', '',
--640.00, 640.00, 0, 'Approved', getdate(), 'Support', getdate(), 'Support', 'SNEKKU', 'SNEKKU',
--NULL, NULL, 640.00, 0)

#4 Updated by Rashdan Hussin 3 months ago

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

Also available in: Atom PDF