Project

General

Profile

Production Ticket(ST) #12076

SNEKKU - both issue is amend invoice amount, due to add on cn in mysoft ya

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

Status:
Ticket Resolved
Priority:
P3 - Medium
Assignee:
Rashdan Hussin
Start date:
21/06/2024
Due date:
29/06/2024
% Done:

100%

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

1) checked in the database

2) checked user report collection(mysoft)

3) patching has been done

Root cause- Support request

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

None

ccmc000019.pdf (18.2 KB) ccmc000019.pdf Muhammed Azhar Mohamed Maideen, 21/06/2024 03:05 PM
ccmc1000010 1.pdf (15.7 KB) ccmc1000010 1.pdf Muhammed Azhar Mohamed Maideen, 21/06/2024 03:05 PM

History

#1 Updated by Muhammed Azhar Mohamed Maideen 3 months ago

  • Status changed from Assigned To to Support In Progress

#2 Updated by Muhammed Azhar Mohamed Maideen 3 months ago

  • Status changed from Support In Progress to Pending Client Verification
  • Resolution updated (diff)

select * from txn_mobile_collection_header where col_no like '%ccmc000019%'
select * from txn_mobile_collection_detail where col_id like '%697ed949-5804-4c54-b5a8-fb94b3d4a6d2%'
select * from txn_mobile_collection_invoice where col_id like '%697ed949-5804-4c54-b5a8-fb94b3d4a6d2%'
select * from txn_mobile_collection_invoice where col_id like '%697ed949-5804-4c54-b5a8-fb94b3d4a6d2%' and inv_id= '8A82BD272BB8409ABD386931CE1A66DC'
select * from txn_invoice_history_header where invoice_id= '8A82BD272BB8409ABD386931CE1A66DC'
-- UPDATE txn_mobile_collection_invoice SET new_balance = '0.00', updated_by = 'Support', updated_date = GETDATE
--WHERE col_id = '697ed949-5804-4c54-b5a8-fb94b3d4a6d2'
--AND inv_id = '8A82BD272BB8409ABD386931CE1A66DC';

select * from txn_credit_note_history_header where credit_note_no like '%CN24/003541%'

select * into DMS_Ecosystem_Backup_Table.dbo._txn_invoice_history_header_21062024
from DMS_EcoSystem.dbo.txn_invoice_history_header

select * into DMS_Ecosystem_Backup_Table.dbo._txn_mobile_collection_invoice_21062024
from DMS_EcoSystem.dbo.txn_mobile_collection_invoice

select * from txn_mobile_collection_header where col_no like '%CCMC1000010%'
select * from txn_mobile_collection_detail where col_id like '%d0682715-602d-44af-a6e0-085277130a5a%'
select * from txn_mobile_collection_invoice where col_id like '%d0682715-602d-44af-a6e0-085277130a5a%' and inv_id= '205EDB7CDDFC4F1980299D3FD6C452A3'
select * from txn_invoice_history_header where invoice_id= '205EDB7CDDFC4F1980299D3FD6C452A3'

--update txn_mobile_collection_invoice set new_balance= '0.00', updated_by = 'Support',
-- updated_date = GETDATE where col_id like '%d0682715-602d-44af-a6e0-085277130a5a%' and inv_id= '205EDB7CDDFC4F1980299D3FD6C452A3'

#3 Updated by Muhammed Azhar Mohamed Maideen 3 months ago

  • Assignee changed from Muhammed Azhar Mohamed Maideen to Rashdan Hussin

#4 Updated by Rashdan Hussin 3 months ago

  • Subject changed from Snekku- hi @Azhar13 both issue is amend invoice amount, due to add on cn in mysoft ya to SNEKKU - both issue is amend invoice amount, due to add on cn in mysoft ya
  • Due date changed from 24/06/2024 to 29/06/2024
  • Priority changed from P2 - High to P3 - Medium
  • % Done changed from 0 to 90
  • Type set to Support Request
  • SLA Delivery set to 29/06/2024
  • Actual Initial Response set to 21/06/2024

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

select * from txn_credit_note_history_header where credit_note_no in ('CN24/002817', 'CN24/002479')

--select * into DMS_Ecosystem_Backup_Table.dbo._txn_credit_note_history_header_20240629 from DMS_EcoSystem.dbo.txn_credit_note_history_header

--update txn_credit_note_history_header set credit_note_balance = '0', updated_date = getdate(), updated_by = 'Support'
--where credit_note_header_id = 'EE00CA0686E94846896BEBC5188E3BA9'

select * from txn_mobile_collection_header where col_no = 'CCMC1000010-240619'

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

--update txn_mobile_collection_header set total_cn_amt = '105.8', total_col_amt = '841.2', updated_date = getdate(), updated_by = 'Support'
--where col_id = 'd0682715-602d-44af-a6e0-085277130a5a'

select * from txn_mobile_collection_detail where col_id = 'd0682715-602d-44af-a6e0-085277130a5a'

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

--insert into txn_mobile_collection_detail values
--(newid(), 'd0682715-602d-44af-a6e0-085277130a5a', 'CN', 'CN24/002817',
--'5.80', '2024-04-26 00:00:00.000', '0', 'Approved',
--'', 'SNEKKU', 'SNEKKU', getdate(),
--'Support', getdate(), 'Support', NULL, NULL, NULL, '5.80', '', '', '', '')

select * from txn_mobile_collection_invoice where col_id = 'd0682715-602d-44af-a6e0-085277130a5a' and inv_id = '205EDB7CDDFC4F1980299D3FD6C452A3'

--select * into DMS_Ecosystem_Backup_Table.dbo._txn_mobile_collection_invoice_20240629 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 = 'd0682715-602d-44af-a6e0-085277130a5a' and inv_id = '205EDB7CDDFC4F1980299D3FD6C452A3'

#5 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